Senior Data Analytics Engineer
Role details
Job location
Tech stack
Job description
As a Senior Data Analytics Engineer, you will design, build, and support scalable analytical data solutions using Microsoft Fabric. This role focuses on hands-on development of well-modeled data assets and analytics solutions while collaborating closely with business partners and technical peers.
The ideal candidate brings strong technical depth in SQL, dimensional modeling, and Fabric, paired with solid customer engagement skills and a practical approach to ML and AI capabilities.
Key Job Responsibilities
-
Design and implement dimensional data models, including fact tables and slowly changing dimensions, to support analytics, reporting, and downstream consumption.
-
Develop and maintain data pipelines in Microsoft Fabric, supporting ingestion, transformation, and modeling using a medallion architecture (Bronze, Silver, Gold).
-
Build and maintain transformations using SQL, SparkSQL, PySpark, and Python within Fabric Notebooks.
-
Apply sound database and data modeling practices to ensure performant, reliable, and maintainable analytics solutions.
-
Implement machine learning and AI solutions using tools available within the Microsoft Fabric and Foundry ecosystem, with guidance as needed for more advanced use cases.
-
Partner with business stakeholders and internal customers to gather requirements, clarify needs, and translate them into effective data solutions.
-
Participate in Git-based version control and CI/CD workflows, following established team practices.
-
Follow data governance, security, and compliance standards when designing and delivering data, ML, and AI solutions.
-
Contribute to team documentation, data standards, and reusable patterns.
-
Troubleshoot and enhance existing pipelines, data models, and notebooks to improve reliability and performance.
Requirements
-
5+ years of experience in a Data and Analytics Engineer role.
-
Strong experience with SQL and dimensional modeling, including familiarity with fact tables, dimensions, and slowly changing dimensions.
-
Proficiency in Python, PySpark, and SparkSQL, with experience working in Fabric Notebooks.
-
Hands-on experience developing end-to-end solutions in a Medallion architecture, including data ingestion, transformation, and modeling.
-
Working experience with machine learning and AI concepts, with exposure to implementation in Fabric or similar platforms.
-
Experience using Git for source control in a collaborative development environment.
-
Understanding of data governance and security practices as applied to analytics and data platforms.
-
Ability to engage effectively with customers, understand business questions, and deliver practical, high-quality solutions.
Preferred but not required:
-
Experience supporting analytics platforms in a governed enterprise environment.
-
Familiarity with Power BI semantic models and analytics consumption patterns.
-
Exposure to ML lifecycle considerations or MLOps practices.
-
Experience working on cross-functional data or analytics teams.
-
Hands-on experience in Microsoft Fabric.