ASSOCIATE ARCHITECT - Azure

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

Job Summary

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