Microsoft Fabric Data Engineer

Job Purpose

The Microsoft Fabric Data Engineer role exists to design, build, and optimize data solutions using Microsoft Fabric, Power BI, and Azure Data Services from transactional systems hosted in Azure, AWS and private cloud data centre locations. The ideal candidate will have a strong background in data engineering, ETL, data modelling, and Power BI development, with experience in Microsoft Fabric and associated technologies such as OneLake, Lakehouses, and Data Warehouses.

Key Responsibilities

• Design & Implement Data Solutions: Develop and manage data pipelines using Microsoft Fabric, drawing data from SQL Server, Oracle, MongoDB and other database platforms used by Tungsten Automation for public cloud delivered services to customers.
• ETL & Data Processing: Build scalable ETL processes to take customer data from hosting databases through refinement states to the point where required business information can be used by colleagues for report, dashboard and other visualisations and analysis.
• Power BI Development: Create Power BI datasets, reports, and dashboards that provide actionable insights and are of sufficient quality for executive level publication.
• Data Modeling & Optimization: Design efficient data models for Power BI reports and ensure high-performance analytics.
• Data Governance & Security: Implement role-based access control (RBAC), sensitivity labels, and data encryption in Fabric & Power BI to ensure information held in the Fabric infrastructure is secure and controls consistent with the Tungsten Automation Information Security compliance requirements.
• Performance Tuning: Optimize queries, DAX calculations, and Power BI reports for speed and efficiency, co-working with colleagues in Development, Cloud Services and other teams responsible for data schemas and ongoing service to customers.
• Collaboration & Stakeholder Engagement: Work closely with business analysts, data scientists, and other stakeholders to ensure data solutions align with business goals and the desired information presented.

Qualifications & Skills

• Proven Power BI & Microsoft Fabric Expertise – able to demonstrate strong knowledge of Power BI, OneLake, Dataflows Gen2, Lakehouses, and Data Warehouses in Fabric.
• Practical experience of ETL & Data Engineering – hands-on experience with Azure Data Factory, Synapse Pipelines, or SQL-based ETL solutions.
• Practical experience of using Python or similar approaches to extact data from various data sources and services to populate data models
• Data Modeling – experience with star schema, dimensional modeling, and tabular models.
• SQL & DAX Proficiency – evidence of strong skills in T-SQL, DAX, and Power Query (M Language).
• Azure Data Services – experience with Azure Synapse, Azure SQL, Data Lakes, and Azure Databricks.
• Performance Tuning – experience in optimization of Power BI datasets, queries, and Fabric workloads for efficiency and to reach acceptable performance levels.
• Security & Governance – strong understanding of data security, compliance, and governance best practices in Microsoft Fabric and what steps need to be taken to ensure these.