Power BI Architect - Data Analytics

Job Summary :

We are looking for an experienced Power BI Architect with 10+ years of experience in BI, Data Analytics, and Cloud Data Platforms. The ideal candidate will have strong hands-on expertise in Power BI, Microsoft Fabric, Azure Synapse Analytics, and Azure Cloud, with the ability to design scalable enterprise-grade analytics and reporting solutions.

The candidate should have strong experience in data architecture, semantic modeling, ETL/ELT, performance optimization, security, and integration of multiple enterprise data sources.

Key Responsibilities :

• Design and architect scalable Power BI and Microsoft Fabric solutions for enterprise analytics.

• Define end-to-end BI and data architecture using Microsoft Fabric, Azure Synapse Analytics, Azure Data Lake, and Power BI.

• Design and implement Lakehouse, Data Warehouse, OneLake, and Medallion Architecture using Microsoft Fabric.

• Develop enterprise-grade Power BI semantic models, dashboards, reports, and datasets.

• Design optimized star/snowflake schemas, dimensional models, and data marts.

• Implement and optimize data pipelines using Microsoft Fabric Data Factory / Azure Data Factory.

• Design data integration solutions across SQL Server, Azure, cloud, and other enterprise data sources.

• Develop and optimize Azure Synapse SQL pools, Spark workloads, and data pipelines.

• Implement Power BI Row-Level Security (RLS), Object-Level Security (OLS), workspace governance, and deployment strategies.

• Establish Power BI governance, administration, capacity management, and best practices.

• Perform Power BI and Fabric performance tuning, including DAX, data models, refreshes, and capacity optimization.

• Work with business and technical stakeholders to translate business requirements into scalable analytics solutions.

• Provide technical leadership and mentor BI/Data Engineering teams.

• Define standards for CI/CD, version control, deployment pipelines, and DevOps for Power BI and Fabric.

• Evaluate new Microsoft technologies and recommend solutions aligned with enterprise data strategy.

Mandatory Skills :

• 10+ years of experience in Business Intelligence, Data Analytics, or Data Warehousing.

• Strong expertise in Power BI and enterprise BI architecture.

• Hands-on experience with Microsoft Fabric.

• Strong experience with Azure Synapse Analytics.

• Strong knowledge of Microsoft Azure Cloud and Azure data services.