18 of 18 Remote/Hybrid Dimensional Modelling Jobs in England

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

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

e.g., Azure SQL, Snowflake). Experience with ETL/ELT tooling (e.g., SSIS, dbt, Azure Data Factory) and data pipeline design. Understanding of data modelling principles (normalisation, dimensional modelling/star schema for data warehousing). Experience of diagnosing and resolving database performance issues. Familiarity with database ...

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

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

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

Data Analyst plays a critical role in delivering high-quality analytical insight that drives decisions across AJ Bell. The role blends advanced analytics, data modelling, and stakeholder engagement to deliver solutions that are accurate, scalable, and aligned to our strategic data ambitions. The jobholder will support cloud transformation, adoption … Delivery & Technical Excellence Deliver high-quality analytical outputs for senior data leadership. Proactively deep dive and explore challenges to create recommendations Conduct data design, modelling and exploration to support trusted reporting. Perform data discovery to understand new and existing data sources. Produce compelling visualisations and dashboards using Power BI. ...

solid track record in delivering complex solutions. They will be proficient in desktop and cloud, with expert level experience in calculated metrics, data modelling, and optimising reports. You will · Lead the design and development of visualisation dashboards that meet complex data requirements and present information in a clear … perform data blending, data aggregation and complex calculated fields when required Possess hands on experience with SQL and knowledge of data warehousing and dimensional modelling will be advantageous Experience using large data platforms such as Snowflake, Databricks or similar Exposure to other visualisation platforms is helpful ...

integration, advanced analytics, and AI driven decision making across complex digital transformation programmes. With access to modern data platforms, high quality datasets, and leading modelling frameworks, you will guide engineering, analytics, and architecture teams in building secure, scalable, and well governed data structures. This role empowers you to shape … operational needs Translate business requirements into robust data entities, attributes, relationships, and constraints; ensure traceability from requirements to models Establish and enforce GDM modelling standards and naming conventions (e.g., normalization, dimensional/star/snowflake patterns, data vault where appropriate) Design dimensional models (facts, dimensions, hierarchies, slowly ...

Design, build and maintain analytics ready data models used across the organization. Develop transformations using dbt on a Snowflake data platform. Apply best practice dimensional modelling to create reliable, well-structured datasets. SKILLS AND EXPERIENCE The successful Analytics Engineer will have the following skills and experience: Strong commercial … experience writing complex SQL for analytics and data modelling. Proven experience designing dimensional data models, ideally using Kimball principles. Hands on experience using dbt for data transformation. Experience working with cloud data warehouses, ideally Snowflake. Comfortable using Python or similar languages for data logic and problem solving. A builder ...

Design, build and maintain analytics ready data models used across the organization. Develop transformations using dbt on a Snowflake data platform. Apply best practice dimensional modelling to create reliable, well-structured datasets. SKILLS AND EXPERIENCE The successful Analytics Engineer will have the following skills and experience: Strong commercial … experience writing complex SQL for analytics and data modelling. Proven experience designing dimensional data models, ideally using Kimball principles. Hands on experience using dbt for data transformation. Experience working with cloud data warehouses, ideally Snowflake. Comfortable using Python or similar languages for data logic and problem solving. A builder ...

Design, build and maintain analytics ready data models used across the organization. Develop transformations using dbt on a Snowflake data platform. Apply best practice dimensional modelling to create reliable, well-structured datasets. SKILLS AND EXPERIENCE The successful Analytics Engineer will have the following skills and experience: Strong commercial … experience writing complex SQL for analytics and data modelling. Proven experience designing dimensional data models, ideally using Kimball principles. Hands on experience using dbt for data transformation. Experience working with cloud data warehouses, ideally Snowflake. Comfortable using Python or similar languages for data logic and problem solving. A builder ...

four domains (Customers, Applications, Assessments, Cases), aligning with the DSFS data model and existing Netezza structures. Produce the EDW logical and physical data models, dimensional models for the Semantic Layer, and Data Lake zone architecture (Bronze/Silver/Gold). Define Enterprise Semantic Layer design, including pre-computed … aggregations, dimensional models, and Tableau connectivity specifications. Lead source system profiling (D02), producing profile reports for each system in the seven-system scope. Ensure data model designs meet NFRs: 200 concurrent users, 1-hour maximum response time, and 99.5% availability. Provide architectural guidance to the Data Architect and Lakehouse ...

data platform using SQL and Python (PySpark), with a focus on reliability, performance and maintainability. Develop and maintain core data models (curated layers, dimensional models, shared definitions) that enable consistent KPI reporting and analysis. Implement and embed data quality controls (freshness, completeness, accuracy, reconciliation checks) and monitoring so issues … models from "fragile and fragmented" to "trusted, governed and embedded" through practical engineering improvements. Solid experience across the data engineering lifecycle: ingestion, transformation/modelling, and enabling consumption through BI/semantic conventions. Hands-on capability with modern cloud data platforms and tooling, and a clear view of what ...