Power BI Optimization & Administration Specialist at Emerson responsible for secure and efficient management of Power BI solutions and workspace in hybrid environment. Required strong skills in DAX, Power Query, and data modeling.
Responsibilities
Designing, developing, and optimizing Power BI solutions while ensuring secure, efficient, and scalable workspace management within the Power BI and Fabric environment.
Responsibility for hands-on Power BI Optimization, Administration, and Development.
Workspace creation, access control, and capacity monitoring.
Perform end-to-end performance tuning by optimizing DAX calculations and Power Query transformations.
Analyze data modeling and ensure adherence to best practices.
Requirements
4–7 years of hands-on experience in Power BI Optimization, Administration and Development.
Expertise in DAX — optimized measure creation and performance-efficient time intelligence.
Power Query (M language) — advanced transformations, query folding, and dataflows.
Data modeling — star/snowflake schema design and aggregation strategies.
Proven experience with Power BI Service Administration: workspace creation and management.
Assigning roles, managing permissions, and granting access to users and groups.
Capacity monitoring and performance analysis using the Fabric Capacity Metrics App.
Perform end-to-end performance tuning — query optimization, data model refinement, and reducing dataset refresh times.
Analyze and optimize DAX calculations and Power Query transformations to enhance performance and maintain query folding.
Implement best practices in data modeling (star schema, aggregations, relationships, surrogate keys).
Understanding of Power BI Gateways, Incremental Refresh, Aggregations, and Deployment Pipelines.
Strong troubleshooting and diagnostic skills using Performance Analyzer, DAX Studio, and Query Diagnostics.
Good understanding of query folding, Mashup Engine, and dataflow refresh behavior.
Experience with SQL Server / Azure SQL / Synapse, including basic query optimization.
Experience with Azure services like Azure Data Factory, Azure Data Lake, and Azure SQL is an advantage.
Experience with Power BI and SQL Server Management Studio (SSMS), including database administration, and query optimization.
Ability to work independently and in a team environment, good communication and collaboration skills.
Trainee Administration Officer at Legal Aid providing administrative support in legal settings. Gaining hands - on experience while completing a Diploma in Paralegal Services.
SLIM Administrator supporting the Quality Team at Perrigo by managing Stability Laboratory Information Management System. Responsibilities include sample preparation, data accuracy, and compliance.
IT - Systemadministrator overseeing network and system infrastructure for manufacturing company. Responsible for configuration, support, and maintenance of IT systems and services.
IT System Administrator providing technical support and server maintenance at isLOGIC AG. Collaborating with the team to diagnose and resolve customer issues effectively in a dynamic environment.
Supervisor de Administración overseeing procurement processes and administrative operations for Financiera Oh!. Ensuring efficient stock management, supplier negotiation, and administrative service continuity.
Senior Administrator providing vital administrative support to brokers and clients in Commercial Real Estate. Involves marketing efforts, transaction communication, and project management in a dynamic environment.
Electrical Construction Administrator ensuring design intent and compliance in building projects for AtkinsRéalis. Collaborating with engineers and contractors while maintaining quality and safety standards.
IT Administrator supporting IT operations and network management for Projektron GmbH's offices in Germany. Ensuring secure and efficient IT infrastructure for over 130 employees.
As IT Systemadministrator at WIN, you manage IT processes and tools across multiple locations. You ensure reliable IT functionality and facilitate change for teams in Aachen, Berlin, and Köln.
IT - Systemadministrator responsible for server and network infrastructure maintenance at wunderow IT GmbH. Collaborating on exciting digitalization projects for notable companies in the region.