1 to 25 of 28 Permanent Dimensional Modelling Jobs in London

warehousing Minimum 2 years in hands-on development capacity Expertise in one or more modern cloud data platforms: Snowflake, Databricks, AWS Redshift, Microsoft Fabric, or similar Understanding of data modelling principles, dimensional modelling, and database design Proficiency in SQL and query optimization Comprehensive knowledge of ETL/ELT processes and data pipeline architecture Excellent communication skills with More ❯

warehousing Minimum 2 years in hands-on development capacity Expertise in one or more modern cloud data platforms: Snowflake, Databricks, AWS Redshift, Microsoft Fabric, or similar Understanding of data modelling principles, dimensional modelling, and database design Proficiency in SQL and query optimization Comprehensive knowledge of ETL/ELT processes and data pipeline architecture Excellent communication skills with More ❯

Data Modelling Consultant Location: London (3 days per week onsite) Salary: £50,000 – £65,000 + benefits The Company Join a global management consultancy known for delivering large-scale data and digital transformation projects across financial services, capital markets, and energy. You will be part of a collaborative, fast-growing Data Architecture practice that helps some of the world … with stakeholders to gather and interpret data requirements Support metadata management, documentation, and governance activities Contribute to ETL design and data movement between systems Gain hands-on experience with modelling tools such as ERWin, Sparx, or RSA Your Skills and Experience 2–4 years of experience in data modelling or data architecture Exposure to relational and dimensional modelling (3NF, star, snowflake) Strong SQL and data warehousing knowledge Experience in financial services or consulting is highly desirable Strong communication and stakeholder engagement skills More ❯

Data Modelling Consultant Location: London (3 days per week onsite) Salary: £50,000 – £65,000 + benefits The Company Join a global management consultancy known for delivering large-scale data and digital transformation projects across financial services, capital markets, and energy. You will be part of a collaborative, fast-growing Data Architecture practice that helps some of the world … with stakeholders to gather and interpret data requirements Support metadata management, documentation, and governance activities Contribute to ETL design and data movement between systems Gain hands-on experience with modelling tools such as ERWin, Sparx, or RSA Your Skills and Experience 2–4 years of experience in data modelling or data architecture Exposure to relational and dimensional modelling (3NF, star, snowflake) Strong SQL and data warehousing knowledge Experience in financial services or consulting is highly desirable Strong communication and stakeholder engagement skills More ❯

across the organisation. What you'll be doing: Build and maintain scalable data pipelines using Azure Data Factory and Databricks Develop transformation workflows in dbt, SQL, and Python Design dimensional models and semantic layers to support analytics use cases Implement automated data quality checks, monitoring, and alerting systems - linking issues to business impact Create reusable data assets and documentation … related roles Strong proficiency in SQL, Python, and dbt (strongly preferred) Hands-on experience with Azure Databricks and cloud-based data platforms (Snowflake experience also valued) Solid understanding of dimensional modelling, lakehouse/warehouse design, and modern data stack Familiarity with Git, CI/CD, and software engineering best practices Experience with Power BI (or Tableau/Looker More ❯

