Senior Analytics Engineer

We are looking for a hands-on Senior Analytics Engineer with strong expertise in Power BI, SQL, and modern data engineering platforms. The candidate will be responsible for building scalable enterprise analytics solutions, developing ETL/ELT pipelines, designing data models, and delivering high-performance Power BI dashboards and reports using Microsoft Fabric and Azure data services.

Key Responsibilities

Design, develop, and maintain ETL/ELT pipelines using Microsoft Fabric or similar cloud data platforms.

Build and manage Lakehouse and Data Warehouse solutions integrating ERP and enterprise data sources.

Develop complex SQL queries, transformations, data quality checks, and performance optimization.

Design dimensional data models, Star Schema, Fact and Dimension tables, and Gold-layer datasets.

Develop and optimize Power BI dashboards, reports, DAX measures, Power Query, and semantic models.

Implement Row-Level Security (RLS) and ensure data governance across reporting solutions.

Work with Fabric Lakehouse, Warehouse, Data Factory, and Dataflows Gen2.

Troubleshoot production issues and optimize analytics workloads.

Collaborate with business stakeholders and lead technical discussions.

Mentor junior team members and drive analytics engineering best practices.

Mandatory Skills

6–10 years of experience in Data Engineering, BI, Analytics Engineering, or Data Warehousing.

Strong hands-on experience in Power BI, including DAX, Power Query, Semantic Models, and dashboard development.

Strong SQL development and query optimization skills.

Experience in ETL/ELT pipeline development.

Hands-on experience with Microsoft Fabric, Azure Data Services, Databricks, or similar cloud platforms.

Strong understanding of Dimensional Modeling, Star Schema, Fact and Dimension tables.

Experience supporting enterprise-level BI and reporting solutions.

Good to Have

Microsoft Fabric Data Factory and Dataflows Gen2.

Fabric Lakehouse, Warehouse, and Direct Lake.

Medallion Architecture (Bronze, Silver, Gold).

Python, PySpark, Spark, and Delta Lake.

Azure DevOps, Git, and CI/CD.

Microsoft Purview and Data Governance.

Preferred Candidate Profile

Candidates should have strong hands-on Power BI development experience combined with SQL and data engineering capabilities. Experience with Microsoft Fabric is highly preferred. Candidates with only Power BI report development experience and no exposure to data engineering or data modeling may not be suitable.