1 to 25 of 42 Dimensional Modelling Jobs in the UK

from SSRS into Snowflake \nAssess and rationalise existing reports (remove duplication, improve logic, simplify where possible)Redesign reporting structures to align with modern data modelling principles\n Define and Implement Best Practice \n \n Establish scalable standards for:\n \n Data modelling (e.g. dimensional modelling, layered … 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 environmentsTrack record of delivering in hands-on roles (not purely ...

scale. You will have strong experience in data architecture, ETL development, and modern data warehousing practices, including the application of Kimball methodology and dimensional modelling, alongside a proven track record of building reliable, high-performance data solutions in a business-focused environment. This is a newly created role … transformation logic in a data warehousing environment. Experience designing and maintaining ETL pipelines and data integration processes. Strong experience of Kimball data modelling techniques (e.g. star schema, dimensional modelling). Experience working within a Microsoft data stack (e.g. SQL Server, Azure Data Factory, Azure Synapse, Microsoft Fabric ...

operational systems, ERP platforms and high-volume transactional sources. Build reliable, high-performance data solutions for reporting and analytics. Design scalable data models using dimensional modelling techniques including star schema and Data Vault methodologies. Evaluate and modernise existing data architecture, identifying opportunities to improve performance, scalability and governance. … platforms using Azure, AWS, GCP or similar. Strong Python experience. Solid understanding of ETL/ELT processes and modern data warehousing principles. Experience with dimensional modelling, data governance and data architecture. Experience with Power BI and DAX. Experience integrating ERP and other operational business systems. Excellent stakeholder management ...

DATA MODELLER LONDON/HYBRID UP TO £65,000 This is an opportunity to shape data modelling and architecture capability within a modern cloud data environment. The role offers strong visibility across multiple projects, with a clear pathway into data architecture and the chance to influence standards and best … across the organisation. ROLES AND RESPONSIBILITIES: The Data Modeller will: Design and develop conceptual, logical and physical data models for enterprise data platforms Apply dimensional modelling approaches such as Kimball or Data Vault to support analytics use cases Collaborate with data engineers, analysts and governance teams to ensure ...

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

batch processing Desirable Skills Working knowledge of SAS (especially in ETL context) Experience in migrating SAS workloads to Informatica ETLs Familiarity with data modelling (dimensional modelling/star schema) Exposure to scheduling tools (e.g., Control-M, Autosys) Understanding of data governance and data quality frameworks ...

batch processing Desirable Skills Working knowledge of SAS (especially in ETL context) Experience in migrating SAS workloads to Informatica ETLs Familiarity with data modelling (dimensional modelling/star schema) Exposure to scheduling tools (e.g., Control-M, Autosys) Understanding of data governance and data quality frameworks Must have ...

foundations that analytics, BI, data science and ML all stand on. You'll work across the full data engineering lifecycle—from ingestion and modelling through to transformation, orchestration, quality, observability and platform operation. The role suits someone who pairs strong software engineering discipline with genuine interest in data modelling … production ELT/ETL pipelines that move data reliably at the volume and latency the business needs Model data in the warehouse or lakehouse—dimensional, Data Vault, One Big Table or domain-driven approaches, fit to the use case Build and maintain transformation layers in dbt (or equivalent), with ...

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

including query development and optimisation, stored procedures, and performance tuning \n 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 \n Advanced data modelling including dimensional modelling, star schema ...

consultant, in addition to developing innovative solutions for our clients, you will keep abreast of the latest developments in the data, analytics and data modelling products and offerings from other vendors, and demonstrate a wider knowledge of data platforms, non-Oracle and hybrid data ecosystems. You will provide guidance … Platform, and Oracle Fusion Cloud’s embedded reporting technologies (OTBI and BI Publisher) Programming languages such as SQL and Python Logical and physical data modelling, including dimensional modelling and Data Vault 2.0 Deploying data models and accelerated data integration pipelines into target data warehouse and hybrid data ...

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

term work supports broader programme and client objectives. About You Professional knowledge and experience Essential Proven experience in data engineering, data integration and data modelling Expertise with cloud platforms (e.g. AWS, Azure, GCP) Expertise with modern cloud data platforms (e.g. Microsoft Fabric, Databricks) Expertise with multiple data analytics tools … e.g. Power BI) Deep understanding of data warehousing concepts, ETL/ELT pipelines and dimensional modelling Proficiency in advanced programming languages (Python/PySpark, SQL) Experience in data pipeline orchestration (e.g. Airflow, Data Factory) Familiarity with DevOps and CI/CD practices (Git, Azure DevOps etc) Ability ...

batch and near-real-time data processing. Experience with data formats such as Parquet, Avro, ORC, JSON, and CSV. Good understanding of data modelling, data warehousing, and dimensional modelling concepts. Experience with data validation, reconciliation, data quality, audit, and logging frameworks. Experience with Git-based version control ...

Lead Data Business Analyst (Data Warehouse & Data Modelling) Our London based client is currently looking for a Lead Data Business Analyst to act as the bridge between business stakeholders and technical data teams to define, document, and validate requirements for their enterprise data warehouse. The Data Business Analyst will … requirements, including source‐to‐target mappings and logical, conceptual, and physical data models. Collaborate with data architects and data engineers to design and enhance dimensional data models, including fact and dimension tables using star and snowflake schemas. Produce and maintain data warehouse documentation, including entity relationship diagrams (ERDs), data ...

. Proven expertise in data integration and analytics platforms, including Azure Data Factory, Microsoft Fabric (Lakehouse/Warehouse), and strong understanding of data warehousing, dimensional modelling, and lakehouse concepts. Experience with Microsoft Azure cloud platform, including Azure Data Lake Storage/ADLS Gen2, Microsoft Fabric (OneLake, Workspaces, Capacity ...

Data Engineers, Business Analysts, and Power BI Developers to ensure data is structured, governed, and optimised for business use. Key Responsibilities Design and develop dimensional data models and datamarts Translate business requirements into logical and physical data models Optimise data structures for Power BI reporting and analytics Collaborate with … maintain metadata, data dictionaries, and documentation Support data governance, quality, and consistency initiatives Ensure data integrity through testing and validation activities Contribute to data modelling standards and best practices Essential Skills & Experience Strong experience in Data Modelling and Data Warehousing Expertise in dimensional modelling techniques Experience ...

requirements, and ensure requirements are clear, achievable and aligned to business value. Triage and prioritise new requests and analyse and prioritise backlogs. Improve data modelling, reporting catalogues and data governance practices. Lead stand-ups, retrospectives & acceptance meetings Candidates will need the following, knowledge, skills and experience: A Business Analyst … Confidence working with SQL to query, validate and understand data. Experience using Power BI for reporting, analytics or stakeholder-facing insight. Knowledge of data modelling concepts, such as dimensional modelling or semantic modelling. Exposure to agile ways of working, backlog management or product ownership responsibilities. Experience supporting ...

implementing solutions on AWS data and analytics platforms. Proven expertise in data integration and analytics platforms on AWS, with strong understanding of data warehousing, dimensional modelling, and lakehouse/data lake concepts. Experience with AWS cloud platform, including Amazon S3, AWS Lake Formation, AWS Glue, Amazon Redshift, Amazon ...

incoming data. Develop ELT/ETL processes using tools such as dbt, Power Query (M), Spark, Azure Data Factory or Fabric Data Pipelines. Design dimensional models and reusable models that capture business logic once and serve it consistently to every downstream tool. Author efficient transformations ...

models and self-service tools the business actually uses to make decisions. You'll work across the full BI lifecycle—from gathering requirements and modelling data through to building, optimising and maintaining production reporting assets. The role suits someone who pairs strong SQL and modelling discipline with … curated layers that let business users answer their own questions (For Senior/Lead) Set BI standards, mentor junior developers, lead larger reporting and modelling initiatives What You'll Bring Technical Expertise: Strong SQL proficiency against modern cloud warehouses (Snowflake, BigQuery, Redshift, Synapse, Databricks) Deep hands-on experience with ...

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

integrations using Azure Data Factory and Databricks and related services. Develop and maintain datasets and data models that support analytics and reporting, following established modelling standards Contribute to data lineage, metadata management and cataloguing practices, including exposure to Purview Work closely with the Lead Data Engineer, Analysts and Architects … production or near-production environment Practical experience building and maintaining ETL/ELT pipelines in a cloud environment Working knowledge of data modelling concepts including star schema and dimensional modelling Please see full job description attached. What you can expect from us We believe doing your best ...

such as Airflow to schedule, monitor and manage data pipelines Experience working with at least one major cloud data platform, preferably Azure Strong data modelling skills, including relational and dimensional modelling Knowledge of relational database technologies and best practices Proficiency in Python for data engineering, automation ...