1 to 25 of 49 Dimensional Modelling Jobs

Engineer - Hertfordshire, HP2 4YL Senior Data Engineer (Data Modelling) UK Remote-First (occasional travel to parks, head office and team events) Permanent | Full Time Competitive salary + bonus and benefits About the role Do you think in facts and dimensions? Are you the kind of engineer who gets … forecast and guest insight sits a data model that someone thought carefully about. That someone could be you. As a Senior Data Engineer Data Modelling) , you'll be a specialist at the heart of our data engineering community, focused squarely on the craft of dimensional modelling ...

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

Snowflake Analytics Engineer Experience Level Required in Years: 8-10 years Mandatory Required Skills Expert Snowflake knowledge and advanced dbt (Core/Cloud) experience. **Modelling Concepts:** Semantic Modelling, Dimensional Modelling (Kimball), Business/Logical/Physical Modelling. **Skills:** Software engineering mindset applied to SQL; git workflows … controls (ABAC), and query performance tuning. **Technical Requirements** **Core Platforms:** Expert Snowflake knowledge and advanced dbt (Core/Cloud) experience. **Modeling Concepts:** Semantic Modeling, Dimensional Modeling (Kimball), Business/Logical/Physical Modelling. **Skills:** Software engineering mindset applied to SQL; git workflows, and automated testing. ...

intelligence capability. This is an excellent opportunity for a highly skilled Power BI professional who enjoys working across the full BI lifecycle, from data modelling and dashboard development through to governance, optimisation, and stakeholder engagement. You'll work closely with Data Engineering teams and business leaders to deliver trusted … Responsibilities: Own and develop the organisation's Power BI reporting estate, including dashboards, reports, and semantic models Design and maintain scalable data models using dimensional modelling and star schema best practices Develop advanced DAX calculations and Power Query transformations Optimise report and dataset performance, ensuring reliability and scalability ...

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

Hands-on experience with Cloud Storage, Dataflow, Dataproc, Pub/Sub, Cloud Composer, BigQuery Transfer Service, Cloud Functions, and Cloud Run, Strong SQL, data modelling, dimensional modelling, and data warehousing expertise, Experience in migrating on-premise or Legacy data platforms to GCP, Knowledge of ETL/ ...

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

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

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

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

Overview We are seeking an experienced Data Architect/Data Modelling Consultant with a strong banking and investment management background to lead the design of target-state reporting and analytics data models within a modern cloud-based data platform. The successful candidate will work closely with business and technology … target-state data model as solutions are developed and deployed, rather than undertaking a standalone discovery or design phase. This is primarily a data modelling and consulting-focused role rather than a platform or infrastructure architecture position. Key Responsibilities Analyse existing data models and architectures and define target-state ...

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

expertise Proven experience designing and implementing data engineering solutions using Microsoft Fabric and Azure . Strong background in ETL/ELT , data warehousing concepts, dimensional modelling and modern data architecture patterns. Hands-on skills across T-SQL , Python , PySpark , and developing robust data processing solutions. Experience optimising performance ...

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

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

English communication skills and a proven ability to thrive in a fast-paced, highly collaborative environment. Desirable (Bonus) Skills: Languages: PySQL, C#, R. Reporting & Modelling: Power BI (or similar), SQL Server SSAS Tabular (DAX), Dimensional Modelling, Data Warehousing. Ecosystem & Management: Azure DevOps, SQL MI/DB, Active ...

experience with data orchestration tooling such as dbt or Dataform. Platform Specifics: Hands‐on experience with Databricks. Modeling Expertise: Practical knowledge of Kimball’s dimensional modeling. Core Values Play to win, Solve the real problem, Build trust every day, Own the outcome, Go further together Benefits Pension Scheme Discretionary ...

tools such as Apache Airflow or similar. Experience implementing CI/CD pipelines using Git, Azure DevOps, GitHub Actions, or Jenkins. Good understanding of dimensional modelling, data warehousing, and modern data architecture. Experience with data quality, lineage, metadata management, and governance. Familiarity with Agile delivery methodologies. ...

experience with data orchestration tooling such as dbt or dataform. Platform Specifics: Hands‐on experience with Databricks. Modeling Expertise: Practical knowledge of Kimball’s dimensional modeling. Here at Kaluza we have five core values that guide our business: Play to win, Solve the real problem, Build trust every ...

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

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