15 of 15 Remote/Hybrid 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 ...

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

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

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

trusted datasets for analytics and business intelligence Implement data quality tests and monitoring to ensure accuracy and reliability Optimise query performance using effective data modelling and materialisation strategies Establish and maintain documentation and data dictionaries for analytical models, KPI definitions and metrics frameworks Conduct exploratory data analysis to identify … Strong SQL skills with experience in complex data transformations, CTEs and window functions Expertise with dbt and modern analytics engineering tools Solid understanding of dimensional modelling and data warehousing concepts Experience with Git-based workflows for version control and collaboration for analytics Knowledge of data testing frameworks ...

making across the business. As a senior member of the BI team, you will help develop scalable reporting solutions, promote best practice in data modelling and visualisation, and support the continued adoption of self-service analytics. Key Responsibilities Design, develop and maintain enterprise-grade Power BI dashboards, reports … semantic models Build and optimise data models using best-practice dimensional modelling techniques Develop advanced DAX measures and calculations to support complex analytical requirements Create intuitive and visually engaging dashboards that allow stakeholders to explore and interpret data effectively Optimise report and dataset performance to ensure scalable ...

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

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

closely with engineering, data governance, and business teams to ensure data structures are efficient, consistent, and aligned with organizational standards. Data Modeling & Architecture Design dimensional models (fact tables, conformed dimensions, SCD types) and/or 3NF or Data Vault structures appropriate for business and technical requirements. Create and maintain … Clearly communicate model changes, business impacts, and dependencies to technical and non technical stakeholders. YOUR PROFILE Technical Expertise Demonstrated experience in data modeling, including dimensional modeling (star, snowflake), normalization (3NF), and/or Data Vault 2.0. Strong SQL and DDL skills, with the ability to reason about query performance ...