1 to 25 of 51 Dimensional Modelling Jobs

ingestion frameworks for integrating multiple source systems into the cloud data platform. Design and govern data transformation frameworks using DBT. Define and enforce data modelling standards including dimensional modelling, star schema, and enterprise data models. Lead architecture reviews and solution design discussions for new data initiatives. Optimize … Platform Strong experience with Amazon Web Services, including: S3 IAM AWS Glue Lambda CloudWatch Data Transformation Strong experience with DBT for enterprise-scale data modelling, testing, and transformation pipelines. Programming/Query Strong expertise in SQL for data transformation and performance optimization Python (preferred) for automation and data engineering ...

ingestion frameworks for integrating multiple source systems into the cloud data platform. Design and govern data transformation frameworks using DBT. Define and enforce data modelling standards including dimensional modelling, star schema, and enterprise data models. Lead architecture reviews and solution design discussions for new data initiatives. Optimize … Platform Strong experience with Amazon Web Services, including: S3 IAM AWS Glue Lambda CloudWatch Data Transformation Strong experience with DBT for enterprise-scale data modelling, testing, and transformation pipelines. Programming/Query Strong expertise in SQL for data transformation and performance optimization Python (preferred) for automation and data engineering ...

optimising SQL databases (T-SQL, stored procedures, indexing, performance tuning) Building and maintaining SSIS packages Designing and delivering on-prem ETL processes Data modelling and dimensional modelling Contributing to ongoing data warehouse builds and improvements Troubleshooting and resolving issues within the BI environment Working within a tight … with flexibility Modern office space in Reading Key Experience Essential Strong SQL/T-SQL development Solid SSIS experience Proven ETL development background Data modelling & dimensional modelling Data warehousing (schema design + build) Experience as an on-prem BI Developer/SQL Data Engineer Ability to work ...

long-standing data team. This is a traditional on-prem BI Developer/SQL Data Engineer role, focused on database development, ETL, data modelling, and data warehouse work. If you enjoy hands-on SQL development, building robust ETL solutions, and working in a supportive environment where the team shares … work across the full data lifecycle, including: Developing and optimising SQL databases Creating and maintaining SSIS packages Designing and delivering ETL processes Performing data modelling and dimensional modelling Supporting and enhancing the on-prem data warehouse Handling ad-hoc support, troubleshooting, and performance tuning Required Experience Expert ...

long-standing data team. This is a traditional on-prem BI Developer/SQL Data Engineer role, focused on database development, ETL, data modelling, and data warehouse work. If you enjoy hands-on SQL development, building robust ETL solutions, and working in a supportive environment where the team shares … work across the full data lifecycle, including: Developing and optimising SQL databases Creating and maintaining SSIS packages Designing and delivering ETL processes Performing data modelling and dimensional modelling Supporting and enhancing the on-prem data warehouse Handling ad-hoc support, troubleshooting, and performance tuning Required Experience Expert ...

long-standing data team. This is a traditional on-prem BI Developer/SQL Data Engineer role, focused on database development, ETL, data modelling, and data warehouse work. If you enjoy hands-on SQL development, building robust ETL solutions, and working in a supportive environment where the team shares … work across the full data lifecycle, including: Developing and optimising SQL databases Creating and maintaining SSIS packages Designing and delivering ETL processes Performing data modelling and dimensional modelling Supporting and enhancing the on-prem data warehouse Handling ad-hoc support, troubleshooting, and performance tuning Required Experience Expert ...

datasets and dashboards that underpin key regulatory and business decision-making. It's ideal for a hands-on Power BI specialist with strong data modelling expertise , capable of working in a highly regulated environment where data accuracy, lineage, and performance are critical . THE ROLE Design and develop scalable … KPIs, time intelligence, and business logic Perform data transformation using Power Query (M) and SQL-based pipelines Design robust data models (star schema, dimensional modelling) to support performance and scalability Ensure data quality, lineage, and governance standards across all BI assets Monitor and improve dataset performance, refresh reliability ...

include: Designing and developing Power BI reports, data models and DAX measures Modernising existing Excel-based reporting into scalable BI solutions Implementing best practice dimensional modelling (star schema) Creating and managing trusted datasets and reusable metrics Supporting the organisation’s transition toward Microsoft Fabric Working with stakeholders … solutions Enabling self-service analytics through well-structured Power BI datasets Supporting exploratory analytics and proof-of-concept projects Mentoring colleagues on Power BI, modelling and analytics design Your Experience Strong experience with Power BI including modelling, DAX and performance optimisation Advanced Excel skills, including Power Query ...

