5 of 5 Snowflake Schema Jobs in London

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

pipeline development. Cloud Platforms : Hands-on experience working with Azure. AWS experience is considered, however Azure exposure is essential. Data Warehousing: Proven expertise with Snowflake – schema design, performance tuning, data ingestion, and security. Workflow Orchestration: Production experience with Apache Airflow (Prefect, Dagster or similar), including authoring DAGs, scheduling … including writing modular SQL transformations, building data models, and maintaining dbt projects. SQL Databases: Extensive experience with PostgreSQL, MySQL (or similar), including schema design, optimization, and complex query development. Infrastructure as Code: Production experience with declarative infrastructure definition – e.g. Terraform, Pulumi or similar. Version Control and CI/ ...

deliver impactful solutions. Specifically, you can expect to be involved in the following: Designing and implementing both relational (3NF) and dimensional (star/snowflake) data models for large-scale financial systems and analytical platforms. Working hands-on with ETL design, metadata management, and data cataloguing , ensuring robust data lineage ...

Role – Data Modelling Lead Technology – Snowflake, SQL Server, PostgreSQL, Data Warehousing, Data Lake, Medallion, Data Vault, Data Fabric, Semantic modelling Location – London, UK Job Description We are seeking an experienced Data Modeler who can analyze and understand the existing customer data and analytics models on SQL Server, and design … high-performance analytics and reporting solutions. You will analyse existing data models built on SQL Server and guide the development of optimized structures on Snowflake, ensuring alignment with business requirements and enterprise standards. You will collaborate with Business Analysts and cross-functional teams to translate complex reporting and analytics ...

documentation including data dictionaries, ERDs, and semantic definitions to support self service analytics Modernisation and migration Contribute to the migration of legacy warehouses into Snowflake based models Refactor legacy logic into dbt driven transformations Work on medium term projects typically spanning 6 to 9 months to align legacy stacks … with modern standards What they are looking for Technical experience Strong SQL experience with Redshift or BigQuery and exposure to Snowflake or another modern warehouse Proven experience building production dbt models, tests, and environments Solid understanding of dimensional modelling and Kimball principles Experience working with semantic or metric layers ...