Power BI Architect - SQL

Position Overview :

The Power BI Architect is a semantic modeling expert responsible for designing and optimizing enterprise-grade tabular models and broader Fabric solutions.

The role is focused on backend modeling and DAX, with the goal of ensuring high performance, scalability, and simplicity for end users within a self-service environment.

This Architect will be a key advisor to other Power BI developers, helping to solve modeling challenges while upholding standards and ensuring alignment with best practices.

The Architect must bring experience with CI/CD tools to operate effectively in this environment.

Key Responsibilities :

Semantic Modeling and Architecture :

- Design performant, scalable tabular models using Import, DirectQuery, and hybrid storage modes.

- Implement composite models, aggregation tables, calculation groups, and other Fabric services and solution architectures.

- Use Tabular Editor (v2/v3), Best Practice Analyzer, and ALM Toolkit to enforce modeling standards and improve maintainability.

DAX Engineering and Optimization :

- Write efficient and complex DAX measures for use across business domains.

- Optimize DAX logic using Performance Analyzer, VertiPaq Analyzer, and DAX Studio.

- Implement row-level and object-level security models as needed.

Collaboration and Technical Oversight :

- Provide architectural guidance and code reviews for junior and senior Power BI developers.

- Maintain consistency and alignment with enterprise modeling principles and performance standards.

- Document modeling approaches, patterns, and usage conventions for development teams.

- Develop Standard Operating Procedures (SOPs) where needed.

Platform Integration and Development Practices :

- Operate within established DevOps frameworks and deployment pipelines using Azure DevOps and Git.

- Ensure semantic models are developed with CI/CD readiness and follow source control best practices.

- Collaborate with platform and infrastructure teams as needed for model deployment, refresh strategies, and access control.

Required Skills and qualifications :

Education :

- Bachelors degree in computer science, Information Systems, Data Analytics, or a related field.

- Masters degree preferred.

Experience :

- Minimum of 7 years working with Power BI and the Tabular Object Model (TOM).

- Proficiency with Tabular Editor, DAX Studio, ALM Toolkit, and model performance tuning tools.

- Strong experience with SQL and deep understanding of relational and analytical databases.

- Hands-on experience working in environments with CI/CD pipelines using Azure DevOps and Git.

- Familiarity with broader suite of Fabric services, such as Delta Lake, Lakehouse, and notebooks with Semantic Link Labs a plus.

Skills :

- Expert-level DAX and semantic model design skills.

- Strong command of tabular architecture, partitions, relationships, and data refresh strategies.

- Ability to coach developers and communicate technical concepts clearly.

- Comfortable working independently on backend development with limited involvement in visual/report design.

Certifications :

- Microsoft Certified : Power BI Data Analyst Associate or equivalent preferred.

- Azure Data certifications are a plus.