wealth management firm undergoing a major digital and data transformation . You will take ownership of the data platform architecture, ingestion pipelines, dimensional models, and API layer , delivering a scalable Bronze/Silver/Gold medallion architecture and establishing best practices for data engineering and DevOps. Must Have Azure … Database Azure Data Factory (ADF) Azure Synapse Analytics Azure Functions Data Warehouse Delivery Delivered end-to-end DWH as a lead engineer (source integration dimensional models API layer) Designed and implemented Bronze/Silver/Gold medallion architecture Made architectural decisions and produced Architecture Decision Records (ADRs) Data Engineering ...

Developer to join our data and analytics team. The ideal candidate will have strong expertise in Power BI, SQL Server, SSIS, DAX, and data modelling, with a passion for transforming complex data into meaningful insights that support business decision-making. Key Responsibilities Design, develop, and maintain interactive Power … optimization, database design). Hands-on experience with SSIS for ETL development. Solid understanding of DAX for calculations and performance tuning. Experience in data modelling (dimensional modelling, fact/dimension tables). Familiarity with data warehousing concepts and best practices. Ability to work with large datasets ...

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

decision-making, automation, and future innovation. You'll play a key role in shaping a modern data platform and architecture , working across data engineering, modelling, and integration to deliver scalable, high-quality solutions. The role offers true ownership, allowing you to take projects end-to-end while working with … code tools and code-based approaches (SQL, Python, PySpark), ensuring performance, scalability, and reliability across the data platform. You will take ownership of data modelling and architecture , designing scalable data warehouse and lakehouse structures, including dimensional models and medallion architectures. You'll ensure data is structured effectively ...

regulatory reporting functions. The role requires strong knowledge of complex insurance data structures, market standards, and modern data architecture principles. Key Responsibilities Data Modelling & Architecture Design and maintain conceptual, logical, and physical data models for insurance and financial systems. Ensure alignment with industry standards and data governance frameworks. Develop … maintain data dictionaries, metadata, and modelling documentation. Data Integration & Transformation Collaborate with business analysts, actuaries, and technology teams to integrate data from multiple sources (policy, claims, exposure, financial). Optimise data flows to support reporting, analytics, and regulatory requirements. Stakeholder Engagement Work closely with internal teams to gather ...

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

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

. Experience with Power BI semantic models or Azure Analysis Services/SQL Server Analysis Services (SSAS). Strong data modeling skills (star schema, dimensional modeling). Azure & Data Engineering Experience with: Azure Synapse Analytics Azure Data Factory or similar ETL tools Azure Storage/Data Lake Experience designing ...

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

global operations. Key Responsibilities Architect, design, develop, and maintain enterprise-level Power BI reports and datasets Build and govern advanced data models (star schema, dimensional modelling, enterprise structures) Optimise datasets, composite models, and DAX performance for scalability Lead ETL/ELT design within Microsoft Fabric Lakehouse architecture Develop … orchestrate data pipelines across ingestion, transformation, and modelling layers Optimise and monitor data workflows using Data Lakes and Logic Apps Write and maintain complex T-SQL queries, stored procedures, and optimised database logic Use Python and PySpark for distributed data processing and large-scale transformation within Fabric and cloud ...

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

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

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

meet audit and regulatory standards.Key ResponsibilitiesBuild and maintain a secure PostgreSQL-based data platformLead the shift away from Databricks and spreadsheet-dependent reportingCreate dimensional data models covering investments, pricing, performance and related domainsDevelop reliable ETL/ELT processes in PythonImplement data quality, reconciliation and validation controlsOptimise database performance … PostgreSQL knowledge, including indexing, optimisation and partitioningBackground in financial or investment data environmentsAdvanced SQL and Python skillsExperience migrating data from platforms like DatabricksConfident with dimensional modelling, star schemas, SCDs etc.Experience within regulated financial servicesDesirableExperience in pensions, asset management or institutional investingUnderstanding of performance measurement and attributionExposure to Airflow ...

clients § A deep grounding in data: for example, you should have experience of translating business data and requirements to analytical data models (e.g. Kimball dimensional modelling) § A broad understanding of data and AI: across data engineering, data visualisation, generative AI and automation § Experience leading teams: you need ...

technical concepts clearly to non-technical audiences Act as a positive, approachable technical lead and support other team members Maintain robust data dictionaries and dimensional data models Apply strong analytical thinking and stay up to date with existing and emerging technologies Demonstrate expertise in SQL, data warehousing, dimensional modelling, Databricks, Data Lakes, and knowledge of CDL Kingfisher, Classic data, OGI, and main PAS data sources Skills, Experience & Knowledge: Development experience in SQL programming and systems integration Strong knowledge of SQL, data modelling, data warehousing concepts, and Kimball methodology Experience within Insurance or Broking (preferred) Proven ...