Microsoft Fabric Data Architect

Posted 1 hour 23 minutes ago by Dns Info Ltd

£35 Annual
Contract
Not Specified
Factory Jobs
West Midlands, United Kingdom
Job Description

Job Title: Microsoft Fabric Data Architect
Experience: 10-15+ Years (overall), with 3-5+ years in Data Architecture/Microsoft Azure Data Platform

Job Summary

We are looking for an experienced Microsoft Fabric Data Architect to design, architect and implement modern enterprise data platforms using Microsoft Fabric. The ideal candidate should have strong expertise in Microsoft Fabric, Azure Data Services, data warehousing, Lakehouse architecture, data modelling, ETL/ELT pipelines and enterprise data governance.

The candidate will be responsible for defining data architecture strategies, designing scalable data solutions, leading technical implementation and ensuring data quality, security and performance across the organisation.

Key Responsibilities

  1. Design and implement end-to-end data architecture solutions using Microsoft Fabric.

  2. Define enterprise data architecture, including Lakehouse, Data Warehouse and Medallion architecture (Bronze, Silver and Gold).

  3. Architect and develop solutions using Fabric OneLake, Lakehouse, Warehouse and Data Factory.

  4. Design and implement ETL/ELT pipelines for large-scale data integration.

  5. Work with Microsoft Fabric components such as:

    • OneLake

    • Data Factory

    • Lakehouse

    • Data Warehouse

    • Fabric Notebooks

    • Dataflows Gen2

    • Real Time Intelligence

    • Power BI

  6. Integrate data from multiple sources including Azure SQL, SQL Server, APIs, SAP and other enterprise applications.

  7. Define data modelling strategies, including dimensional modelling, star schema and snowflake schema.

  8. Establish data governance, security, lineage and access control standards.

  9. Optimise data pipelines, queries and storage for performance and cost efficiency.

  10. Collaborate with business stakeholders, data engineers, BI developers and cloud teams.

  11. Provide technical leadership, architecture guidance and best practices to development teams.

Required Technical Skills

Skills

Microsoft Fabric

OneLake, Lakehouse, Warehouse

Fabric Data Factory

Pipelines, Dataflows Gen2

Azure

Azure Data Lake, Azure SQL, ADF

SQL

Advanced SQL, query optimisation

Python

PySpark, data processing

Spark

Apache Spark, Spark SQL

Data Architecture

Enterprise data architecture

Data Modelling

Star schema, dimensional modelling

Power BI

Semantic models, DAX

Data Governance

Security, lineage, data quality

Preferred/Good-to-Have Skills

  • Microsoft Fabric certification (DP-600 - Fabric Analytics Engineer Associate).

  • Azure Data Architect experience.

  • Microsoft Purview for enterprise data governance.

  • Azure Databricks and Snowflake exposure.

  • Git, Azure DevOps and CI/CD.

  • Experience with cloud migration and modernisation projects.

  • Strong stakeholder management and solution architecture skills.