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).
• Multi‑instance estate experience is essential; not a single‑database background.
• Proficiency in Azure SQL...