Spotfire Technical Lead/Hands-On Architect (Spotfire to Power BI Migration) Location: Central London & Remote Type: Contract Spotfire Architect with strong data modelling skills to lead and support the migration of complex Spotfire reports to Power BI. The role requires deep technical expertise in Spotfire s visual and scripting frameworks, alongside the ability to reverse-engineer, redesign and …/dashboards in Spotfire 8+ years of experience in BI & analytics with at least 5 years in Spotfire (including architecture, scripting, and advanced configurations). Strong experience with data modelling for BI platforms; dimensional modelling, fact/dimension tables, normalisation/denormalisation. Hands-on expertise with IronPython scripting, custom expressions, data functions (TERR/Python/R More ❯

Spotfire Technical Lead/Hands-On Architect (Spotfire to Power BI Migration) Location: Central London & Remote Type: Contract Spotfire Architect with strong data modelling skills to lead and support the migration of complex Spotfire reports to Power BI. The role requires deep technical expertise in Spotfire s visual and scripting frameworks, alongside the ability to reverse-engineer, redesign and …/dashboards in Spotfire 8+ years of experience in BI & analytics with at least 5 years in Spotfire (including architecture, scripting, and advanced configurations). Strong experience with data modelling for BI platforms; dimensional modelling, fact/dimension tables, normalisation/denormalisation. Hands-on expertise with IronPython scripting, custom expressions, data functions (TERR/Python/R More ❯

integration Integration & Interoperability Experience connecting Microsoft BI tools with Tableau, Amazon QuickSight , or similar platforms Understanding of REST APIs , Power BI Embedded , and programmatic data access patterns Data Engineering & Modelling Strong T-SQL skills for data retrieval and performance tuning Knowledge of dimensional modelling , star/snowflake schemas , and data warehouse best practices Preferred Qualifications Microsoft certifications More ❯

with Data Engineer in the design, build, and maintain scalable data pipelines using Azure Data Factory and Databricks to automate data ingestion, transformation, and processing workflows. DCreate and maintain dimensional data models and semantic layers that support business intelligence and analytics use cases. Build and optimise data transformation workflows using dbt, SQL, and Python to create clean, well-documented … and modern data transformation tools (dbt strongly preferred), with experience in cloud data platforms (Azure Databricks, Snowflake, or similar). Proven experience designing and implementing scalable data architectures, including dimensional modelling, data lakehouse/warehouse concepts, and modern data stack technologies. Strong software engineering practices including version control (Git), CI/CD pipelines, code testing, and infrastructure as More ❯

into data solutions. Design, build, and maintain data pipelines and transformations that turn raw data into structured, analysis-ready datasets. Develop and optimise data models (including Data Vault and dimensional modelling) to support large-scale analytics. Implement and enforce data quality, governance, and validation frameworks . Write complex SQL to ensure accuracy, performance, and scalability. Collaborate with data … functional teams to deliver insights and recommendations that drive business outcomes. Key Skills: Strong proficiency in SQL for data transformation and analytics. Hands-on experience with Snowflake , dbt , Data Modelling , and Data Vault methodologies. Solid understanding of data warehousing concepts and version control (GitHub) . Experience with cloud platforms (AWS or Azure) and scripting in Python . Familiarity with More ❯

Data Modelling Consultant Location: London (3 days per week onsite) Salary: £50,000 - £65,000 + benefits The Company Join a global management consultancy known for delivering large-scale data and digital transformation projects across financial services, capital markets, and energy. You will be part of a collaborative, fast-growing Data Architecture practice that helps some of the world … with stakeholders to gather and interpret data requirements Support metadata management, documentation, and governance activities Contribute to ETL design and data movement between systems Gain hands-on experience with modelling tools such as ERWin, Sparx, or RSA Your Skills and Experience 2-4 years of experience in data modelling or data architecture Exposure to relational and dimensional modelling (3NF, star, snowflake) Strong SQL and data warehousing knowledge Experience in financial services or consulting is highly desirable Strong communication and stakeholder engagement skills More ❯

team development etc) Very strong technical skills that will include - SQL, SSIS, SSRS, SAS, Power BI, Power Platform, Azure Data Factory, Azure Data Lake, Databricks A good understanding of dimensional modelling techniques, including Kimball's Business Development Lifecycle Ability to design hybrid data solutions across on-prem and cloud data sources Expert with data engineering tools and automation More ❯

Role – Technology Lead Technology – Snowflake, SQL Server, PostgreSQL, Data Warehousing, Data Lake, Medallion, Data Vault, Data Fabric, Semantic modelling Location – UK Business Unit – DNAINS Compensation – Competitive (including bonus) Job Description We are seeking an experienced Data Modeler who can analyse and understand the existing customer data and analytics models on SQL Server, and design efficient data models for Snowflake. … strong understanding of Insurance domain 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. You will analyse existing data … teams to translate complex reporting and analytics needs into efficient, well-governed data models. Your leadership will be key in identifying gaps, driving improvements, and implementing best practices in dimensional modelling, normalization, and metadata management. A strong understanding of the Insurance domain—including Specialized Insurance, London Market operations, and Regulatory Data—is essential. You will apply this domain More ❯

Role – Technology Lead Technology – Snowflake, SQL Server, PostgreSQL, Data Warehousing, Data Lake, Medallion, Data Vault, Data Fabric, Semantic modelling Location – UK Business Unit – DNAINS Compensation – Competitive (including bonus) Job Description We are seeking an experienced Data Modeler who can analyse and understand the existing customer data and analytics models on SQL Server, and design efficient data models for Snowflake. … strong understanding of Insurance domain 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. You will analyse existing data … teams to translate complex reporting and analytics needs into efficient, well-governed data models. Your leadership will be key in identifying gaps, driving improvements, and implementing best practices in dimensional modelling, normalization, and metadata management. A strong understanding of the Insurance domain—including Specialized Insurance, London Market operations, and Regulatory Data—is essential. You will apply this domain More ❯

and Airflow. Good understanding of service-oriented architecture; experience of exposing and consuming data via APIs, streams and webhooks. Experience designing scalable data models, warehouse/lakehouse architectures, and dimensional modelling for analytics. Confidence in coding, scripting, configuring, versioning, debugging, testing and deploying. Skilled in optimising queries, pipelines, and storage for cost and performance efficiency. Good understanding of More ❯

and Airflow. Good understanding of service-oriented architecture; experience of exposing and consuming data via APIs, streams and webhooks. Experience designing scalable data models, warehouse/lakehouse architectures, and dimensional modelling for analytics. Confidence in coding, scripting, configuring, versioning, debugging, testing and deploying. Skilled in optimising queries, pipelines, and storage for cost and performance efficiency. Good understanding of More ❯

all data projects while engaging with senior stakeholders to deliver impactful solutions. Specifically, you can expect to be involved in the following: Designing and implementing both relational (3NF) and dimensional (star/snowflake) data models for large-scale financial systems and analytical platforms. Working hands-on with ETL design, metadata management, and data cataloguing , ensuring robust data lineage and … Visio , and handling semi-structured data formats (JSON, XML, Parquet). SKILLS AND EXPERIENCE The successful Data Modeller will have the following skills and experience: Proven experience in data modelling within consulting or financial services environments. Strong expertise in ERWin (or equivalent tools such as Sparx, RSA, Visio). Hands-on experience with relational and dimensional modelling More ❯

all data projects while engaging with senior stakeholders to deliver impactful solutions. Specifically, you can expect to be involved in the following: Designing and implementing both relational (3NF) and dimensional (star/snowflake) data models for large-scale financial systems and analytical platforms. Working hands-on with ETL design, metadata management, and data cataloguing , ensuring robust data lineage and … Visio , and handling semi-structured data formats (JSON, XML, Parquet). SKILLS AND EXPERIENCE The successful Data Modeller will have the following skills and experience: Proven experience in data modelling within consulting or financial services environments. Strong expertise in ERWin (or equivalent tools such as Sparx, RSA, Visio). Hands-on experience with relational and dimensional modelling More ❯

ll bring: Experience in analytics, AI/data science, or data product environments - ideally within ad tech, media, or digital. Strong grasp of data warehousing concepts - data flows, ETL, dimensional modelling, and data quality. Solid SQL skills and the ability to interrogate complex data from diverse sources. Hands-on understanding of cloud-based data architectures A proven ability More ❯

the right time. Essentially, to ensure you succeed in this role you're going to need Deep, hands-on experience designing and building data warehouses with strong command of dimensional modeling (e.g., Kimball methodology) Expertise in Google Cloud Platform, especially BigQuery architecture, optimization, and cost management Advanced SQL skills and production-level experience using dbt (or similar tools) to More ❯

central Data Platform, working closely with the Data Management Team. Analysis of normalised transactional data and analytic data sources. Analysis of semi-structured and file-based data extracts. Data modelling to transform operational data into analytic/reporting structures such as Kimball-style multi-dimensional models. 💡Strong SQL, Sigma, PowerBI, Matilion, DBT, Python Essential Skills for the Lead … Data Analyst: Proven Data Analyst experience of at least 5 years, within a Financial Services environment, with particular emphasis on Risk or cross asset derivatives areas. Data modelling, cleansing and enrichment, with experience in conceptual, logical and physical data modelling and data cleansing and standardisation. Familiarity with Data warehousing and analytical data structures. Data quality assurance, validation and More ❯

central Data Platform, working closely with the Data Management Team. Analysis of normalised transactional data and analytic data sources. Analysis of semi-structured and file-based data extracts. Data modelling to transform operational data into analytic/reporting structures such as Kimball-style multi-dimensional models. 💡Strong SQL, Sigma, PowerBI, Matilion, DBT, Python Essential Skills for the Lead … Data Analyst: Proven Data Analyst experience of at least 5 years, within a Financial Services environment, with particular emphasis on Risk or cross asset derivatives areas. Data modelling, cleansing and enrichment, with experience in conceptual, logical and physical data modelling and data cleansing and standardisation. Familiarity with Data warehousing and analytical data structures. Data quality assurance, validation and More ❯

most relevant data from Snowflake to support business questions and performance tracking. o Conduct exploratory data analysis to uncover trends, anomalies, and opportunities for improvement in logistics operations. Data Modelling and Metric Logic o Design and maintain scalable data models that reflect logistics processes and support cross-functional reporting. o Define and implement logic for KPI generation and performance … Proficiency in designing scalable and efficient data models using Snowflake. Experience with SQL for querying, transforming, and preparing data for analysis and visualization. Understanding of data warehousing principles and dimensional modeling. • Data Integration and ETL: Knowledge of ETL processes, data extraction, and transformation, along with experience in SQL and data connectors. • Data Analysis and Visualization: Skills in visualizing data More ❯

helping enterprise clients structure, govern, and leverage data effectively. The Role As a Senior Data Modeller, you will act as a hands-on lead across client projects, setting data modelling standards and ensuring delivery across multiple stakeholders. You will design frameworks, define best practice for data structures, and drive consistency across systems while remaining highly involved in technical delivery. … Key Responsibilities Lead on data modelling design and implementation across client programmes Create relational and dimensional models for enterprise data warehouses and analytics platforms Define metadata standards, data catalogues, and lineage documentation Collaborate with architects, engineers, and business stakeholders to ensure data models meet business needs Support data migration, governance, and transformation initiatives Your Skills and Experience 5+ … years of experience in data modelling or architecture, ideally within financial services or consulting Strong knowledge of relational and dimensional design (3NF, star, snowflake) Proficient in ERWin, Sparx, or similar tools Experience working with semi-structured data (JSON, XML, Parquet) Excellent communication and client-facing skills More ❯

across the organisation. Key Responsibilities: Design and maintain scalable data platforms using cloud-native technologies such as Databricks and AWS across development, staging, and production environments Build and govern dimensional data models and semantic layers to power consistent and trusted analytics Integrate data from diverse sources including cloud warehouses, APIs, and operational systems Define semantic layers using dbt and … to ensure performance and cost efficiency Collaborate with cross-functional teams on architecture decisions, technical designs, and data governance standards You Will Have: Proven hands-on expertise in data modelling with a strong track record of designing and implementing complex dimensional models and enterprise-wide canonical data models The ability to translate complex business processes into scalable and More ❯