1 to 25 of 52 Dimensional Modelling Jobs in the UK excluding London

GraphQL APIs using Azure Data Factory and metadata-driven patterns. Apply data quality and validation rules using Lakeflow Declarative Pipelines expectations. Curated Layers & Data Modelling Develop clean and conforming Silver & Gold layers aligned to enterprise subject areas. Contribute to dimensional modelling (star schemas), harmonisation logic, SCDs … . Strong PySpark and Spark SQL skills within distributed compute environments. Experience working in a Lakehouse/Medallion architecture with Delta Lake. Understanding of dimensional modelling (Kimball), including SCD Type 1/2. Exposure to operational concepts such as monitoring, retries, idempotency and backfills. Mindset Good energy ...

creating at least 5 new assets during the contract Who We're Looking For Strong experience in SQL, DBT, and Snowflake Familiarity with dimensional modelling (Kimball methodology preferred) Understanding of building models for large stakeholder groups Experience with performance optimisation, data quality, and query/resource efficiency Comfortable … with a supportive and experienced Analytics Engineering team Interview Process Case study (essential - candidates complete a provided template) Technical/market conversation focusing on: Dimensional modelling experience Snowflake model design for multiple stakeholders Performance optimisation and data quality Refactoring and migrations Availability: Interviews scheduled across Thursday 26th ...

Data Warehouse Engineer, or similar. Strong hands-on knowledge of Microsoft Fabric and related services. End-to-end DWH development knowledge, from ingestion to modelling and consumption. Strong background in data modelling, including star schema, dimensional modelling and semantic modelling. Ability to orchestrate, monitoring and optimise ...

would be a bonus! Key outputs for the role• Design, build, and maintain scalable and trustworthy data models in dbt, making use of Kimball Dimensional and One Big Table (OBT) methodologies.• Translate business requirements from stakeholders into robust, well-documented and tested dbt models.• Develop and own workflows within … performant dbt models that serve as a single source of truth for business reporting.• Implement and champion data quality testing, documentation standards, and modelling best practices within dbt projects.• Troubleshoot and resolve any issues or errors in the data pipelines.• Stay updated with the latest cloud technologies and industry ...

quality technical documentation About You You will have extensive experience designing and delivering modern data platforms, with: Strong expertise in data warehouses, data lakes, dimensional modelling, and both batch and streaming data processing A solid understanding of data strategy and management, including data governance, data quality, security ...

quality technical documentation About You You will have extensive experience designing and delivering modern data platforms, with: Strong expertise in data warehouses, data lakes, dimensional modelling, and both batch and streaming data processing A solid understanding of data strategy and management, including data governance, data quality, security ...

Role – Data Modelling Lead Technology – Snowflake, SQL Server, PostgreSQL, Data Warehousing, Data Lake, Medallion, Data Vault, Data Fabric, Semantic modelling Location – London, UK Job Description We are seeking an experienced Data Modeler who can analyze and understand the existing customer data and analytics models on SQL Server … concepts—including Specialized Insurance, London Market, and Regulatory Data—is essential for success in this role. Your role In the role of a Data Modelling Lead, you will be responsible for leading the design and transformation of enterprise data models to support scalable, high-performance analytics and reporting solutions. ...

practices. Key Responsibilities Design, develop, and maintain scalable data pipelines and ELT processes using Snowflake Build and optimize data models (star schema, snowflake schema, dimensional modeling) Implement data ingestion frameworks from structured and unstructured data sources Optimize performance through clustering, partitioning, and query tuning Develop and maintain data quality ...

images, text) and transformation into structured/vectorized formats Strong SQL skills for analytical queries, performance tuning, and data modeling (star/snowflake schemas, dimensional modeling, partitioning, clustering). Unstructured data & AI/RAG: Understanding of vector databases (e.g., Elasticsearch, Milvus, pgvector), embedding models, and RAG architectures. Familiarity with ...

images, text) and transformation into structured/vectorized formats Strong SQL skills for analytical queries, performance tuning, and data modeling (star/snowflake schemas, dimensional modeling, partitioning, clustering). Unstructured data & AI/RAG: Understanding of vector databases (e.g., Elasticsearch, Milvus, pgvector), embedding models, and RAG architectures. Familiarity with ...

Google Cloud Platform (GCP) Experience with orchestration tools (e.g., Apache Airflow) Experience with version control (e.g., Git) Solid understanding of data warehousing concepts and dimensional modeling To apply for this role please submit your CV or contact Dillon Blackburn on or at . Tenth Revolution Group ...

data infrastructure, and ensure the team delivers high[1]quality, impactful solutions. You'll work across the full data lifecycle from ingestion and modelling to orchestration, monitoring, and analytics enablement, while also mentoring engineers and shaping engineering best practices. As a lead, you'll partner with our leadership team … start-up environment. Strong expertise in Python and SQL, with deep experience in orchestration frameworks (Dagster, Airflow, Prefect). Advanced knowledge of data modelling and architecture (Kimball dimensional modelling, Data Vault etc). Hands-on experience with dbt, modern data warehouses, and AWS. Demonstrated ability to mentor ...

data infrastructure, and ensure the team delivers high[1]quality, impactful solutions. You'll work across the full data lifecycle from ingestion and modelling to orchestration, monitoring, and analytics enablement, while also mentoring engineers and shaping engineering best practices. As a lead, you'll partner with our leadership team … start-up environment. Strong expertise in Python and SQL, with deep experience in orchestration frameworks (Dagster, Airflow, Prefect). Advanced knowledge of data modelling and architecture (Kimball dimensional modelling, Data Vault etc). Hands-on experience with dbt, modern data warehouses, and AWS. Demonstrated ability to mentor ...

