Power BI Architect - Azure Data Factory

ConfidentialPune, India

6 days ago

Job description

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)

Skills Required

Data Modeling, Power Bi, Power Query, Sql, Azure Data Factory, Azure Data Lake, Databricks, Dax, Azure Devops, Etl

Create a job alert for this search

Data Azure Data • Pune, India

Related jobs

Promoted

Data Solution Architect

Persistent Systemspune, maharashtra, in

The Architect will lead the design and implementation of scalable data solutions.This includes architecting cloud-native data pipelines, integrating tagging logic, and ensuring high-performance dat...Show moreLast updated: 19 days ago

Promoted

Power BI Developer

Verdantaspune, maharashtra, in

Join Verdantas – A Top #ENR 81 Firm,.You will be responsible for transforming raw data into actionable insights through the design and development of interactive dashboards, reports, and data model...Show moreLast updated: 24 days ago

Promoted

iLink Digital - Power BI Architect - Power Query M

Ilink Systems Pvt LtdPune

Key Responsibilities : 1.Discovery & Assessment : - Analyze current sales workflows, KPIs, and reporting frameworks.Assess GenAI system capab...Show moreLast updated: 30+ days ago

Promoted

Senior Power BI Developer

CYAN360Pune, IN

Role : Senior Power BI Developer.Work Timings : 4 : 30 PM to 12 : 30 AM IST.Must have atleast 7 years of experience with Power BI. Need someone who has worked on SAP Data or BW Hana Data.Data Analysis Exp...Show moreLast updated: 1 day ago

Promoted
New!

Associate Architect - Data

Quantiphipune, maharashtra, in

Job Title : Associate Architect - Data (Power BI).Location : Bangalore / Mumbai / Hybrid.We are seeking a skilled and proactive. The ideal candidate will be responsible for designing, developing, and p...Show moreLast updated: 9 hours ago

Promoted

Senior Power BI Developer

KPI PartnersPune, IN

KPI Partners is seeking a skilled Data Analyst with expertise in Power BI and Python to join our dynamic team.The ideal candidate will have a strong analytical background and experience in data vis...Show moreLast updated: 2 days ago

Promoted

Power BI Developer

Aptino, Inc.pune, maharashtra, in

Collaborate with business users to.Gather business requirements and prepare.Modify existing dashboards by adding or adjusting. Work with stakeholders to ensure.Strong hands-on experience with.DAX (D...Show moreLast updated: 2 days ago

Promoted

Sr. Power BI Developer

OnPoint Insightspune, maharashtra, in

Looking for a strong Power BI Sr.Developer with a total of 7-8 years of IT experience and having at least 4+ years of good experience in Power BI. RESPONSIBILITIES & SPECIFIC ACCOUNTABILITIES.Respon...Show moreLast updated: 2 days ago

Promoted

Azure Cloud Architect

Persistent Systemspune, maharashtra, in

We are seeking an experienced Azure Data Cloud Architect to design, implement, and optimize cutting-edge data solutions on Microsoft Azure. You will collaborate with cross-functional teams to transl...Show moreLast updated: 24 days ago

Promoted

Power BI Architect

ConfidentialPune

Understand business requirements in the BI context and design data models to transform raw data into meaningful insights. Create dashboards and interactive visual reports using Power BI.Identify key...Show moreLast updated: 30+ days ago

Promoted
New!

Power BI Architect

Insight Globalpune, maharashtra, in

We are seeking a highly skilled BI Architect to join our client’s team in India.The ideal candidate will have a strong background in implementing enterprise-level reporting solutions as part of a b...Show moreLast updated: 9 hours ago

Promoted

Data Architect

Tech Mahindrapune, maharashtra, in

Strong experience architecting and delivering.Proficiency in Azure services including.Azure Synapse Analytics, Azure Data Factory, Azure Data Lake Storage, Azure Databricks.Python, Spark, or relate...Show moreLast updated: 2 days ago

Promoted

Azure Data Architect

Programmers.ioPune, Maharashtra, India

Job Description : Job Title : Azure Data Architect Location : Hyderabad, pune (hybrid) Experience required : 12+ years Role Overview : We are seeking a highly experienced Senior Azure data architec...Show moreLast updated: 30+ days ago

Promoted

BI Architect – Tableau & Power BI

Persistent Systemspune, maharashtra, in

The BI Architect is responsible for designing, developing, and implementing scalable and efficient Business Intelligence (BI) solutions using tools like Power BI, Tableau, and modern data platforms...Show moreLast updated: 19 days ago

Promoted

Power BI Architect - Azure Data Factory

IT FirmPune

About the Role : We are seeking a highly skilled Power BI Architect to design, develop, and implement enterprise-grade business intelligence and a...Show moreLast updated: 28 days ago

Promoted

BI Architect - Tableau & Power BI

Persistent SystemsPune, Haveli

Promoted
New!

Azure Data Architect

Domnic Lewispune, maharashtra, in

Architect and implement scalable ELT / ETL pipelines using Azure Data Factory (ADF).Develop and optimize data processing and analytics workflows in Azure Databricks using PySpark and Delta Lake.Imple...Show moreLast updated: 9 hours ago

Promoted

Data Architect

Persistent Systemspune, maharashtra, in

We are seeking a highly skilled and experienced Azure Databricks Architect to lead the design, development, and implementation of scalable data solutions using Azure Databricks.This role involves w...Show moreLast updated: 21 days ago