1 to 25 of 30 Dimensional Modelling Jobs in the UK

from SSRS into Snowflake Assess and rationalise existing reports (remove duplication, improve logic, simplify where possible) Redesign reporting structures to align with modern data modelling principles Define and Implement Best Practice Establish scalable standards for: Data modelling (e.g. dimensional modelling, layered architecture) Transformation workflows (ELT patterns … experience working with Snowflake (or similar cloud data warehouse) Experience migrating from legacy BI/reporting tools (e.g. SSRS, Cognos, Business Objects) Strong data modelling experience (dimensional modelling, star schemas, etc.) Experience building transformation layers in ELT environments Track record of delivering in hands-on roles ...

behind every report and every operational data feed at ECP, continue the migration of our data warehouse and data lake to a modern dimensional model, finish the rollout of a principle-of-least-privilege security model across a multi-server SQL estate, and continue the migration of our reporting … will include: Setting and personally delivering target architecture for the ECP data estate the data warehouse, data hub, data lake, raw/ODS layers, dimensional model, audit and schema-change tracking, and the load schedules that tie them together. Hands-on T-SQL, stored procedure, ETL framework and PowerShell ...

dashboards Contribute to long-term AI and data innovation initiatives YOUR SKILLS AND EXPERIENCE: 6+ years' experience in data engineering Strong expertise in data modelling (dimensional modelling and semantic layer design) Hands-on experience with Microsoft Fabric and/or Azure data services Proven ...

govern solution architectures aligned to business and technical requirements Design scalable cloud data platforms, lakehouse architectures, and analytics ecosystems Lead architecture for data modelling, warehousing, and ETL/ELT pipelines Design and oversee BI and semantic layer architecture (Power BI and similar tools) Define standards for data governance, security … background in enterprise data platform and analytics architecture Extensive experience with Azure data ecosystem (Fabric, Databricks, Synapse, Azure Data Factory) Strong understanding of data modelling (Kimball, dimensional modelling, lakehouse patterns) Experience designing enterprise ETL/ELT and data integration architectures Strong BI architecture experience (Power BI, Tableau ...

development including query development and optimisation, stored procedures, and performance tuning Expert knowledge of end-to-end enterprise BI using Power BI including semantic modelling, DAX, Power Query, data visualisation best practice, report development, and performance optimisation Advanced data modelling including dimensional modelling, star schema design ...

Understanding of vector databases, RAG architectures, and embedding-based retrieval. Experience with containerisation (Docker) and/or CI/CD pipelines. Exposure to data modelling (including dimensional modelling) and/or metadata management. Why Fitch? At Fitch Group, the combined power of our global perspectives is what ...

requirement for a Data Solution Architect to design, lead and deliver scalable, enterprise-grade data platforms. This role requires deep expertise in data architecture, dimensional data modelling (Kimball) and modern cloud-based data ecosystems (ideally Databricks) . Core Technical Expertise Strong experience in data solution architecture within enterprise … environments Proven hands-on expertise in data warehousing concepts and implementation Deep knowledge of Kimball dimensional modelling methodology. Platforms & Tools Experience with Databricks (preferred) or similar platforms: Snowflake, BigQuery, Redshift, Synapse, or equivalent Strong proficiency with: SQL (advanced level) Spark/PySpark Data pipeline orchestration tools (e.g., Airflow ...

move and expose data safely and reliably. Agile ways of working with Jira/Confluence; clear stakeholder communication and concise technical documentation. Data warehousing & modelling (e.g., Redshift; dimensional modelling). Basic Power BI familiarity to partner with BI developers and validate end-to-end data flows. ...

role. Key Responsibilities: Design, build, and maintain data solutions using Microsoft Fabric. Develop and optimise data pipelines, Lakehouses, and Data Warehouses. Create and maintain dimensional data models and semantic models. Support Power BI reporting and analytics requirements. Ensure data quality, performance, security, and governance. Collaborate with business stakeholders … deliver scalable data solutions. Required Skills: Minimum 2 years' experience working with Microsoft Fabric. Strong experience in data modelling (Star Schema, dimensional modelling). Strong SQL skills and experience with data warehousing concepts. Experience with Power BI and semantic models. Knowledge of ETL/ELT processes ...

business intelligence solutions, developing dashboards and reports, improving data quality, and supporting data-driven decision-making. The role combines stakeholder engagement, business analysis, data modelling, and reporting, offering the opportunity to contribute to both operational and strategic initiatives. Requirements Strong experience in a Data Analyst, BI Analyst, or similar … Advanced SQL skills with experience extracting, manipulating, and analysing data from relational databases. Experience building dashboards and reports using Power BI. Understanding of data modelling principles, including dimensional modelling and star schema design. Experience gathering, documenting, and translating business requirements into analytical solutions. Knowledge of ETL processes ...

frameworks using Spark and Python or SQL-based pipelines. Optimise query performance across large datasets, improving efficiency and cost control. Define and manage data modelling standards, including dimensional modelling approaches. Develop CI and CD pipelines to enable reliable deployment and testing of data products. Create and maintain … legacy data systems into scalable architectures. Proven ability to design and build data pipelines using Spark and Python or SQL. Strong understanding of data modelling, including star and snowflake schemas. Experience working with BI tools and semantic layers such as Looker or similar platforms. Familiarity with version control ...

frameworks using Spark and Python or SQL-based pipelines. Optimise query performance across large datasets, improving efficiency and cost control. Define and manage data modelling standards, including dimensional modelling approaches. Develop CI and CD pipelines to enable reliable deployment and testing of data products. Create and maintain … legacy data systems into scalable architectures. Proven ability to design and build data pipelines using Spark and Python or SQL. Strong understanding of data modelling, including star and snowflake schemas. Experience working with BI tools and semantic layers such as Looker or similar platforms. Familiarity with version control ...

frameworks using Spark and Python or SQL-based pipelines. Optimise query performance across large datasets, improving efficiency and cost control. Define and manage data modelling standards, including dimensional modelling approaches. Develop CI and CD pipelines to enable reliable deployment and testing of data products. Create and maintain … legacy data systems into scalable architectures. Proven ability to design and build data pipelines using Spark and Python or SQL. Strong understanding of data modelling, including star and snowflake schemas. Experience working with BI tools and semantic layers such as Looker or similar platforms. Familiarity with version control ...

Terraform, CI/CD pipelines, and Infrastructure as Code. Git/GitLab and modern software development practices. API integration and data services. Data warehousing, dimensional modelling, and dbt. Power BI familiarity. Experience working within government or highly regulated environments. What's In It For You? Opportunity to work ...

dashboards. - Build and optimise Power BI semantic models to meet organisational reporting needs. - Create and manage dataflows and shared datasets for enterprise reporting. Data Modelling & Architecture: - Apply dimensional modelling principles to enhance analytical workloads. - Collaborate with data engineers to design and document effective technical solutions. Operational Support … qualification in a technology discipline (Desirable). Proven experience in developing user requirements into effective BI visualisations (Essential). Familiarity with Power BI, data modelling, Azure DevOps, ORACLE, and Microsoft SQL Server. Strong analytical and problem-solving skills with the ability to communicate effectively. A full UK driving licence ...

collaborative engineering team. Key responsibilities include: Designing and developing scalable data pipelines for ingestion and transformation Writing high quality SQL for complex data modelling and analytics use cases Implementing dimensional models using Kimball methodologies Working with cloud data warehouse technologies such as Snowflake or BigQuery Supporting analytics … writing complex SQL, including CTEs and window functions Experience working with modern cloud data warehouses such as Snowflake, BigQuery or similar Solid understanding of dimensional modelling and data warehousing concepts Exposure to data transformation tools such as DBT is beneficial Basic knowledge of Python, ideally in the context ...

Fabric Integrate and transform Salesforce data into a unified data platform. Develop and optimise ETL/ELT processes for performance and scalability. Implement data modelling best practices (star schema, dimensional modelling). Collaborate with stakeholders to translate business requirements into technical solutions. Key Requirements Proven experience ...

Fabric Integrate and transform Salesforce data into a unified data platform. Develop and optimise ETL/ELT processes for performance and scalability. Implement data modelling best practices (star schema, dimensional modelling). Collaborate with stakeholders to translate business requirements into technical solutions. Key Requirements Proven experience ...

Fabric Integrate and transform Salesforce data into a unified data platform. Develop and optimise ETL/ELT processes for performance and scalability. Implement data modelling best practices (star schema, dimensional modelling). Collaborate with stakeholders to translate business requirements into technical solutions. Key Requirements Proven experience ...

grade pipelines. Expert-level SQL , including optimization and data modelling. Azure Cloud experience (ADF, Functions, Storage, Key Vault). Deep understanding of data warehousing, dimensional modelling, and scalable architectures . Proficiency in Git, CI/CD, automated testing, and modern engineering best practices. Experience with API and SFTP … Experience with Medallion/Lakehouse patterns or Databricks-style ecosystems. Experience in regulated or high-assurance data environments. Collaboration with modeling teams in engineering-modelling interfaces ...

Agentic AI. Strong experience Must have prior experience with end-to-end implementation of Cloud data technologies (i.e.Fabric, Snowflake). Expertise in data modelling, ELT and implementing complex stored Procedures. Expertise in various Snowflake technologies like Snowpark, SnowPipe, SnowPipe Stream, Dynamic Tables, Document AI, Cortex Analytics, Unistore etc. Expertise … systems, Salesforce, GIS, PI Historian to Snowflake. Deep understanding of relational as well as NoSQL data stores, methods, and approaches (star and snowflake, dimensional modelling and third normal form) Experience with data security and data access controls and design Deep understanding of SoX, GDPR and Regulatory/ ...

Engineering Proven experience creating trusted analytics outputs from curated datasets Strong understanding of KPI definition, metrics and business logic Experience working with semantic or dimensional models Exposure to governed, production-focused data environments Technical Skills: Advanced SQL KPI/metric design and governance Data modelling (dimensional/ ...

requirements Deliver insights through reports and visualisations Translate business needs into technical solutions Maintain and enhance data platforms and analytics systems Build and manage dimensional data models Conduct testing, troubleshooting and performance tuning Evaluate and improve existing BI systems Collaborate with technical teams to integrate systems Create and maintain … also required. What you'll need to succeed Essential Skills & Experience Proven experience in a data-focused role Strong background in data warehousing and dimensional modelling Understanding of database management systems, OLAP and ETL frameworks Experience with cloud data platforms (ideally Microsoft Fabric) Familiarity with Power ...

prototyping and proof-of-concept builds within Databricks to demonstrate platform capabilities and accelerate client adoption Provide best practice guidance on Lakehouse architecture, data modelling, workload optimisation, and cost management Produce high-quality technical documentation including architecture diagrams, architecture decision records (ADRs), runbooks, and deployment guides Enable client teams … e.g. Terraform preferred) and CI/CD pipelines (e.g. Azure DevOps, GitHub Actions) Solid understanding of data architecture concepts including Lakehouse medallion architecture and dimensional modelling Familiarity with security and governance frameworks (e.g. RBAC, ABAC, data masking, audit, compliance standards) Excellent communication skills with the ability to explain ...

stakeholders across finance, operations and commercial teams. Roles & Responsibilities Define the technology stack and architecture for the organisation's enterprise data warehouse Establish data modelling standards, semantic layers and reusable datasets Oversee ETL pipelines across ERP, CRM and operational systems Implement data quality, governance and DataOps best practices Lead … technical authority across the data estate Requirements Experience with modern data warehouse tooling; Snowflake, Synapse, Fabric or similar Strong SQL and dimensional modelling expertise Experience designing scalable ETL/ELT pipelines Experience working with ERP and financial data environments Experience leading distributed, offshore or third-party delivery teams ...