Data Architect

Trust In SODA
London
Data Architect

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.

Key Responsibilities
  • 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.
Essential Skills & Experience
  • 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
Posted 2026-09-18

Recommended Jobs

Pre-Academy Manager

Crystal Palace F.C.
Beckenham, Greater London

Job Location:      Academy Training Ground, BR3 1NZ Contract Type:    Full-time Deadline:            1st October 2026 Who we are: We are Crystal Palace Football Club, a Premier League Foo…

View Details
Posted 2026-09-18

Senior Sous Chef - Coreus by Clare Smyth - London

Hilton
London

Senior Sous Chef - Coreus by Clare Smyth - LondonWaldorf Astoria London - Admiralty Arch is seeking a Senior Sous Chef - Coreus by Clare Smyth to join the pre-opening team for this highly anticipated…

View Details
Posted 2026-09-18

Barista - Pret a Manger

Carebrook Ireland
London

Pret A Manger - Barista A Pret Barista works as part of a team in a Pret shop to ensure all Barista prepared drinks are served to the required Pret standard. The Barista role ensures excellen…

View Details
Posted 2025-09-30

Cost Assurance Consultant

AtkinsRéalis
London

Job Description Overview Become a vital member of our Complex Projects, Delivery Partner team, proudly taking on some of the world's most exciting and prestigious projects. Join us, and you'll …

View Details
Posted 2026-09-18

Children’s Social Work Advanced Practitioner, Looked After Children / Leaving Care, North London

Edgware, Greater London

Children’s Social Work Advanced Practitioner, Looked After Children / Leaving Care, North London  Pay rate £40.50 per hour   Contract role, LAC / Looked After Children / Child In Care / Corporate…

View Details
Posted 2026-09-18

Building and Project Consultancy Placement 2027

London

About this role As a sandwich placement student, you will receive the same exposure as a graduate. You will gain experience across all disciplines of Building & Project Consultancy including techn…

View Details
Posted 2026-09-18

Graduate Primary Teaching Assistant

KPI Recruiting Ltd
Westminster, Greater London

Graduate Primary Teaching Assistant Westminster, Central London September 2026 Start | Full-Time | Term-Time Only £500–£600 per week Ready to begin your career in education? Are you a mo…

View Details
Posted 2026-09-18

2027 Global Capital Markets Off-Cycle Internship (London)

Morgan Stanley
London

In the Global Capital Markets division, we offer Global expertise in market analysis and in advisory and capital-raising services for corporations, institutions, and governments. Since 1935, Morga…

View Details
Posted 2026-09-19

Capital Actuary

Eames Consulting
City of London, Greater London

Capital Actuary for a global speciality insurer. I am looking to speak with nearly/qualified actuaries for a Capital Modelling Actuary. The ideal candidates will have up to 5 years experience in a…

View Details
Posted 2026-09-18