3 of 3 Snowflake Schema Jobs in London

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