Job Description

Job Summary

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.