1 to 25 of 61 Permanent Dimensional Modelling Jobs in London

help turn a growing analytics estate into a clear, governed and scalable foundation for better decisions, better products and trustworthy AI-powered experiences. Data modelling is at the heart of this role. You’ll shape the layered warehouse model, define the grains and conformed dimensions, and design the semantic … models that other people can confidently build on. What you’ll be doing Own the analytics data architecture end to end, including layers, modelling conventions, data contracts and the governed semantic layer. Build the foundational curated layer yourself, creating dimensional models with clear grain, conformed dimensions ...

cases. Business Intelligence and broader Analytics capabilities are managed by separate teams. Key Accountabilities Data Engineering and Analytics Engineering Oversee reliable ingestion, transformation, orchestration, modelling and lifecycle management across the data platform. Implement a medallion architecture that supports trusted, reusable and well-governed data assets. Establish effective engineering practices … version control, automated testing, deployment and operational support. Lead analytics engineering practices, including dimensional modelling, semantic modelling, shared metrics and curated business-facing data products, partnering with consuming teams to ensure platform outputs are usable, dependable and aligned to agreed requirements. Lead, coach and develop a cross ...

analytics platform. This is a hands‐on, high‐impact role suited to someone who enjoys greenfield analytics work, has strong opinions on data modelling and architecture, and partners closely with stakeholders to translate business problems into trusted, well‐governed data products. You will work within the PlayStation Partners Platform … decision‐making, improve operational efficiency, and uncover revenue opportunities. In this role, you will help shape how analytics is delivered across the organisation, from modelling standards and dbt best practices to the creation of trusted, decision‐ready datasets. What You Will Be DoingAnalytics Engineering and Data ModellingDesign, build ...

This is an opportunity to influence not only what we build, but how we engineer--establishing better approaches to architecture, ingestion, orchestration, transformation, data modelling, testing, deployment, monitoring, automation and reuse.Working closely with Data Engineers, Data Scientists and analysts, you will see how engineering decisions affect analytical delivery … building and operating complex data platforms, pipelines and analytical data models at scale.You will understand the complete data lifecyclefrom ingestion and orchestration through transformation, modelling, validation, deployment, monitoring and optimisationand be able to determine the appropriate engineering approach for complex analytical requirements. You will combine engineering expertise with strategic ...

cases. In this D&A architecture role, you will define shared information models, create conceptual and logical designs, establish naming and modelling standards, and create information blueprints that engineering teams can implement. Working across commerce, manufacturing and supply chain operations spanning clusters and markets, you will make data easier … products, customers, suppliers and stores, establishing authoritative sources and harmonisation patterns across systems together with master data responsible teams. Establish information quality measures, modelling standards and metadata expectations embedded in architectural patterns: operational schemas in bronze, conformed and dimensional entities in silver, and consumption-ready models in gold. ...

data sync between our ERP and the wider estate. Our stack is Python, PySpark, Delta Lake and Databricks, with T‐SQL, Kimball dimensional modelling and Power BI on top, working closely with Microsoft Dynamics 365 Finance and Operations data structures. We are currently reviewing whether to move from … reconciliations and platform work, and pick up the hardest builds yourself. Owning the Data Warehouse and Data Sync Own our data warehouse, including the dimensional model, the pipelines that load it and the standards that keep it consistent as it grows. Own the data sync between ...

need to arrive doing all three confidently - you need to be strong in analysis and reporting today, and genuinely keen to develop into the modelling and engineering side with support from the team. You will be part of the bridge between our small data team and the rest … will report to the BI Lead and work closely with our Data Engineer, who you'll pair with regularly as you build up the modelling and engineering side of the role. The team is small and deliberately focused - we aim to do fewer things better, rather than spread thin ...

Storage, Pub/Sub, Datastream and Cloud Composer/Airflow, alongside Terraform and infrastructure-as-code. Set and champion high engineering standards across data modelling, dbt (data build tool) transformations, testing, monitoring, documentation, deployment, version control and cost optimisation. Partner with teams across the firm to turn business needs …/Cloud Composer, dbt, Git/GitHub, CI/CD and Terraform or other infrastructure‐as‐code tooling . A solid understanding of data modelling, dimensional modelling, orchestration, testing, data quality and operational monitoring , with a focus on building solutions that are scalable and maintainable. Experience designing ...

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 building or scaling an experimentation programme, with solid statistics: power analysis, variance reduction, sequential testing, and common pitfalls. Strong data modelling: dimensional modelling, SCDs, event schema design, dbt, and SQL at a high level. A track record of driving change: introducing new practices … getting non-technical teams to adopt them. Clear communication with executives and with non-technical stakeholders. Nice to have Data science and predictive modelling, including forecasting. Experience building an AI‐first data stack and taking an AI‐first approach to analytical problems. Data governance frameworks, marketing analytics and attribution. ...

visualizations in Qlik Strong knowledge of data visualization best practices using Qlik Experience working with a relational database (SQL, Oracle, etc.) a plus Data modelling, dimensional modelling, and working with large datasets a plus Experience working with business teams to translate functional requirements into technical requirements Additional ...

