1 to 25 of 71 Dimensional Modelling Jobs in the UK

holder will play a leading role in the design, development, and optimisation of high-quality Power BI data models. A strong understanding of data modelling, particularly dimensional modelling principles, is essential, as these models will underpin analytical reporting and the ongoing development of the Trust's data … matching. Main duties of the job Lead the design, development, and optimisation of high-quality Power BI data models, underpinned by robust dimensional modelling principles to support accurate and consistent reporting. Support the development, maintenance, and optimisation of the Trust's data warehouse and associated data platforms, ensuring ...

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

Engineer, you will be responsible for transforming raw data into well modelled, business ready data marts and semantic layers. You will take ownership of dimensional modelling, dbt transformations, and core metrics that power BI tools used across the business. This role blends hands on technical delivery with technical … managing 2 to 3 Analytics Engineers while working closely with senior data leaders and stakeholders on multi market initiatives. Key Responsibilities • Design and own dimensional data models using Kimball methodology • Build and maintain dbt pipelines from raw to gold layer marts • Define and enforce modelling, testing, and documentation ...

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

Data Modeller will play a key role in enabling data-driven decision-making while ensuring alignment with industry regulations and standards. Key Responsibilities Data Modelling & Architecture Design, develop, and maintain conceptual, logical, and physical data models supporting insurance systems and analytics platforms. Ensure alignment with Lloyd's market standards … business analysts, actuaries, and IT teams to integrate data from multiple insurance sources including: Policy administration systems Claims platforms Bordereaux submissions Exposure and catastrophe modelling datasets Design and optimise data pipelines and transformation logic to support reporting, analytics, and regulatory submissions. Support the development of scalable data warehousing ...

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

regulatory reporting processes. This role requires a strong understanding of insurance data structures, market-specific standards, and advanced data architecture principles. Key Responsibilities Data Modelling & Architecture Design and maintain conceptual, logical, and physical data models for insurance systems. Ensure alignment with Lloyd's market standards, including Core Data Record … rules. Ensure compliance with Lloyd's market regulations, GDPR, and Solvency II requirements. Required Skills & Experience Technical Expertise 10+ years of experience in data modelling within the Lloyd's of London or London Market insurance sector. Proficiency in ER modelling, relational and dimensional modelling, and data ...

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

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

strategies. Experience integrating data via APIs and services. Clear communication skills and experience working in Agile delivery teams. Nice to Have: Data warehousing and dimensional modelling (e.g. dbt). Basic Power BI knowledge. Relevant Microsoft or Azure certifications. Reasonable Adjustments: Respect and equality are core values to us. ...

/Kinesis Experience building data solutions on at least one major cloud platform (AWS, Azure, or GCP). Strong understanding of data warehousing concepts , dimensional modelling, and schema design. Experience working with CI/CD pipelines and Git-based workflows. Familiarity with Infrastructure-as-Code (Terraform, CloudFormation … testing, and observability practices. Desirable Skills Experience supporting Machine Learning pipelines or feature engineering. Knowledge of containerisation (Docker, Kubernetes). Experience with dbt for modelling and transformation. Background in financial services, payments, trading, or other data-rich environments. Experience with real-time analytics and low‐latency data architectures. Personal ...

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

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

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

you. What You'll Be Doing Architecting the Truth: Design and implement scalable business-layer models, marts, and OBTs. You'll decide whether a dimensional model or a flat OBT is the right tool for the specific business problem. Owning the Lifecycle: You take business requirements and turn them … hood' mechanics of cloud data warehouses (specifically GCP BigQuery ). dbt Specialist: Strong hands-on experience with dbt Cloud or Core is essential. Modelling Pro: You understand dimensional modelling and how to structure data for varied business use cases. CI/CD Native: You're comfortable with ...

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

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

ideal candidate will have the following: Strong SQL; Snowflake ELT; dbt experience. Python/PySpark, ETL/ELT design. Data Vault 2.0 or dimensional modeling. AWS services (S3, Glue, Lambda, Redshift) or GCP equivalents. Experience with CI/CD for data pipelines. Good to have skills Although not essential ...