Power BI Architect

Summit Consulting Services; Hyderabad; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

A leading consulting firm in Hyderabad is seeking a Power BI Architect to design and optimize enterprise-grade tabular models. The ideal candidate will have extensive experience in DAX, power BI, and backend modeling. Responsibilities include offering architectural guidance to developers and ensuring performance standards. This role requires a strong understanding of CI/CD practices and deployment strategies using Azure DevOps. A commitment to collaboration and best practices is essential.

Qualifications

• Minimum 7 years working with Power BI and the Tabular Object Model.
• Proficiency with modeling performance tuning tools.
• Strong experience with SQL and relational databases.

Responsibilities

• Design scalable tabular models using various storage modes.
• Optimize DAX logic using Performance Analyzer and DAX Studio.
• Provide architectural guidance for Power BI developers.

Skills

Expert-level DAX skills

Semantic model design

Strong command of tabular architecture

Ability to coach developers

Comfortable with backend development

Education

Bachelor’s degree in Computer Science

Master’s degree preferred

Tools

Power BI

Tabular Editor

DAX Studio

ALM Toolkit

Azure DevOps

Git

Job description

Get AI-powered advice on this job and more exclusive features.

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

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field. Master’s degree preferred.
• 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.

At Summit Consulting, we are committed to creating a workplace where every individual is valued for their unique contributions, experiences, voices, and backgrounds. By embracing these principles, we aim to positively impact our business and the communities we serve, creating a lasting legacy where everyone can thrive.