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.
Commission Administrator responsible for calculating commissions and handling queries for sales and channel partners. Collaborating with internal teams to ensure clarity and accuracy in financial processes.
Site Administrator overseeing gate passes and administration for a site - based project in Riyadh. Responsible for coordinating with personnel and ensuring compliance with safety protocols.
Administrator in Service Goldschmiede managing repairs and guarantees for CHRIST, the leading omnichannel jeweler. Engage with customers through various service channels and ensure quality control in repairs.
Administration of iTWO environment and support for users within a construction engineering firm. Role includes training users, managing software development, and ensuring quality assurance processes.
Director of Global Administration at Duke University managing global program support operations. Ensuring alignment with international strategies and service excellence for faculty, students, and staff.
Student worker supporting Global Mobility Administration processes for international employee deployments. Collaborating with specialists to ensure smooth workflow.
Assistenz in der Verwaltung bei HTM Hydro Technology Motors GmbH, Unterstützung des Gründerteams in einem innovativen Technologieumfeld zur Optimierung interner Abläufe.
IT - Support and System Administrator at B&O Bau supporting workplace systems and maintaining IT infrastructure. Involves system monitoring and technical onboarding of new employees.