Data Architect – Microsoft Fabric Specialist

About the role

We are partnering with a leading financial services organisation that is investing heavily in its data platform. The role is a green‑field opportunity to shape the future of enterprise data capability through a multi‑year Microsoft Fabric transformation.

Key responsibilities

• Design end‑to‑end data architectures across enterprise data platforms, with a strong focus on Microsoft Fabric, data modelling and database design.
• Lead conceptual, logical and physical data modelling and define target‑state architecture for large‑scale transformation programmes.
• Collaborate with Engineering, Enterprise Architecture, Solution Architecture and Data Governance teams to deliver scalable data solutions.
• Play a pivotal role in standardising data estates and enabling self‑service analytics through Power BI.
• Engage senior business stakeholders across the investment function, translating business requirements into robust technical solutions.

Required profile

• Proven experience as a Data Architect with hands‑on data modelling and SQL Server/database design expertise.
• Experience designing modern Microsoft data platforms, ideally Microsoft Fabric or Databricks.
• Strong understanding of ETL, Azure Data Factory, data warehousing and lakehouse architectures.
• Background within financial services, with exposure to investment data highly desirable.
• Excellent stakeholder management skills, able to operate across technical and business teams.

Required skills

• Microsoft Fabric
• SQL Server
• Data modelling
• Database design
• Azure Data Factory
• ETL processes
• Data warehousing
• Lakehouse architectures
• Databricks
• Power BI