2 of 2 Dimensional Modelling Jobs in the City of Westminster

Python Experience developing and optimizing batch and real-time data processing solutions Strong understanding of modern data architecture patterns, including Kimball, Data Vault, dimensional modelling, and data product design principles Experience implementing Infrastructure as Code using tools such as Terraform or CloudFormation Experience leading technical delivery teams ...

streams and semi-structured sources. Implement change data capture and incremental load, including ordering, deletes, replay and slowly changing dimensions. Build medallion datasets and dimensional models, and deliver them to Snowflake, Microsoft SQL Server and Databricks. Apply data contracts, reconciliation and row-level quarantine before publication. Own the GitHub … client-facing teams into operable pipelines. Requirements 10+ years in data engineering on production systems. Snowflake or Databricks as a primary platform, including modelling, performance tuning and cost management. Python and SQL for pipeline development and testing. Change data capture and event processing, including ordering, replay and schema change. ...