Data Modeler (Investment Banking)

Consol Partners UK ·www.consolpartners.co.uk

Location London, London, England
Work type Hybrid
Salary GBP 500 - 600 / month
Type Full time
Level Mid
Source Shazamme
Software Development
Apply direct

Data Modeller (Data Vault 2.0) | Investment Banking | PAYE

Location: London(Hybrid – 2 days onsite per week)

Duration: 6 Months (Initial)

Status: Inside IR35

Sector: Investment Banking / Data Modernisation


Engagement Overview

Following a series of strategic consultations with the Chief Data Office (CDO) regarding their data modernisation roadmap, we have been engaged to secure a Senior Data Modeller for a high-impact transformation programme.

The project focuses on the migration of legacy infrastructure to a modern cloud data platform, specifically addressing the design and delivery of scalable data models for post-bind insurance data. This role is critical in ensuring regulatory alignment, financial reconciliation, and operational reporting accuracy across multiple specialty lines.

Core Responsibilities

  • Architectural Design: Lead the creation of conceptual, logical, and physical data models tailored for Snowflake ingestion.

  • Methodology Leadership: Apply Data Vault 2.0 principles to ensure robust auditability, lineage tracking, and enterprise scalability.

  • Cross-Functional Collaboration: Partner with Data Architects, Business Analysts, and Actuarial teams to translate complex business requirements into structured data assets.

  • Domain Integration: Model data to support premium and claims reconciliation, aged debt tracking, and reserve movements.

  • Governance: Document metadata and data dictionaries to maintain strict compliance with banking regulatory standards.

Technical Requirements & Experience

  • Financial Services Expertise: Extensive experience as a Data Modeller within Investment Banking or the broader Financial Services market.

  • Technical Proficiency: Demonstrable expertise in Data Vault 2.0 and dimensional modelling techniques.

  • Platform Knowledge: Hands-on experience with Snowflake and cloud-native data architectures.

  • Specialty Lines: Ability to model across diverse sectors such as marine, aviation, and cyber insurance.

  • Stakeholder Management: Proven ability to engage with senior stakeholders across Finance, Operations, and the CDO.

Project Impact

The successful consultant will contribute to a broader data transformation initiative, ensuring the seamless integration of models into downstream analytics pipelines and driving measurable improvements in operational efficiency and regulatory reporting.


Application Process

If you possess the required expertise in Data Vault 2.0 and Snowflake within a banking context, please applycontact Christian directly for a confidential discussion regarding the programme roadmap.

#DataModelling #DataVault2 #Snowflake #InvestmentBanking #ContractRecruitment #GlasgowBusiness #DataModernisation


Frequently asked questions

Who is hiring for the Data Modeler (Investment Banking) role?
Consol Partners UK is hiring for the Data Modeler (Investment Banking) position, a Shazamme client. Apply directly on the employer's career site.
Where is the Data Modeler (Investment Banking) job located?
The Data Modeler (Investment Banking) role with Consol Partners UK is based in London, GB. The role is hybrid-friendly.
Is the Data Modeler (Investment Banking) role remote?
Yes — the Data Modeler (Investment Banking) position at Consol Partners UK is hybrid. Candidates based in GB are preferred.
What does the Data Modeler (Investment Banking) role pay?
Consol Partners UK lists the Data Modeler (Investment Banking) role at GBP 500–600 per month.
Is the Data Modeler (Investment Banking) role full-time or contract?
This is a full time position at Consol Partners UK.
What experience level is the Data Modeler (Investment Banking) role?
The Data Modeler (Investment Banking) position is aimed at mid-level candidates.
How do I apply for the Data Modeler (Investment Banking) role at Consol Partners UK?
Apply directly on Consol Partners UK's career page via the Apply button on this listing. ZammeJobs links straight through to the employer's ATS — no third-party form, no resume database.
Apply direct