Microsoft Power BI Architect

HCLTech; Bengaluru; On-site; INR 3,500,000 - 7,000,000; Full time

Job summary

HCLTech seeks a highly experienced Power BI Technical Architect to lead the design and delivery of enterprise analytics solutions using Power BI and Microsoft Fabric. You will translate business requirements into scalable BI architecture and establish best practices for governance, security, and performance.

Responsibilities include owning end-to-end architecture, designing semantic models, evaluating storage patterns, guiding development teams, and ensuring compliance with the enterprise data

Qualifications

• 10+ years in BI/Data Analytics/Data Warehousing or Data Platform delivery with enterprise exposure.
• 7+ years hands-on Power BI including semantic modeling, DAX, deployment pipelines, and performance tuning.
• Experience with Microsoft Fabric including Lakehouse, OneLake, Dataflows Gen2, Pipelines and Fabric workspace design.
• Strong SQL skills across relational databases, data warehouses, and large-scale data environments.
• Understanding of governance, security, access management, data lineage, and BI lifecycle management.

Responsibilities

• Own end-to-end architecture for Power BI and Fabric-based analytics across enterprise environments.
• Design scalable semantic models using dimensional modeling and enterprise standards.
• Define architecture blueprints, data models, workspace structures, deployment patterns, and governance frameworks.
• Evaluate storage/connectivity patterns: Import, DirectQuery, Direct Lake, Composite Models, Aggregations, incremental refresh.
• Lead Fabric adoption across Lakehouse, Warehouse, OneLake, Dataflows Gen2, Pipelines, Notebooks, and Power BI models.
• Ensure BI solutions meet performance, security, data quality, maintainability, and compliance.

Skills

Power BI

Microsoft Fabric

DAX

SQL

Data modeling

Data governance

Performance tuning

Security

ETL/ELT

Tools

Power BI Desktop

Power BI Service

Power Query

SQL Server

Fabric tools

Job description

We are seeking a highly experienced Power BI Technical Architect / Microsoft Fabric Architect to lead the design, modernization, and delivery of enterprise-grade analytics solutions. This role requires strong hands-on expertise in Power BI, Microsoft Fabric, semantic modeling, DAX, SQL, data architecture, performance optimization, and governance.

The ideal candidate will act as a technical authority who can translate business requirements into scalable BI architecture, define best practices, guide development teams, and ensure analytics platforms are secure, reliable, performant, and aligned with enterprise data strategy.

Key Responsibilities:

• Own end-to-end architecture for Power BI and Microsoft Fabric-based analytics solutions across enterprise environments.
• Design scalable semantic models using dimensional modeling, star schema, reusable datasets, calculation groups, and enterprise-grade modeling standards.
• Define architecture blueprints, HLDs, LLDs, data model designs, workspace structures, deployment patterns, and governance frameworks.
• Evaluate and recommend the right storage and connectivity patterns, including Import, DirectQuery, Direct Lake, Composite Models, Aggregations, and incremental refresh.
• Lead Microsoft Fabric adoption across Lakehouse, Warehouse, OneLake, Direct Lake, Dataflows Gen2, Pipelines, Notebooks, and Power BI semantic models.
• Ensure all BI solutions meet enterprise standards for performance, scalability, security, data quality, maintainability, and compliance.

Power BI, Fabric & Data Engineering Expertise:

• Build and optimize complex Power BI reports, dashboards, paginated reports, semantic models, DAX measures, Power Query transformations, and dataflows.
• Develop efficient DAX calculations, optimize model performance, troubleshoot refresh issues, and improve report responsiveness using best practice tuning techniques.
• Work with SQL databases, data warehouses, lake houses, APIs, cloud data platforms, and enterprise data sources to deliver reliable analytics solutions.
• Design medallion-style analytical layers and curated reporting datasets for downstream consumption by Power BI and business users.
• Implement security concepts including Row-Level Security, Object-Level Security, workspace access strategy, sensitivity labels, and data governance controls.

Leadership, Governance & Delivery:

• Partner with business stakeholders, data engineers, application teams, and leadership to convert business needs into robust analytical solutions.
• Mentor developers and analysts on Power BI, DAX, modeling, Fabric capabilities, performance optimization, and governance best practices.

Required Skills & Experience:

• 10+ years of experience in Business Intelligence, Data Analytics, Data Warehousing, or Data Platform delivery, with strong enterprise implementation exposure.
• 7+ years of hands-on Power BI experience, including semantic modeling, DAX, Power Query, Power BI Service, deployment pipelines, and performance tuning.
• Practical experience with Microsoft Fabric, including Lakehouse, Warehouse, OneLake, Direct Lake, Dataflows Gen2, Pipelines, and Fabric workspace design.
• Strong SQL skills with experience in relational databases, data warehouses, lakehouse architecture, ETL/ELT pipelines, and large-volume data environments.
• Strong understanding of governance, security, access management, data lineage, quality controls, and enterprise BI lifecycle management.

Preferred / Advanced Skills:

• Exposure to Azure Data Factory, Synapse, Databricks, Spark, Python, REST APIs, Power BI automation, Power Apps, and Power Automate integration.
• Experience with Power BI Copilot, Microsoft Fabric Copilot, GenAI-assisted analytics, responsible AI practices, and automation-led development acceleration.

Preferred Certifications:

• Microsoft Certified: Fabric Analytics Engineer Associate or equivalent Fabric certification.

Expected Outcomes:

• Establish a scalable, governed, and high-performing Power BI / Fabric analytics ecosystem.
• Improve report performance, model reusability, data trust, governance maturity, and delivery consistency across BI initiatives.