6 of 6 Dimensional Modelling Jobs in Central London

OVERVIEW: We are seeking an experienced Data Architect/Data Modeler with strong insurance industry standards knowledge and a solid foundation in modern data modelling practices. The ideal candidate will have hands-on experience with modelling tools, data frameworks, and insurance industry data exchange standards. This role involves … Excel bordereaux templates to support real-time API ingestion from MGA/TPA partner systems and monthly bordereaux submissions Develop data models using Dimensional (Star/Snowflake), Data Vault, and 3NF methodologies. Create and manage metadata and modelling artefacts using Erwin with traceability and governance. Support Medallion Architecture ...

optimisation * Relational databases: PostgreSQL at production scale - query optimisation, indexing strategies, table partitioning, replication, schema design for both OLTP and analytical workloads * MongoDB - document modelling, aggregation pipelines, indexing strategy, replica sets; clear judgment on when document vs relational storage is the right architectural call * Containerisation: Docker and Kubernetes-based … deployment of data workloads; reproducible, environment-agnostic data infrastructure * Data modelling for analytical workloads - dimensional modelling, data vault, or equivalent; schema evolution, slowly changing dimensions, and downstream impact analysis * Stream and batch processing patterns; late data handling, watermarking, and backfill strategies; throughput vs latency trade-offs ...

physical data architecture, cross‐domain integration approaches, data domains/bounded contexts, and the mechanisms for consistent and reusable data. Define and iterate data modelling standards and guardrails (e.g. 3NF, dimensional modelling, Data Vault) including clear decision criteria for when each approach is appropriate and ensure adoption … across internal and partner teams. Own and assure integrated data modelling where required, including canonical entities, conformed dimensions, reference data, master data alignment, and shared business definitions that prevent metric drift and reduce duplication. Drive semantic and metrics architecture, ensuring consistent KPI definitions, metric calculation logic and semantic models ...

well as contribute to architectural direction and best practices. Key Responsibilities Design and maintain scalable data architectures across Snowflake and Databricks Lead schema design, dimensional modelling, and SQL performance optimisation Build robust ETL/ELT pipelines Develop resilient API ingestion workflows Implement data quality frameworks and enforce data … Skills and Experience Management of technical teams and near shore partners 5+ years hands-on Data Engineering experience Expert-level SQL and advanced data modelling Strong Python Experience with Snowflake and Databricks Cloud experience Experience with orchestration tools (Airflow, Prefect) CI/CD and DataOps experience for data platforms ...

four domains (Customers, Applications, Assessments, Cases), aligning with the DSFS data model and existing Netezza structures. Produce the EDW logical and physical data models, dimensional models for the Semantic Layer, and Data Lake zone architecture (Bronze/Silver/Gold). Define Enterprise Semantic Layer design, including pre-computed … aggregations, dimensional models, and Tableau connectivity specifications. Lead source system profiling (D02), producing profile reports for each system in the seven-system scope. Ensure data model designs meet NFRs: 200 concurrent users, 1-hour maximum response time, and 99.5% availability. Provide architectural guidance to the Data Architect and Lakehouse ...

model redesign, and production cutover. Expert-Level PySpark & Python Skills. Strong ability to design, optimize, and refactor distributed data processing workflows. Advanced SQL & Data Modelling Expertise. Experience in dimensional modeling, lakehouse architecture patterns, and query optimization. Cloud Platform Experience (Azure preferred). Hands-on experience deploying and managing ...