8 of 8 Permanent Dimensional Modelling Jobs in the South East

ETL pipelines using Azure Data Factory, SSIS, and SQL Server Developing and optimising stored procedures and queries for data transformation and integration Building and maintaining data warehouse solutions and dimensional data models Supporting data integration projects and ensuring data quality, accuracy, and consistency Delivering insights through Power BI dashboards and reports Using Python and PowerShell for automation and data … Were Looking For Strong experience with SQL Server (T-SQL, stored procedures, optimisation) Hands-on expertise with Azure Data Factory (ADF) and SSIS Solid understanding of data warehousing and dimensional modelling Proven experience building ETL/data integration solutions Exposure to Power BI , Python , and PowerShell is highly desirable Financialservicesorinsuranceexperienceisdesirablebutnotessential Excellent problem-solving skills with a proactive, can 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 ❯

a team of data engineers, analytics engineers, data scientists and AI specialists to design and evolve scalable data platforms and modern data products that enable self-service analytics, advanced modelling, and AI-driven decision-making across our insurance business. What you’ll do: Design and manage scalable cloud data platforms (Databricks on AWS) across development, staging, and production environments … ensuring reliable performance and cost efficiency. Integrate and model data from diverse sources – including warehouses, APIs, marketing platforms, and operational systems – using DBT, Delta Live Tables, and dimensional modelling to deliver consistent, trusted analytics. Enable advanced AI and ML use cases by building pipelines for vector search, retrieval-augmented generation (RAG), feature engineering, and model deployment. Ensure security … contributing to architectural decisions, authoring ADRs, and participating in reviews, data councils, and platform enablement initiatives. What we’d love you to bring: Proven, hands-on expertise in data modelling, with a strong track record of designing and implementing complex dimensional models, star and snowflake schemas, and enterprise-wide canonical data models Proficiency in converting intricate insurance business 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 ❯

Streams, Snowpark, Time Travel, Secure Data Sharing) to improve automation and accessibility. Collaboration: Work closely with analysts and stakeholders to deliver data products and troubleshoot issues. Analytics Enablement: Implement dimensional models to provide clean, reusable datasets for reporting and advanced analytics. Monitoring & Reliability: Maintain monitoring, alerting, and cost-management processes for Snowflake and pipelines. Continuous Improvement: Contribute to shared … transformations and pipeline automation. Practical experience with Snowflake features and RBAC management. Familiarity with ingestion tools (Airbyte, Fivetran, Hevo) and cloud services (AWS preferred). Solid understanding of data modelling, governance principles, and BI enablement (Power BI). Knowledge of CI/CD and version-controlled development practices in git. Desirable: Experience with enterprise systems (CRM, BSS/OSS 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 ❯