Data Architect

About the role

Our client, a leading investment‑focused organisation, is driving a major data transformation programme. They are looking for a hands‑on Data Architect to shape a modern enterprise data platform that supports analytics, reporting and operational processes across the business.

Key responsibilities

• Define and govern enterprise‑wide data architecture standards, principles and best practices.
• Design and maintain scalable data models for analytics, reporting and investment initiatives.
• Provide architecture and database design guidance across a Microsoft‑centric data estate.
• Collaborate with Data Engineers to deliver high‑quality, scalable data solutions.
• Lead data modelling activities for strategic data platform and consolidation programmes.
• Design solutions using Microsoft Fabric and/or Databricks within a cloud‑based architecture.
• Define best‑practice approaches for Lakehouse and Data Warehouse storage.
• Establish robust data integration patterns with Azure Data Factory.
• Support data standardisation and consolidation across multiple business domains.
• Partner with stakeholders to translate requirements into sustainable data solutions.
• Contribute to the broader data, cloud and AI strategy.

Required profile

• Proven experience as a Data Architect in a complex enterprise environment.
• Background in Data Engineering, Data Modelling or Database Development with a hands‑on approach.
• Strong expertise in the Microsoft data ecosystem.
• Experience designing enterprise‑scale data platforms and architecture frameworks.
• Deep understanding of data modelling, dimensional modelling and logical/physical design.
• Knowledge of data warehousing, Lakehouse architectures and modern data platform design.
• Experience delivering ETL/ELT solutions and integration architectures.
• Understanding of data governance and data quality principles.

Required skills

• SQL Server
• Microsoft Fabric
• Azure Data Factory
• Databricks
• Lakehouse architecture
• Data Warehouse architecture
• ETL / ELT processes
• Data modelling (dimensional, logical, physical)
• Data governance
• Data quality management