1 to 25 of 73 Dimensional Modelling Jobs in London

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, delivering … 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, and maintain ...

processes. This creates an excellent opportunity for a Senior Data Architect to make a lasting impact. The Role You will lead the data modelling and architecture strategy across a modern Azure Data Lakehouse environment, ensuring scalable and governed data solutions that support both current reporting and future analytical … cases. Key responsibilities include: Designing and governing enterprise-wide data models across Medallion Architecture layers. Creating curated semantic and analytical data models using dimensional modelling and Kimball methodologies. Defining data modelling standards, governance frameworks, and data feed specifications. Collaborating with Data Engineers, Analytics Engineers, and business stakeholders ...

data within a large, complex organisation that is investing heavily in its analytics and data capabilities. You will take ownership of enterprise data modelling and architecture, helping to transform how data is structured, governed, and consumed across the business. ROLES AND RESPONSIBILITIES: The Senior Data Architect will: Design … govern enterprise-wide data models across bronze, silver and gold layers within a Medallion Architecture. Create scalable curated data models using dimensional modelling, star schemas, facts and dimensions, and Kimball methodologies. Define semantic data layers, modelling standards, and governance frameworks to improve consistency, quality, and reusability. Manage ...

confident business decisions through trusted data. Whilst this is a leadership role, we expect the successful candidate to remain technically involved in architecture, data modelling and implementation. Key Responsibilities Enterprise Data Strategy Develop and own the company's enterprise data strategy, ensuring data is treated as a strategic business … warehouse supports accurate reconciliation between systems. Enterprise Data Warehouse Own the design and continual evolution of the company's enterprise data warehouse. Responsibilities include: Dimensional modelling Star schema design Fact and dimension modelling Slowly changing dimensions Master data management Metadata management Semantic layer design Data lineage Business ...

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 … Airflow/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 ...

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

Data Engineering Experience designing scalable data pipelines for machine learning workloads Experience implementing orchestration tools such as Apache Airflow or equivalent. Knowledge of data modelling, dimensional modelling and data warehousing principles. Whether you’re developing new products, building scalable platforms or unlocking insights from data ...

Skills Software analysis and design good practice -- essential Second-line and Third-line Application Support -- essential Effective problem solving - essential Critical thinking - essential Dimensional modelling, Entity Relationship modelling, Normalised modelling – desirable Data warehouse design concepts, (Inmon, Kimball) -– desirable To apply for this role please submit your ...

term service stability.As a Senior Analytics Engineer, you'll sit at the intersection of our Data Engineering, Product, and BI teams, expanding our data modelling and self-serve capabilities, and building the foundations that turn data from a support function into a strategic asset.Challenges you'll solve...You will … evolve the presentation layer of our Snowflake data warehouse, modelling complex healthcare and health tech domains end-to-end using dbt.You will design and build high-impact data models using advanced methodologies — translating real-world operational domains into scalable analytics blueprints that teams can trust.You will partner closely with ...

their extensibility models.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 differentiates ...

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

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

Strong understanding of ETL processes and data validation techniques. - Experience with Azure Data Factory, including understanding pipelines, datasets, and data flows. - Knowledge of data modelling and dimensional modelling concepts. - Solid SQL skills, including writing and analysing complex queries. - Experience using Azure DevOps for test and defect management. ...

solid foundation in systems development: must understand the system development life cycle, project management approaches, and requirements, design, and test techniques.Demonstrable experience of data modelling and design in a large complex organisation Experience and understanding of both established and emerging data technologies, including established data management and reporting technologies.Expert … knowledge of SQL databases alongside some knowledge of columnar and NoSQL databases, predictive analytics, data visualization, and unstructured dataStrong understanding of various data modelling methodologies (e.g., dimensional modelling, data vault).Demonstrate a good understanding of Data/Information Governance principles and familiarity with processes, policies ...

fluently, debug it fast and critically review it - including AI-generated code, with a sharp eye for where it goes subtly wrongProven data modelling ownership - Dimensional modelling, defining grain and shaping the structure of a data domain from the ground up for warehousing and BIDeep, hands ...