grow is by doing, so we give you the ownership to run with things and see real-time results. Owns the data modelling strategy, sets standards for data modelling, transformations, and governance. Leads the design and implementation of new features, such as the creation of a new star …/or other languages relevant to data processing Extensive experience in dbt and ideally Airflow (or other orchestration tools) Extensive experience in Entity-Relationship modelling and Dimensional modelling Experience with Cloud Data Warehousing (eg Snowflake, Databricks or BigQuery) and Cloud (AWS, GCP or Azure) Familiarity with Tableau ...

data architecture experience, including at least three years delivering Power BI at enterprise scale. Expert knowledge of Power BI, DAX, Power Query (M), semantic modelling and dimensional modelling, supported by strong SQL capability. Hands‐on experience with Power BI Service, Premium or Microsoft Fabric capacity, gateways, deployment ...

pipeline workflows, including unit testing, integration testing, and data quality validation frameworks Proven experience leading technical aspects of data projects Strong data architecture and modelling skills with the ability to design scalable data solutions Deep understanding of data warehouse design principles and methodologies Advanced knowledge of optimisation techniques … Azure data stack Knowledge of workflow orchestration tools like Azure Data Factory or Apache Airflow Experience with containerisation technologies like Docker Proficiency in dimensional modelling techniques Experience with CI/CD pipelines for data solutions Strong communication skills for translating complex technical concepts You may also have some ...

resolving data quality issues before they reach executive reporting. Support platform adoption through documentation, standards, and knowledge transfer, contributing to best practices for data modelling, naming conventions, and dataset architecture. Participate in peer reviews of data models to ensure consistency and quality before release into business-critical decks … experience building and optimising semantic or data models at scale, including window functions and complex business logic. Solid understanding of data modelling principles — star schema, dimensional modelling, DAX. Experience with Power BI and the Microsoft Power Platform, including building on top of central/curated data models. ...

larger Technology department to enable and drive the adoption of data-driven decision-making across the organisation. You will have extensive experience of data modelling at all phases from context, through conceptual models to logical and canonical models. You will be a skilled user of an advanced modelling … tool such as erwin Data Modeler, ER/Studio or Sparx Enterprise Architect. Your primary focus will be on delivering conceptual, logical, canonical and dimensional models that support trusted data products and star schemas for actionable operational, tactical and strategic insights. These models will increasingly be implemented within ...

mentoring and coaching engineers, conducting code reviews, and promoting engineering excellence. Strong experience designing and implementing data models across multiple architectural layers, including Kimball dimensional modelling and Data Vault methodologies. Experience working within Agile delivery teams and collaborating with architects, product owners, analysts, and business stakeholders to deliver … Code, automated testing, and deployment automation. Orchestration: Databricks Workflows, Azure Data Factory, Fabric pipelines, and other enterprise scheduling and orchestration frameworks. Data Architecture & Modelling: Strong knowledge of Kimball, Data Vault, medallion architecture, and modern lakehouse design patterns. Data Governance & Security: Experience implementing secure-by-design data solutions, platform governance ...

looking for: Solid experience in data architecture, with a track record of designing and delivering enterprise-scale data solutions Proficiency in data modelling techniques (e.g. dimensional modelling, data vault, medallion architecture) and strong SQL skills Experience with cloud data platforms, particularly AWS, as well as platforms such ...

This is a hands‐on technical role suited to someone with a strong command of dbt and Databricks who is passionate about data quality, modelling best practice, and enabling genuinely self‐serve, data‐driven decisions. You will contribute across the full data modelling lifecycle, from design and development … still evolving as we build them. As an Analytics Engineer, You Will: Provide subject matter expertise to help shape and guide the overall data modelling strategy across our data domains. Design and implement dbt models on Databricks to support a comprehensive and unified view of subscriptions and content data. ...

Strong experience working with GCP (or a comparable cloud platform), Infrastructure as Code, and CI/CD practices. Deep understanding of data storage and modelling principles, including dimensional modelling, lakehouse patterns, and the governance and operational setup of tools like dbt, and applies data security and GDPR ...

Strong experience working with GCP (or a comparable cloud platform), Infrastructure as Code, and CI/CD practices. Deep understanding of data storage and modelling principles, including dimensional modelling,lakehousepatterns, and the governance and operational setup of tools likedbt, and applies data security and GDPR principles ...

Data & Analysis standards Ensure compliance with company data governance, risk and security policies Support the BI Manager and BI Analysts with data engineering, architecture, modelling and best practices Help upskill the BI team and promote consistent data and BI practices across the organisation ESSENTIAL SKILLS AND EXPERIENCE Strong experience … data engineering, including ETL/ELT, data pipelines and modern cloud data platforms Strong understanding of data warehousing, dimensional modelling, Kimball principles and data architecture Advanced SQL/T-SQL skills, including query development, optimisation and troubleshooting Strong Python, PySpark or similar programming skills for data manipulation ...

with Azure Databricks and Azure SQL/SQL Server to process and manage large datasets. Design and implement data models using Kimball, 3NF and dimensional modelling approaches. Develop metadata-driven pipelines to improve automation and efficiency. Work closely with technical teams and clients to understand data requirements ...

with Azure Databricks and Azure SQL/SQL Server to process and manage large datasets. Design and implement data models using Kimball, 3NF and dimensional modelling approaches. Develop metadata-driven pipelines to improve automation and efficiency. Work closely with technical teams and clients to understand data requirements ...

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