Job Description
.
Senior Data Modeller - Banking (Contract)
Location: Glasgow (Hybrid - 2 days onsite per week)Start Date: ImmediateDuration: Initial 6 months (extension likely)Sector: Investment Banking
Engagement Context
Our client, a leading consultancy delivering strategic data transformation across the banking sector, is seeking a Senior Data Modeller to support a high-impact programme focused on post-bind insurance data. The successful candidate will play a critical role in designing scalable, compliant data models that underpin operational reporting, financial reconciliation, and regulatory alignment across multiple specialty lines.
Key Responsibilities
Lead the design and delivery of conceptual, logical, and physical data models across post-bind domainsCollaborate with data architects, business analysts, and actuarial teams to translate complex business requirements into structured data assetsApply Data Vault 2.0 methodology to support auditability, scalability, and lineage trackingModel data for ingestion into Snowflake, ensuring compatibility with cloud-native architecture and downstream analyticsEnsure models support reconciliation of premium and claims, aged debt tracking, reserve movements, and regulatory reportingDocument metadata, data dictionaries, and lineage to support governance and complianceEngage with stakeholders across finance, operations, and claims to validate model assumptions and ensure business alignmentRequired Experience & Skills
Extensive experience as a Data Modeller within the FS Market, with demonstrable expertise in dataProficiency in Data Vault 2.0 and dimensional modelling techniquesHands-on experience with Snowflake and cloud-based data platformsAbility to model across multiple specialty lines (e.g., marine, aviation, cyber)Strong stakeholder engagement and documentation skills
Clear documentation and stakeholder alignment across finance, operations, and actuarial domainsSeamless integration of models into Snowflake and downstream analytics pipelinesContribution to a broader data transformation programme with measurable impact on operational efficiency and regulatory compliance