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 :
Lead the design and development of interactive, visually compelling Power BI dashboards and reports for business stakeholders.Work closely with business users to translate analytical requirements into high-performing, self-service BI solutions.Implement advanced DAX calculations, time intelligence functions, and custom visuals to enhance insights.Ensure dashboards follow UI / UX best practices and adhere to corporate branding guidelines.Data Strategy & Integration :
Collaborate with data engineering and data science teams to define the enterprise data architecture roadmap.Integrate Power BI with various data sources SQL Server, Azure Synapse, Snowflake, Databricks, APIs, Excel, and SharePoint.Optimize data refresh schedules, gateway configurations, and workspace management to ensure high availability and reliability.Contribute to the modern data platform initiatives by leveraging Azure Data Lake, ADF, and Power Platform integration (Power Apps, Power Automate).Governance & Performance Optimization :
Define Power BI governance frameworks, including workspace organization, naming conventions, data lineage tracking, and content certification.Perform performance tuning for datasets, queries, and visuals to minimize load times and enhance user experience.Maintain documentation for data models, KPIs, measures, and architecture standards.Implement DevOps for Power BI including CI / CD pipelines using Azure DevOps for report deployment and version control.Leadership & Collaboration :
Lead and mentor a team of BI developers and analysts, providing technical guidance and career growth support.Collaborate with CIO, Data Engineering, and Business teams to align BI initiatives with organizational goals.Conduct stakeholder workshops to gather requirements, present prototypes, and drive adoption of analytics solutions.Ensure adherence to data privacy and compliance standards (GDPR, ISO, SOC).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 :
Familiarity with Python or R for data transformation and integration with Power BI.Exposure to Power Platform (Power Apps, Power Automate) for low-code solutions.Experience with cloud data warehouses like Snowflake, Redshift, or BigQuery.Understanding of machine learning models integration within Power BI reports.Certification :
Microsoft Certified : Power BI Data Analyst Associate (PL-300)Microsoft Certified : Azure Data Engineer Associate (DP-203)Soft Skills
Excellent communication and presentation skills.Strong problem-solving, analytical, and conceptual thinking abilities.Ability to manage multiple projects and stakeholders in a fast-paced environment.Team leadership and mentoring experience.Education : Bachelors or Masters degree in Computer Science, Information Technology, Data Analytics, or a related field.
Why Join Us?
Opportunity to architect enterprise-wide BI solutions that impact strategic decisions.Work in a modern Azure data environment with cutting-edge BI and analytics tools.Collaborative and innovative work culture that encourages learning and experimentation.Competitive compensation and career growth opportunities.(ref : hirist.tech)
