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
Azure Data Factory, Azure Data lake, Azure Service Fabric, Azure DevOps