assets).Be accountable for the data architecture within the enterprise data platform, ensuring it remains coherent, scalable and aligned to enterprise standards (e.g., data modelling, metadata/lineage, security and governance).Define, embed and govern lakehouse patterns such as medallion architecture (bronze/silver/gold), including ingestion, refinement … capabilities (data quality, master/reference data, analytics and AI enablement), including transitional architectures.Define, embed and govern enterprise standards, patterns and reference architectures (data modelling, data integration, data products, semantic layers and AI data/knowledge patterns) to ensure consistency, interoperability and reuse.Engage key stakeholders (Information Security, Office ...

communication and stakeholder engagement. Key Responsibilities Design, develop and maintain scalable data pipelines using Snowflake and DBT. Build high-quality data models, including dimensional and star schema models. Engineer solutions supporting complex investment and portfolio data. Work with market data platforms and external data feeds. Develop solutions for time … performance optimisation. Skills & Experience Essential Strong commercial experience as a Data Engineer. Expert knowledge of Snowflake . Strong experience with DBT . Data modelling experience, including dimensional modelling and star schemas. Experience working with time-series data. Experience integrating and managing market data feeds or financial datasets. ...

performance tuning. Data transformation, enrichment, aggregations, and joins. SQL Advanced SQL skills. Stored procedures, CTEs, window functions, and query optimization. Data warehousing and dimensional modelling concepts. AWS Skills Expected Candidate should have experience with one or more of the following AWS services: Amazon S3 AWS Glue Amazon … Lambda AWS Step Functions Amazon Redshift Amazon Athena Amazon RDS/Aurora AWS IAM AWS KMS Amazon CloudWatch AWS Secrets Manager Data Modelling Skills Star Schema Snowflake Schema Dimensional Modeling Data Vault Data Warehouse Design Data Lake Architecture Data Formats Experience working with: Parquet Avro JSON ...

retesting, and reporting. Perform back-end data testing, analysing large datasets to identify data quality issues, inconsistencies, and root causes. Validate data models and dimensional models, ensuring data structures, relationships, and business rules are correctly implemented. Use SQL to interrogate databases, read schemas and tables, reconcile data, and verify … skills with the ability to write queries, interrogate databases, read schemas and tables, and perform data reconciliation and validation. Solid understanding of data modelling and dimensional modelling, including testing data relationships, facts, dimensions, and business rules. ISTQB Data Testing certification (or equivalent) and recent, demonstrable experience working ...

retesting, and reporting. Perform back-end data testing, analysing large datasets to identify data quality issues, inconsistencies, and root causes. Validate data models and dimensional models, ensuring data structures, relationships, and business rules are correctly implemented. Use SQL to interrogate databases, read schemas and tables, reconcile data, and verify … skills with the ability to write queries, interrogate databases, read schemas and tables, and perform data reconciliation and validation. Solid understanding of data modelling and dimensional modelling, including testing data relationships, facts, dimensions, and business rules. ISTQB Data Testing certification (or equivalent) and recent, demonstrable experience working ...

modern ELT approaches and tools such as Snowflake, ADF and dbt CloudTranslating business requirements into clear technical specifications, delivery plans and engineering tasksLeading data modelling activity, including Kimball-style fact and dimension designSupporting migration from legacy tooling towards Snowflake-centred data solutionsWorking within Scrum teams to refine, plan … documentation, quality, governance and release processesWho we’re looking for:Strong experience in data engineering, including building and operating data pipelinesGood understanding of data modelling and dimensional modelling, using Kimball principlesExperience with modern data tooling such as Snowflake, ADF, dbt Cloud or equivalent technologiesConfidence translating business needs ...

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

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

equally as important as communication and stakeholder engagement.Key ResponsibilitiesDesign, develop and maintain scalable data pipelines using Snowflake and DBT.Build high-quality data models, including dimensional and star schema models.Engineer solutions supporting complex investment and portfolio data.Work with market data platforms and external data feeds.Develop solutions for time-series datasets … development tools.Champion best practice around data quality, governance and performance optimisation.Skills & ExperienceEssentialStrong commercial experience as a Data Engineer.Expert knowledge of Snowflake.Strong experience with DBT.Data modelling experience, including dimensional modelling and star schemas.Experience working with time-series data.Experience integrating and managing market data feeds or financial datasets.Strong ...