Power Bi Architect

Persistent; Pune District; Hybrid; INR 4,000,000 - 6,800,000; Full time

Benefits offered by this job

Competitive salary

Talent development & certifications

Cutting-edge technologies

Long service awards

Annual health check-ups

Group term life & Mediclaim

Job summary

Persistent is seeking an experienced Data/BI Architect to lead enterprise Power BI architecture and semantic modelling. You will drive star schemas, governance, and performance tuning while collaborating with business, data, cloud, and engineering teams.

The role emphasizes hands-on ownership of enterprise BI platforms, integration with AWS data sources, and CI/CD for Power BI assets, enabling scalable analytics across the organization.

Qualifications

• Power BI Premium architecture and report development.
• Enterprise semantic modelling and dimensional data modelling.
• Advanced DAX, Power Query, and performance optimization.
• Tabular Editor and DAX Studio expertise.
• GitHub version control and BI CI/CD.
• SQL and enterprise data warehousing.
• AWS Redshift and S3 integration.
• Row-level security (RLS) and governance.
• Experience delivering large-scale enterprise BI implementations.
• Microsoft certifications.
• Basic Python coding knowledge.
• Strong stakeholder management and analytical thinking.
• Hands-on ownership of enterprise Power BI architecture.
• Production semantic and dimensional models.
• Performance tuning with DAX Studio and Tabular Editor.
• CI/CD for Power BI assets.
• Power BI Premium and gateways integration.

Responsibilities

• Design and implement dimensional data models (star schemas).
• Mandatory experience in Tabular editor.
• Build and govern enterprise-scale semantic models and datasets.
• Define modelling standards and semantic modelling best practices.
• Architect scalable Power BI Premium solutions for analytics.
• Develop advanced DAX and optimize performance with DAX Studio.
• Integrate Power BI with Redshift, S3, and gateways.
• Implement OLS/RLS, governance and security standards.
• Establish GitHub-based CI/CD pipelines for Power BI assets.
• Collaborate with business, data, cloud and engineering teams.

Skills

Power BI Premium

DAX

Power Query

Tabular Editor

DAX Studio

GitHub CI/CD

SQL

Data warehousing

AWS Redshift

S3

Row-level Security

Governance

Power BI gateways

Python basics

Stakeholder management

Analytical thinking

Problem-solving

Power BI architecture

Enterprise BI delivery

Education

Microsoft certifications

Tools

Tabular Editor

DAX Studio

GitHub

CI/CD

Amazon Redshift

S3

Job description

About Position:

We are seeking an experienced Data / BI Architect to lead enterprise Power BI architecture, dimensional and semantic modelling, performance optimization, governance, and BI DevOps. The ideal candidate will bring hands-on expertise in Power BI Premium, DAX, Power Query, Tabular Editor, DAX Studio, GitHub-based CI/CD, SQL, data warehousing, and AWS data platforms such as Amazon Redshift and S3.

• Role: Power BI Architect
• Location: All Persistent Locations
• Experience: 10+ Years
• Job Type: Full Time Employment

What You'll Do:

• Design and implement dimensional data models, including star schemas and fact-and-dimension structures.
• Mandatory experience in Tabular editor.
• Build and govern enterprise-scale semantic models, Power BI datasets, reusable measures, and hierarchies.
• Define modelling standards and apply semantic-modelling best practices using Tabular Editor Best Practice Analyzer.
• Architect scalable Power BI Premium solutions for enterprise analytics.
• Develop advanced DAX and optimize model, report, refresh, and query performance using DAX Studio and Tabular Editor.
• Integrate Power BI with Amazon Redshift, S3, and enterprise gateways.
• Implement object-level security, row-level security, governance, compliance, and semantic-layer standards.
• Establish GitHub-based version control and CI/CD pipelines for Power BI assets and deployments.
• Collaborate with business, data, cloud, and engineering teams to translate requirements into scalable BI solutions.
• Stay current with Microsoft Power BI releases, platform capabilities, and industry practices.

Expertise You'll Bring:

• Power BI Premium architecture, report design, and development
• Enterprise semantic modelling and dimensional data modelling
• Advanced DAX, Power Query, and performance optimization
• Tabular Editor, including Best Practice Analyzer, and DAX Studio
• GitHub version control and BI CI/CD
• SQL and enterprise data warehousing
• AWS services, particularly Amazon Redshift and S3
• Power BI gateways, security, governance, OLS, and RLS
• 12+ years of experience in data, analytics, BI, or architecture roles.
• Proven delivery of large-scale enterprise BI implementations.
• Relevant Microsoft certifications.
• Basic Python coding knowledge.
• Strong stakeholder management, analytical thinking, and problem-solving skills.
• Hands-on ownership of enterprise Power BI architecture, not only report development.
• Evidence of building semantic and dimensional models used in production.
• Practical performance tuning using DAX Studio, Tabular Editor, and model-design techniques.
• Implementation of GitHub version control and CI/CD for Power BI assets.
• Experience with Power BI Premium, governance, gateways, OLS/RLS, and AWS data sources.

Benefits:

• Competitive salary and benefits package
• Culture focused on talent development with quarterly growth opportunities and company-sponsored higher education and certifications
• Opportunity to work with cutting-edge technologies
• Employee engagement initiatives such as project parties, flexible work hours, and Long Service awards
• Annual health check-ups
• Insurance coverage: group term life, personal accident, and Mediclaim hospitalisation for self, spouse, two children, and parents

Values-Driven, People-Centric & Inclusive Work Environment:

Persistent is dedicated to fostering diversity and inclusion in the workplace. We invite applications from all qualified individuals, including those with disabilities, and regardless of gender or gender preference. We welcome diverse candidates from all backgrounds.

• We support hybrid work and flexible hours to fit diverse lifestyles.
• Our office is accessibility-friendly, with ergonomic setups and assistive technologies to support employees with physical disabilities.
• If you are a person with disabilities and have specific requirements, please inform us during the application process or at any time during your employment.

"Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind."