Senior Data Architect

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 development with SSIS for understanding/decommissioning legacy work, plus modern alternatives (custom T-SQL frameworks, ADF, dbt, or equivalent) for new builds. Operational SQL Server experience as the senior responsible person (backups, restore, security, monitoring, performance triage, replication). ...