13 of 13 Snowflake Schema Jobs in London

Responsibilities Define and lead the architecture and design of enterprise data platforms using Snowflake on AWS. Architect scalable data ingestion frameworks for integrating multiple source systems into the cloud data platform. Design and govern data transformation frameworks using DBT. Define and enforce data modelling standards including dimensional modelling, star … schema, and enterprise data models. Lead architecture reviews and solution design discussions for new data initiatives. Optimize Snowflake performance, workload management, and cost governance. Establish data governance frameworks including access control, data security, and compliance standards. Design and support AI/ML-ready data architecture for advanced analytics ...

processes to integrate data from multiple sources. Develop and maintain Power BI dashboards and reports that provide actionable business insights. Implement data models (star schema, snowflake schema) optimized for analytics and reporting. Ensure data quality, consistency, and governance across the data warehouse. Optimize query performance and data … semantic layers for BI reporting. Knowledge of ETL tools or frameworks (SSIS, Azure Data Factory, Informatica, etc.). Experience with data warehouse platforms (e.g., Snowflake, Azure Synapse, Amazon Redshift, SQL Server). Strong understanding of data transformation, aggregation, and performance tuning . Familiarity with DAX and Power Query ...

architecture (Data Lakes, Data Warehouses) and distributed processing concepts (e.g., MapReduce). ETL/ELT Basic knowledge of ETL principles and data modeling (star schema, snowflake schema). Version Control Practical experience with Git (branching, merging, pull requests). Preferred Qualifications (A Plus) Experience with a distributed ...

robust data systems while mentoring others and raising engineering standards. The Role You will design, build, and optimise scalable data pipelines and models across Snowflake, Databricks, and cloud environments (AWS/GCP). Working closely with Data Science, Product, and Analytics teams, youll ensure reliable, high-performance data flows … engineers and near shore partners as well as contribute to architectural direction and best practices. Key Responsibilities Design and maintain scalable data architectures across Snowflake and Databricks Lead schema design, dimensional modelling, and SQL performance optimisation Build robust ETL/ELT pipelines Develop resilient API ingestion workflows Implement ...

designing and optimising data models for: Data warehouses (Kimball/Inmon methodologies) Data marts Operational data stores (ODS) Knowledge of dimensional modelling (star/snowflake schemas) Experience working with large-scale, complex, multi-source data environments Understanding of data governance, metadata management, and data lineage principles Familiarity with regulatory ...

develop enterprise data warehouse solutions using Azure SQL Database/Azure SQL Managed Instance/Azure Synapse Analytics. Build and maintain star and snowflake schemas for analytical workloads. Develop ETL/ELT pipelines for ingesting and transforming data from multiple source systems. Implement data partitioning, indexing, and performance optimization … Expressions). Experience with Power BI semantic models or Azure Analysis Services/SQL Server Analysis Services (SSAS). Strong data modeling skills (star schema, dimensional modeling). Azure & Data Engineering Experience with: Azure Synapse Analytics Azure Data Factory or similar ETL tools Azure Storage/Data Lake Experience ...

Role A leading organisation in the aviation sector is undertaking a major HR data transformation programme, migrating from a legacy Oracle environment into Snowflake to create a unified, scalable HR data platform. The core data model has already been designed. The next phase focuses on: Building logical data layers … engineering role with significant influence over architectural decisions and delivery pace. What You'll Be Doing Core Responsibilities Designing and developing ETL pipelines within Snowflake Working at the logical data modelling layer Challenging and supporting existing data architecture Collaborating with architects, data engineers, and insight teams Ownership & Leadership Driving ...

relationships, and constraints; ensure traceability from requirements to models. Establish and enforce GDM modelling standards and naming conventions (e.g., normalization, dimensional/star/snowflake patterns, data vault where appropriate). Design dimensional models (facts, dimensions, hierarchies, slowly changing dimensions) for BI/analytics and performance at scale. Create … partitioning & clustering considerations) Expertise in data modelling approaches: 3NF, dimensional (Kimball), Data Vault, and hybrid patterns for Lakehouse designs Maintain versioned model artefacts (ERDs, schema scripts, JSON/YAML specs) and change logs; manage controlled evolution of models. Ability to translate banking domain requirements (Customer, Accounts, Payments, Credit, Risk ...

DevOps + Snowflake Data Engineer (Associate/Contract) Robert Half are looking for an interim DevOps + Snowflake Data Engineer to join as an Associate and support a global consulting firm delivering a major enterprise data transformation programme for an insurance client . The engagement sits within … building and managing an enterprise-wide data platform , improving reporting capabilities and embedding modern data governance and engineering best practices . This role blends Snowflake platform administration, DevOps engineering and data platform optimisation to ensure the reliability, security and performance of a modern cloud data estate. Assignment Details Rate ...

Were partnering with a leading organisation seeking a Snowflake specialist to help modernise and scale their data capability. This is a delivery-focused role where youll shape cloud data architecture, lead migrations, and build high-performance data pipelines that directly support business-critical decision making. The Opportunity Youll take … ownership of Snowflake environments from design through to optimisation, ensuring data is structured, accessible and engineered for performance. Working across technical and business teams, youll translate complex requirements into scalable, resilient data solutions that support analytics, reporting and operational insight. Your remit will include: Architecting and optimising Snowflake ...

partitioning & clustering considerations) Expertise in data modelling approaches: 3NF, dimensional (Kimball), Data Vault, and hybrid patterns for Lakehouse designs Maintain versioned model artefacts (ERDs, schema scripts, JSON/YAML specs) and change logs; manage controlled evolution of models. Ability to translate banking domain requirements (Customer, Accounts, Payments, Credit, Risk … relationships, and constraints; ensure traceability from requirements to models. Establish and enforce GDM modelling standards and naming conventions (e.g., normalization, dimensional/star/snowflake patterns, data vault where appropriate). Design dimensional models (facts, dimensions, hierarchies, slowly changing dimensions) for BI/analytics and performance at scale. Create ...

secure, scalable, production-grade platforms. Our current stack includes: · Python/Flask backend · Jinja2 templating · Modular vanilla JavaScript (no front-end framework) · Tailwind CSS · Snowflake and S3 for data storage · PySCIP for optimisation workflows In addition to strengthening the front-end and platform layer, this role will support … ingestion and outbound data workflows. Data Collaboration – Work closely with the Data Engineering team to ensure consistent, scalable, and well-structured data pipelines between Snowflake, S3, optimisation models, and external systems. Technical Strategy – Help define when to extend our current server-rendered approach versus introducing modern front-end frameworks ...

templates to support real-time API ingestion from MGA/TPA partner systems and monthly bordereaux submissions Develop data models using Dimensional (Star/Snowflake), Data Vault, and 3NF methodologies. Create and manage metadata and modelling artefacts using Erwin with traceability and governance. Support Medallion Architecture (Bronze, Silver, Gold …/SOX data governance and regulatory frameworks GDPR, Solvency II, and Lloyd’s reporting and oversight requirements. Modelling Techniques • Dimensional Modelling: Star and Snowflake schemas • Data Vault Modelling • Third Normal Form (3NF) relational modelling • JSON/XML schemas. Optional/Nice to Have • Experience with MDM/RDM (Master ...