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

dashboards Contribute to long-term AI and data innovation initiatives YOUR SKILLS AND EXPERIENCE: 6+ years' experience in data engineering Strong expertise in data modelling (dimensional modelling and semantic layer design) Hands-on experience with Microsoft Fabric and/or Azure data services Proven ...

foundations that analytics, BI, data science and ML all stand on. You'll work across the full data engineering lifecycle—from ingestion and modelling through to transformation, orchestration, quality, observability and platform operation. The role suits someone who pairs strong software engineering discipline with genuine interest in data modelling … production ELT/ETL pipelines that move data reliably at the volume and latency the business needs Model data in the warehouse or lakehouse—dimensional, Data Vault, One Big Table or domain-driven approaches, fit to the use case Build and maintain transformation layers in dbt (or equivalent), with ...

term work supports broader programme and client objectives. About You Professional knowledge and experience Essential Proven experience in data engineering, data integration and data modelling Expertise with cloud platforms (e.g. AWS, Azure, GCP) Expertise with modern cloud data platforms (e.g. Microsoft Fabric, Databricks) Expertise with multiple data analytics tools … e.g. Power BI) Deep understanding of data warehousing concepts, ETL/ELT pipelines and dimensional modelling Proficiency in advanced programming languages (Python/PySpark, SQL) Experience in data pipeline orchestration (e.g. Airflow, Data Factory) Familiarity with DevOps and CI/CD practices (Git, Azure DevOps etc) Ability ...

batch and near-real-time data processing. Experience with data formats such as Parquet, Avro, ORC, JSON, and CSV. Good understanding of data modelling, data warehousing, and dimensional modelling concepts. Experience with data validation, reconciliation, data quality, audit, and logging frameworks. Experience with Git-based version control ...

Lead Data Business Analyst (Data Warehouse & Data Modelling) Our London based client is currently looking for a Lead Data Business Analyst to act as the bridge between business stakeholders and technical data teams to define, document, and validate requirements for their enterprise data warehouse. The Data Business Analyst will … requirements, including source‐to‐target mappings and logical, conceptual, and physical data models. Collaborate with data architects and data engineers to design and enhance dimensional data models, including fact and dimension tables using star and snowflake schemas. Produce and maintain data warehouse documentation, including entity relationship diagrams (ERDs), data ...

models and self-service tools the business actually uses to make decisions. You'll work across the full BI lifecycle—from gathering requirements and modelling data through to building, optimising and maintaining production reporting assets. The role suits someone who pairs strong SQL and modelling discipline with … curated layers that let business users answer their own questions (For Senior/Lead) Set BI standards, mentor junior developers, lead larger reporting and modelling initiatives What You'll Bring Technical Expertise: Strong SQL proficiency against modern cloud warehouses (Snowflake, BigQuery, Redshift, Synapse, Databricks) Deep hands-on experience with ...

+ benefits This is a rare opportunity to join an organisation undertaking a major data and digital transformation, with a clear path from data modelling into data architecture. You will step into a role designed for long-term growth, working closely with senior architects and influencing how data … support key business initiatives Contribute to the design and evolution of data architecture standards and best practices Work across multiple projects, ensuring consistency in modelling approaches and data structures Collaborate with data engineers, analysts, and governance teams to deliver high-quality data solutions Support the transition towards modern, cloud ...

combining business analysis, data analysis and data cataloguing to identify and document data requirements. Proficient use of enterprise data platforms, semantic models and dimensional modelling (star schemas, fact/dimension tables). Proficient in data architecture principles, ETL processes and data pipeline concepts. Experience with data cataloguing tools ...

Data Modeller London Up to £65,000 + benefit This is an opportunity to join a growing data function where modelling expertise is a key priority. You will play a central role in shaping data foundations while being supported on a clear pathway into Data Architecture, with exposure … collaborative and well established, with a clear focus on improving data quality, consistency, and accessibility. You will join a team that values strong modelling standards and best practice. The Role Develop and maintain conceptual, logical, and physical data models across a range of business domains Support and promote data ...

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