Senior Data Architect

- 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 (database, managed instance, or both) and knowledge of security model (EntraID groups), PaaS limitations, and migration patterns from on-prem. - Experience with Power BI / SSRS authorship and architecture including dataset design, semantic model authoring, refresh and gateway strategy, DAX, M, and report-developer-coaching experience. - Skills in data security model design including role-based access controls, principle of least privilege, AD/EntraID group design, schema-level permissions, and elimination of shared/admin account patterns. - Proficiency in PowerShell for SQL administration, ETL orchestration, and operational scripting. - Familiarity with agile environments using JIRA and Confluence, including schema documentation and lineage management.