Senior Data Architect
- Company
- Euro Car Parks
- Location
- London, United Kingdom
- Salary
- 90 000 £/mo
- Posted
- 2026-11-11
Skills: ELT, ETL, SQL, MS SQL
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 (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…
Full text and application on the employer's site.