Data Architect

• Analyse existing data models and architectures to define target-state reporting and analytics data models.
• Design logical, physical, dimensional and analytical data models using industry best practices.
• Develop scalable data structures to support reporting, business intelligence and advanced analytics.
• Translate complex business, regulatory and reporting requirements into effective data models.
• Collaborate with business and technology stakeholders to deliver robust data solutions.
• Establish data modelling standards, governance frameworks and architectural principles.
• Support the design of modern layered and medallion data architectures.
• Ensure data quality, lineage, governance and regulatory reporting requirements are embedded within data solutions.
• Provide architectural leadership, guidance and consultancy to delivery teams and stakeholders.

• Proven commercial experience as a Data Architect, Information Architect or Data Modelling Consultant.
• Strong experience within banking, financial services, wealth management or investment management environments.
• Expert knowledge of dimensional data modelling, including Kimball methodologies.
• Extensive experience designing reporting, analytics and business intelligence data models.
• Strong understanding of modern analytical data architecture, including layered and medallion approaches.
• Experience analysing complex source systems and defining target-state data models.
• Strong SQL skills with the ability to interrogate and analyse complex datasets.
• Excellent stakeholder management, consulting and communication skills.
• Solid understanding of data governance, lineage, data quality and regulatory reporting principles.

Desirable Technical Experience

• Microsoft Azure Fabric
• Azure Data Factory
• Python
• PySpark
• Apache Spark

Desirable Skills

• Data Vault modelling
• Azure DevOps
• Terraform
• Experience working with regulatory reporting and investment data domains

Banking & Investment Management | London | Hybrid (4 Days Office-Based) | £600 per day | Long-term Contract We are seeking an experienced Data Architect / Data Modelling Consultant with a strong background in banking, wealth management or investment management to join a major financial services programme. This is an excellent opportunity to play a key role in shaping the target-state reporting and analytics landscape within a modern cloud-based data platform. This is a data modelling and consulting-focused position, ideal for someone who enjoys working closely with both business and technology stakeholders to design scalable reporting and analytics data models. The role is centred on defining future-state data architecture rather than platform or infrastructure architecture.