Application Administrator - Power BI

Job Summary

JOB DESCRIPTION

We are seeking an experienced Power BI Optimization & Administration Specialist responsible for designing, developing, and optimizing Power BI solutions while ensuring secure, efficient, and scalable workspace management within the Power BI and Fabric environment.

The ideal candidate will have strong expertise in DAX, Power Query (M), data modeling, and performance tuning, along with hands-on experience in Power BI administration tasks, including workspace creation, access control, and capacity monitoring.

In this Role, Your Responsibilities Will Be:

• 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
• Strong problem-solving and analytical skills, including the ability to troubleshoot and resolve technical issues
• 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
  
  

Who You Are:

You show a tremendous amount of initiative in tough situations; are exceptional at spotting and seizing opportunities. You observe situational and group dynamics and select best-fit approach. You make implementation plans that allocate resources precisely. You pursue everything with energy, drive, and the need to finish.

For This Role, You Will Need:

• 4-7 years of hands-on experience in Power BI optimization, administration and development.
• Strong troubleshooting and diagnostic skills using Performance Analyzer, DAX Studio, and Query Diagnostics.
• Good understanding of query folding, Mashup Engine, and dataflow refresh behavior.
• Familiarity with Power BI REST APIs for automation and governance.
• Knowledge of Row-Level Security (RLS) and its performance implications.
• Exposure to Power BI Admin Portal and capacity configuration.
• Experience working with Power BI Premium or Fabric capacities
• Capacity monitoring and performance analysis using the Fabric Capacity Metrics App.
  
  

Preferred Qualifications that Set You Apart:

• Bachelor’s degree or equivalent experience in Science with a technical background (MIS, Computer Science, Engineering or any related field)
• Good interpersonal skills using English, both spoken and written, as will be working with overseas team
• Microsoft Certifications (PL-300, PL-400, or Fabric-related) are a plus.
  
  

Our Culture & Commitment to You

At Emerson, we prioritize a workplace where every employee is valued, respected, and empowered to grow. We foster an environment that encourages innovation, collaboration, and diverse perspectives—because we know that great ideas come from great teams. Our commitment to ongoing career development and growing an inclusive culture ensures you have the support to thrive. Whether through mentorship, training, or leadership opportunities, we invest in your success so you can make a lasting impact. We believe diverse teams, working together are key to driving growth and delivering business results.

We recognize the importance of employee wellbeing. We prioritize providing competitive benefits plans, a variety of medical insurance plans, Employee Assistance Program, employee resource groups, recognition, and much more. Our culture offers flexible time off plans, including paid parental leave (maternal and paternal), vacation and holiday leave.