10 of 10 Permanent Dimensional Modelling Jobs in 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 ...

Python skills Experience delivering analytics solutions within modern cloud data platforms Experience leading teams across analytics and BI delivery Strong understanding of data modelling, including dimensional modelling Experience delivering enterprise BI and analytics solutions, including dashboards, semantic models and insight storytelling What's on Offer Salary ...

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 ...

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 ...

implementations Required Skills & Experience 8 - 12 years of experience in data modeling within the Financial Services industry Strong expertise in data modeling techniques (e.g., dimensional modeling, 3NF, Data Vault) Proficiency in SQL and experience with relational and non-relational databases Hands-on experience with data modeling tools (e.g., ERwin ...

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 ...

Office) Salary: Up to £90,000 This is an exciting opportunity to join a high-growth consultancy environment where you will shape data modelling standards, influence enterprise-level design, and work directly with senior stakeholders across complex financial services programmes. If you enjoy combining hands-on modelling with … strong footprint across financial services and energy. Their data capability exceeds 300 specialists, and their Data Architecture function is known for delivering high-quality modelling, strategy and metadata solutions across large-scale transformation programmes. They operate in a collaborative, low-ego environment where expertise is valued and career progression ...

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 ...