1 to 25 of 31 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 ...

include: Designing and developing Power BI reports, data models and DAX measures Modernising existing Excel-based reporting into scalable BI solutions Implementing best practice dimensional modelling (star schema) Creating and managing trusted datasets and reusable metrics Supporting the organisation’s transition toward Microsoft Fabric Working with stakeholders … solutions Enabling self-service analytics through well-structured Power BI datasets Supporting exploratory analytics and proof-of-concept projects Mentoring colleagues on Power BI, modelling and analytics design Your Experience Strong experience with Power BI including modelling, DAX and performance optimisation Advanced Excel skills, including Power Query ...

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

OVERVIEW: We are seeking an experienced Data Architect/Data Modeler with strong insurance industry standards knowledge and a solid foundation in modern data modelling practices. The ideal candidate will have hands-on experience with modelling tools, data frameworks, and insurance industry data exchange standards. This role involves … Excel bordereaux templates to support real-time API ingestion from MGA/TPA partner systems and monthly bordereaux submissions Develop data models using Dimensional (Star/Snowflake), Data Vault, and 3NF methodologies. Create and manage metadata and modelling artefacts using Erwin with traceability and governance. Support Medallion Architecture ...

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

Python skills Experience delivering analytics solutions within modern cloud data platforms Experience leading teams across analytics and BI delivery Strong understanding of data modelling, including dimensional modelling Experience delivering enterprise BI and analytics solutions, including dashboards, semantic models and insight storytelling What's on Offer Salary ...

procedures, performance tuning Strong troubleshooting skills for complex multi-system data issues. Strong understanding of data architecture concepts: Data lakes/lakehouse/warehouse, dimensional modeling, ELT/ETL patterns Batch orchestration, dependency management, SCD handling, incremental loads Azure Ecosystem (Preferred/Good to Have) Azure data services experience ...

global operations. Key Responsibilities Architect, design, develop, and maintain enterprise-level Power BI reports and datasets Build and govern advanced data models (star schema, dimensional modelling, enterprise structures) Optimise datasets, composite models, and DAX performance for scalability Lead ETL/ELT design within Microsoft Fabric Lakehouse architecture Develop … orchestrate data pipelines across ingestion, transformation, and modelling layers Optimise and monitor data workflows using Data Lakes and Logic Apps Write and maintain complex T-SQL queries, stored procedures, and optimised database logic Use Python and PySpark for distributed data processing and large-scale transformation within Fabric and cloud ...

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

clients § A deep grounding in data: for example, you should have experience of translating business data and requirements to analytical data models (e.g. Kimball dimensional modelling) § A broad understanding of data and AI: across data engineering, data visualisation, generative AI and automation § Experience leading teams: you need ...

patching, security, and performance tuning. Monitor database and warehouse workloads, diagnosing and resolving performance or integrity issues. Ensure strong standards around data quality, governance, modelling, and security across all datasets and warehouse layers. Work closely with business stakeholders to translate requirements into well structured data models and reporting solutions. … preferred). Proficiency in Python for automation, scripting, and data processing. Practical experience with SQL Server Database Administration tasks. Knowledge of data warehouse architecture, dimensional modelling, and ETL frameworks. Experience with SSIS or similar tools for ETL and data movement. Familiarity with reporting tools such as SSRS ...

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

Advanced command of SQL/T-SQL (Complex queries, Window Functions, Performance Tuning, and Relational Modeling). Data Warehousing Foundations: Solid understanding of dimensional modeling (Star/Snowflake schemas, Surrogate Keys, and Slowly Changing Dimensions - SCD). ETL Tooling: Hands-on experience with SSIS (SQL Server Integration Services ...

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

robust data platform from ingestion through to consumption. Tech Environment: Azure Data Lake Storage Azure Synapse Medallion Architecture ETL/data ingestion pipelines Dimensional modelling Strong governance, security, and error handling Ideal Experience: Azure-based data platform architecture End-to-end data warehouse design and delivery Data governance ...

design, deployment, and maintenance process is followed. Experience in Agile delivery methodology in a data and analytics context Deep understanding of data warehouse processes, dimensional modeling and ETL/Integration Knowledge of industry standard Business Intelligence (BI) tools, such as: Oracle (OBIEE), Business Objects, etc. Experience with statistical programming ...

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

Office) Salary: Up to £90,000 This is an exciting opportunity to join a high-growth consultancy environment where you will shape data modelling standards, influence enterprise-level design, and work directly with senior stakeholders across complex financial services programmes. If you enjoy combining hands-on modelling with … strong footprint across financial services and energy. Their data capability exceeds 300 specialists, and their Data Architecture function is known for delivering high-quality modelling, strategy and metadata solutions across large-scale transformation programmes. They operate in a collaborative, low-ego environment where expertise is valued and career progression ...

escalation point for advanced BI issues. Key Responsibilities: Develop and maintain enterprise-grade Power BI reports, datasets, and data models (including star schemas and dimensional models). Lead ETL/ELT design and optimisation within Microsoft Fabric Lakehouse, including Data Pipelines, Notebooks, and cloud-based ingestion/transformation layers. … standards are met. Collaborate with global teams on BI modernisation initiatives, ERP data projects, and multi-region rollouts. Skills & Experience Power BI (DAX, data modelling, composite models, dataset optimisation). Strong capability in Microsoft Fabric, including Lakehouse architecture, Data Pipelines, and Notebooks. Advanced SQL, T-SQL optimisation, Python ...

escalation point for advanced BI issues. Key Responsibilities: Develop and maintain enterprise-grade Power BI reports, datasets, and data models (including star schemas and dimensional models). Lead ETL/ELT design and optimisation within Microsoft Fabric Lakehouse, including Data Pipelines, Notebooks, and cloud-based ingestion/transformation layers. … standards are met. Collaborate with global teams on BI modernisation initiatives, ERP data projects, and multi-region rollouts. Skills & Experience Power BI (DAX, data modelling, composite models, dataset optimisation). Strong capability in Microsoft Fabric, including Lakehouse architecture, Data Pipelines, and Notebooks. Advanced SQL, T-SQL optimisation, Python ...

escalation point for advanced BI issues. Key Responsibilities: Develop and maintain enterprise-grade Power BI reports, datasets, and data models (including star schemas and dimensional models). Lead ETL/ELT design and optimisation within Microsoft Fabric Lakehouse, including Data Pipelines, Notebooks, and cloud-based ingestion/transformation layers. … standards are met. Collaborate with global teams on BI modernisation initiatives, ERP data projects, and multi-region rollouts. Skills & Experience Power BI (DAX, data modelling, composite models, dataset optimisation). Strong capability in Microsoft Fabric, including Lakehouse architecture, Data Pipelines, and Notebooks. Advanced SQL, T-SQL optimisation, Python ...