Power BI Architect - Azure Data Factory

About the Role :

We are seeking a highly skilled Power BI Architect to design, develop, and implement enterprise-grade business intelligence and analytics solutions.

The ideal candidate will have extensive experience with Power BI, DAX, SQL, Azure Data Services, and Data Modeling, along with a strong understanding of modern data architecture principles. You will be responsible for shaping the BI strategy, ensuring data reliability, scalability, and visual excellence to empower data-driven decision-making across the organization.

Key Responsibilities :

BI Architecture & Design :

• Design end-to-end Power BI architecture, including data modeling, dataflows, dataset management, and report governance.
• Architect semantic data models and implement best practices for DAX, performance optimization, and reusability.
• Develop data pipelines and integration patterns using Azure Data Factory (ADF), Synapse Analytics, and Databricks to enable seamless data transformation and loading.
• Define and maintain data governance, security models, and role-level access controls (RLS / OLS) in Power BI.

Dashboard Development & Visualization :

Data Strategy & Integration :

Governance & Performance Optimization :

Leadership & Collaboration :

Required Technical Skills :

Power BI Expertise : Advanced experience with Power BI Desktop, Power BI Service, DAX, Power Query (M Language), and Row-Level Security (RLS).

Data Modeling : Strong knowledge of Star / Snowflake schema, dimensional modeling, and data warehousing concepts.

SQL & Databases : Excellent SQL skills; experience with Azure SQL Database, Synapse Analytics, and on-prem SQL Server.

Azure Ecosystem : Experience with Azure Data Factory, Azure Data Lake, Azure Synapse, Databricks, and Logic Apps.

ETL / ELT Processes : Deep understanding of ETL design patterns, dataflows, and incremental refresh strategies.

DevOps & Deployment : Experience implementing CI / CD for Power BI using Azure DevOps or Git.

Visualization & Analytics : Expertise in KPI creation, storytelling through data, and building advanced analytical reports.

Preferred Skills :

Certification :

Soft Skills

Education : Bachelors or Masters degree in Computer Science, Information Technology, Data Analytics, or a related field.

Why Join Us?

(ref : hirist.tech)