Senior Data Architect
Summary
Designs and optimizes SQL Server data warehouses and ETL pipelines using Kimball-style modeling and Redgate tools for a parking management company.
Salary: £90,000 - 90,000 per year Requirements: Expert-level T-SQL and SQL Server internals (5 years) including partitioning, indexing strategy, query plan analysis, dynamic SQL, and stored procedure design at scale. Experience with Redgate tooling (Monitor, SQL Prompt, SQL Source Control). Hands-on data warehouse design and build Kimball-style dimensional modelling (fact/dim schemas), incremental and full-load patterns, slowly changing dimensions, ETL/ELT framework design. Production ETL devel…