Senior Microsoft Fabric Data Analyst / Analytics Engineer
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+11 more
Job description
- Analyse the existing Microsoft Fabric analytics and reporting implementation and rapidly understand its architecture, data models and reporting logic.
- Assess existing components to determine what can be retained, refactored or rebuilt.
- Design and implement robust dimensional data models, including fact tables, dimensions, hierarchies and relationships.
- Develop and optimise semantic models supporting enterprise reporting requirements.
- Translate business requirements and Finance KPIs into scalable analytical models and reporting datasets.
- Implement and validate KPIs, business rules and analytical measures.
- Perform data analysis, reconciliation and root-cause investigation across source, transformation, semantic and reporting layers.
- Remediate technical debt and data-modelling weaknesses in the existing implementation.
- Support delivery of high-priority reporting capabilities through testing and UAT.
- Work closely with the Fabric/Data Architect, business stakeholders and Finance SMEs.
- Make day-to-day technical decisions independently and escalate only significant architectural or business issues.
- Contribute to engineering quality through documentation, testing, performance optimisation and development standards.
Requirements
We are looking for a Senior Microsoft Fabric Data Analyst / Analytics Engineer to join a high-priority analytics and reporting initiative.
The successful candidate will be responsible for analysing, improving and delivering enterprise reporting solutions built on Microsoft Fabric.
The role requires strong hands-on expertise across dimensional modelling, semantic models, KPI implementation and reporting datasets, combined with the ability to understand and remediate an existing solution rapidly.
This is a senior, hands-on role requiring the ability to work autonomously, make sound technical decisions and collaborate directly with business and technical stakeholders.
Experience with complex Finance or enterprise reporting environments is a strong plus., * Strong hands-on experience with Microsoft Fabric
- Strong experience in analytics engineering and BI
- Advanced SQL
- Advanced Power BI and DAX
- Strong understanding of dimensional modelling / star schema
- Fact and dimension design
- Semantic model design and optimisation
- KPI and analytical measure implementation
- Knowledge of Semantic Models as Code, including TMDL and Power BI Project (PBIP) files, following source control and CI/CD best practices.
- Reporting dataset design
- Data transformation and reconciliation
- Experience analysing and improving existing/legacy analytical solutions
- Strong understanding of end-to-end data flows from data source through transformation and semantic layer to reporting
- Knowledge of Azure DevOps Pipelines and deployment processes across multiple environments, including integration with Microsoft Fabric Git-enabled workspaces.
- PySpark and Spark SQL in Fabric notebooks, working with lakehouses, Delta tables, shortcuts and materialized lake views.
- Proficiency in using Jira for agile delivery.
Mandate Experience
- 5+ years of experience in Data Analytics, BI or Analytics Engineering
- Proven delivery experience with Microsoft Fabric and Power BI
- Experience with complex enterprise reporting environments
- Experience working on Finance / Group Reporting solutions strongly preferred
- Experience working with Lakehouse/Warehouse-based analytical architectures
- Exposure to Fabric notebooks, Dataflows Gen2 and orchestration/pipelines
- Experience with performance optimisation of analytical and semantic models
- Experience with Azure DevOps Repos including Git branching, feature branches, pull requests and code review.
- Experience designing and implementing Fabric Data Pipelines, orchestration workflows and configuration driven development frameworks.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this role…