5 of 5 Dimensional Modelling Jobs in Central London

DATA MODELLER LONDON/HYBRID UP TO £65,000 This is an opportunity to shape data modelling and architecture capability within a modern cloud data environment. The role offers strong visibility across multiple projects, with a clear pathway into data architecture and the chance to influence standards and best … across the organisation. ROLES AND RESPONSIBILITIES: The Data Modeller will: Design and develop conceptual, logical and physical data models for enterprise data platforms Apply dimensional modelling approaches such as Kimball or Data Vault to support analytics use cases Collaborate with data engineers, analysts and governance teams to ensure ...

behind every report and every operational data feed at ECP, continue the migration of our data warehouse and data lake to a modern dimensional model, finish the rollout of a principle-of-least-privilege security model across a multi-server SQL estate, and continue the migration of our reporting … will include: Setting and personally delivering target architecture for the ECP data estate the data warehouse, data hub, data lake, raw/ODS layers, dimensional model, audit and schema-change tracking, and the load schedules that tie them together. Hands-on T-SQL, stored procedure, ETL framework and PowerShell ...

Agentic AI. Strong experience Must have prior experience with end-to-end implementation of Cloud data technologies (i.e.Fabric, Snowflake). Expertise in data modelling, ELT and implementing complex stored Procedures. Expertise in various Snowflake technologies like Snowpark, SnowPipe, SnowPipe Stream, Dynamic Tables, Document AI, Cortex Analytics, Unistore etc. Expertise … systems, Salesforce, GIS, PI Historian to Snowflake. Deep understanding of relational as well as NoSQL data stores, methods, and approaches (star and snowflake, dimensional modelling and third normal form) Experience with data security and data access controls and design Deep understanding of SoX, GDPR and Regulatory/ ...

impact Analytics Engineer role within a purpose-driven organisation at a pivotal stage of its data journey. You will take ownership of critical data modelling work within a modern cloud environment, helping to stabilise and scale key data pipelines while contributing to meaningful, real-world outcomes. ROLES AND RESPONSIBILITIES … Analytics Engineer will: Own and deliver in-flight data modelling projects, ensuring continuity and completion Design and maintain dbt models including fact tables, dimensions, and metric layers Support and optimisie critical data pipelines, particularly around billing and reporting workflows Collaborate closely with data engineers to manage data flows across ...

data solutions \nStrong proficiency in Databricks, SQL, and Python/PySpark, including building, optimizing, and troubleshooting ETL pipelinesExperience designing scalable, maintainable data architectures and dimensional models for BI, reporting, and analytical use casesProven ability to partner with business stakeholders to gather requirements, shape solutions, and communicate effectivelyStrong understanding … ecosystemManage ETL orchestration, dependencies, and deployments to ensure reliability and operational stabilityMonitor production performance and resolve root causes to prevent recurring data delivery issuesApply dimensional modeling and support Unified Star Schema development to ensure semantic consistencyMentor and coach junior engineers while promoting strong technical standards and collaborative ways ...