data infrastructure, and ensure the team delivers high[1]quality, impactful solutions. You'll work across the full data lifecycle from ingestion and modelling to orchestration, monitoring, and analytics enablement, while also mentoring engineers and shaping engineering best practices. As a lead, you'll partner with our leadership team … start-up environment. Strong expertise in Python and SQL, with deep experience in orchestration frameworks (Dagster, Airflow, Prefect). Advanced knowledge of data modelling and architecture (Kimball dimensional modelling, Data Vault etc). Hands-on experience with dbt, modern data warehouses, and AWS. Demonstrated ability to mentor ...

data infrastructure, and ensure the team delivers high[1]quality, impactful solutions. You'll work across the full data lifecycle from ingestion and modelling to orchestration, monitoring, and analytics enablement, while also mentoring engineers and shaping engineering best practices. As a lead, you'll partner with our leadership team … start-up environment. Strong expertise in Python and SQL, with deep experience in orchestration frameworks (Dagster, Airflow, Prefect). Advanced knowledge of data modelling and architecture (Kimball dimensional modelling, Data Vault etc). Hands-on experience with dbt, modern data warehouses, and AWS. Demonstrated ability to mentor ...

data infrastructure, and ensure the team delivers high[1]quality, impactful solutions. You'll work across the full data lifecycle from ingestion and modelling to orchestration, monitoring, and analytics enablement, while also mentoring engineers and shaping engineering best practices. As a lead, you'll partner with our leadership team … start-up environment. Strong expertise in Python and SQL, with deep experience in orchestration frameworks (Dagster, Airflow, Prefect). Advanced knowledge of data modelling and architecture (Kimball dimensional modelling, Data Vault etc). Hands-on experience with dbt, modern data warehouses, and AWS. Demonstrated ability to mentor ...

data infrastructure, and ensure the team delivers high[1]quality, impactful solutions. You'll work across the full data lifecycle from ingestion and modelling to orchestration, monitoring, and analytics enablement, while also mentoring engineers and shaping engineering best practices. As a lead, you'll partner with our leadership team … start-up environment. Strong expertise in Python and SQL, with deep experience in orchestration frameworks (Dagster, Airflow, Prefect). Advanced knowledge of data modelling and architecture (Kimball dimensional modelling, Data Vault etc). Hands-on experience with dbt, modern data warehouses, and AWS. Demonstrated ability to mentor ...

data infrastructure, and ensure the team delivers high[1]quality, impactful solutions. You'll work across the full data lifecycle from ingestion and modelling to orchestration, monitoring, and analytics enablement, while also mentoring engineers and shaping engineering best practices. As a lead, you'll partner with our leadership team … start-up environment. Strong expertise in Python and SQL, with deep experience in orchestration frameworks (Dagster, Airflow, Prefect). Advanced knowledge of data modelling and architecture (Kimball dimensional modelling, Data Vault etc). Hands-on experience with dbt, modern data warehouses, and AWS. Demonstrated ability to mentor ...

procedures, performance tuning Strong troubleshooting skills for complex multi-system data issues. Strong understanding of data architecture concepts: Data lakes/lakehouse/warehouse, dimensional modeling, ELT/ETL patterns Batch orchestration, dependency management, SCD handling, incremental loads Azure Ecosystem (Preferred/Good to Have) Azure data services experience ...

logical data models across key investment banking domains (e.g. clients, products, trades, positions, risk, finance, market and collateral data) Ensure models align to agreed modelling standards, naming conventions, and reusable design patterns Translate business requirements into clear, structured data models aligned to authoritative upstream sources Facilitate workshops with SMEs … data teams to validate definitions and resolve data discrepancies Embed modelling standards, metadata, and quality controls in line with enterprise data governance frameworks Operate within a high-throughput, iterative delivery (factory) model, supporting multiple concurrent data products Collaborate closely with architects, governance, engineering, onsite leadership, and offshore teams ...

queries, joins, aggregations, and optimization. Python proficiency for data manipulation and automation. Power BI or Tableau experience including dashboard development. Data modeling experience including dimensional modeling and star schema. ETL and data transformation experience. Stakeholder management skills. Problem-solving mindset with ability to work independently. Strong attention to detail ...

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

using Snowflake Optimise workflows and integrations using Openflow Develop and maintain ETL and ELT pipelines from Salesforce, relational databases, files, and NoSQL sources Implement dimensional modelling to support data warehousing and BI reporting Build and optimise data pipelines across Azure and AWS Ensure data quality, governance, and security ...

dashboards (DAX, Power Query, RLS, performance). Advanced Excel: advanced formulas, Pivot tables, Power Pivot. ETL/ELT tooling (SSIS/Power Query) and dimensional modelling (Star Schema). Practical AI/ML exposure (e.g., Python notebooks, Azure ML, or equivalent) and the ability to operationalise models responsibly ...

into meaningful insights and recommendations What you'll bring Experience of building a data warehouse using an ETL/ELT tool Star schema/dimensional modelling. Good knowledge of standard data formats (XML, JSON, csv, etc) Proven experience of delivering BI solutions for business requirements Experience of developing using ...