Senior Analytics Engineer - Power BI/SQL/ETL

About the Role :

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.