15 of 15 Remote/Hybrid Permanent Dimensional Modelling Jobs

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

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

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

Deep practical experience in data warehousing principles, proven experience working with cloud data warehouses such as Databricks (preferred), Snowflake or BigQuery. Strong understanding of dimensional modeling (Star/Snowflake schemas) and modern data stack tools (e.g., dbt). Expert-level SQL skills (complex joins, window functions, and performance tuning ...

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

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

Required 8+ years of professional experience in data engineering, including 5+ years of people management and technical leadership experience. Deep understanding of Ralph Kimball dimensional modelling best practices, including star schema design and data cube modelling to support scalable analytics and reporting. Experience building and optimising cloud ...

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

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