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.
Sales Administrator managing order flow and ensuring compliance for public tenders. Supporting the Finance & Operations Manager at Theodo GovTech in Paris.
Electronic Administration Coordinator managing member benefit data and providing client support for Alberta Blue Cross. Collaborating with teams to ensure data integrity and enhance processes.
Order Administrator supporting sales organization by generating accurate orders for Ricoh's customers. Managing order lifecycle from booking through billing while ensuring customer satisfaction in high - paced environment.
Manufacturer Relations & Dealer Services Administrator at Lithia & Driveway supporting dealership lifecycle activities. Responsible for compliance with manufacturer, regulatory, and internal requirements across multiple projects and initiatives.
Pflegefachkraft in Berlin mit Schwerpunkt Dokumentation und Administration, verantwortlich für Erstellung der Pflegedokumentation und erfolgreiche Durchführung der Grundpflege.
Sales Administrator providing administrative support to Coates' North Business Unit sales team. Managing reporting, customer information, and compliance processes in a supportive team environment.
Part - Time Property Administrator assisting in the management of commercial property for Lincoln Property Company. Key responsibilities include tenant support, invoicing, and vendor management.
Administrator providing crucial support in Manufacturer Relations & Dealer Services at Lithia & Driveway. Ensuring organization, compliance, and efficiency in dealership lifecycle activities.
Senior Analyst overseeing payroll administration at LWSA, ensuring compliance and operational efficiency across multiple services. Collaborating with teams on data management and legal adherence.