ASSOCIATE ARCHITECT - Azure

Happiest Minds Technologies; Pune District; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Happiest Minds Technologies is seeking aData Engineer / Analytics Engineer to design and optimize data pipelines using ADLS, ADF, Fabric, and Spark. You will build Python-based processing, develop robust data models, and deliver enterprise Power BI reports.

The role demands 8+ years in data engineering, hands-on Fabric and Power BI experience, and proficiency with MSBI components (SQL Server, SSIS, SSAS, SSRS). Collaboration across teams is essential in a fast-paced environment.

Qualifications

• 8+ years of experience in data engineering/analytics engineering.
• Hands-on experience with Microsoft Fabric and Power BI in a modern data platform.
• Experience with MSBI stack including SQL Server, SSIS, SSAS, and SSRS.

Responsibilities

• Design, develop, and maintain scalable data pipelines using ADLS, ADF, Fabric, and Spark.
• Build and optimize data processing solutions with Python (PySpark preferred).
• Implement Medallion Architecture for structured data processing.
• Develop restartable, fault-tolerant pipelines with logging and audit frameworks.
• Manage source control and CI/CD in Azure DevOps.
• Write and optimize complex SQL queries and data transformations.
• Design and manage Power BI datasets for enterprise reporting.
• Create interactive Power BI dashboards and reports; implement star/snowflake schemas.
• Ensure data quality, governance, and security; collaborate with cross-functional teams.
• Troubleshoot performance issues; support legacy MSBI solutions and migrations to Fabric.

Skills

Data engineering

SQL proficiency

Python

Power BI

Azure DevOps

Communication

Tools

Azure Data Lake Storage

Azure Data Factory

Microsoft Fabric

Apache Spark / PySpark

SSIS

SSAS

SSRS

SQL Server

Power BI sharing datasets

Delta Lake

Job description

Data Engineer / Analytics Engineer (Azure + Fabric + Power BI) ? Job Description

We are seeking a highly skilled Data Engineer / Analytics Engineer with strong experience in Azure Data Lake Services (ADLS), Azure Data Factory (ADF), Microsoft Fabric, Apache Spark, and Python. The ideal candidate will have current hands-on experience in Microsoft Fabric and Power BI, along with a solid foundation in traditional Microsoft BI (MSBI) technologies.

Key Responsibilities

• Design, develop, and maintain scalable data pipelines using Azure Data Lake (ADLS), Azure Data Factory (ADF), Microsoft Fabric, and Apache Spark
• Build and optimize data processing solutions using Python (PySpark preferred)
• Implement Medallion Architecture (Bronze, Silver, Gold layers) for structured data processing
• Develop restartable, fault‑tolerant pipelines with robust audit and logging frameworks
• Develop and manage source control and CI/CD pipelines in Azure DevOps (ADO)
• Write and optimize complex SQL queries, stored procedures, and data transformations
• Design and manage shared and certified Power BI datasets for enterprise reporting
• Design and deliver interactive and performant Power BI dashboards and reports
• Implement data modeling techniques (star schema, snowflake schema)
• Ensure data quality, governance, and security
• Collaborate with cross‑functional teams
• Troubleshoot performance issues
• Support, maintain, and enhance legacy MSBI solutions using SQL Server, SSIS, SSAS, and SSRS
• Design and develop ETL workflows using SSIS and manage data models in SSAS
• Develop and maintain enterprise reports using SSRS
• Participate in modernization and migration of MSBI solutions to Microsoft Fabric architecture

Required Skills & Qualifications

• Azure Data Lake Storage (ADLS)
• Azure Data Factory (ADF)
• Microsoft Fabric
• Apache Spark / PySpark
• Python for data engineering
• Azure DevOps (ADO) ? source control & CI/CD pipelines
• Advanced SQL (complex queries, performance tuning, ETL logic)
• Power BI (shared datasets, DAX, modeling, visualization)
• Strong experience with Microsoft BI (MSBI) stack including SQL Server, SSIS, SSAS, and SSRS
• Experience developing ETL pipelines using SSIS, data models using SSAS, and reports using SSRS
• Data warehousing concepts and Medallion architecture

Experience

8+ years of overall experience in data engineering / analytics engineering

Current hands‑on experience with Microsoft Fabric and Power BI in a modern data platform

Prior experience with Microsoft BI (MSBI) stack including SQL Server, SSIS, SSAS, and SSRS

Preferred Skills

• Exposure to Lakehouse architecture / Delta Lake
• Knowledge of data governance and cataloging tools
• Experience with real‑time or streaming data processing

Soft Skills

• Strong problem‑solving and analytical thinking
• Ability to work in a fast‑paced, agile environment
• Effective communication and stakeholder management skills

Azure, Azure Service Fabric, Power BI