Author advanced DAX/MDX, complex Power Query (M), and T-SQL, and build proof-of-concept models that prove out the architecture before handing off to development.
Review and guide semantic models and report architecture built across Insights Engineering and partner towers, and contribute to high-priority initiatives like the Power BI Center of Excellence and Lakehouse consumption strategy.
Serve as the technical sounding board across EDAIx—moving across projects to unblock the team, troubleshoot live issues, and pair on complex modeling problems.
Partner with Data Engineering, Data Product, and Data Governance to shape upstream structures that simplify downstream analytics, and translate decisions into clear documentation, patterns, and reusable templates.
Define and enforce semantic layer governance (certified datasets, metric definitions, version control, release standards), champion architectural quality and accountability for what reaches production, and track the Microsoft analytics roadmap (Fabric, Direct Lake, Copilot for Power BI, semantic link) to recommend adoption.
What you’ll need (Required)
Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, or a related discipline.
8+ years of experience in business intelligence, analytics engineering, or data architecture, with meaningful time spent in an architect level capacity.
Deep hands on expertise with Power BI semantic models, including advanced DAX, Power Query (M), and Tabular Editor.
Strong experience designing and tuning tabular models in Azure Analysis Services or SQL Server Analysis Services.
Working knowledge of multidimensional OLAP cubes and MDX, with the ability to support and modernize legacy cube workloads.
Proven experience designing dimensional models (star schema, fact and dimension design, slowly changing dimensions, aggregations).
Strong SQL skills for data profiling, query design, and source side optimization.
Demonstrated success diagnosing and resolving complex performance issues across the BI stack.
What else we look for (Preferred)
Experience with Microsoft Fabric, Direct Lake, OneLake, and Lakehouse based consumption architectures.
Experience integrating Power BI with Snowflake, Databricks, Azure Synapse, or Azure SQL.
Familiarity with CI/CD for analytics (Git, TMDL, deployment pipelines, Tabular Editor automation).
Exposure to Power BI Embedded, Power BI REST APIs, and tenant or capacity administration.
Experience working in regulated industries such as medical devices, pharmaceuticals, or healthcare.
Experience contributing to or operating a Power BI Center of Excellence
Strong troubleshooting instincts and the patience to find the real root cause, not just the visible symptom.
Confident communicator who can explain complex modeling and performance concepts to both engineers and business stakeholders.
Comfortable jumping between projects, shifting context quickly, and supporting the team where the need is greatest.
Collaborative by default, with a track record of mentoring developers and elevating the work of the people around them.
High standards for craftsmanship, documentation, and delivery quality.
Clear point of view on tool selection, with the judgment to recommend the right approach for each problem rather than defaulting to a single technology.
Comfortable working across global time zones and partnering with team members in Prague, Pune, Irvine, and other Edwards locations.
Adheres to all company rules and requirements, including Environmental Health and Safety standards, and takes responsibility for protecting people and the environment within their area of control.
