Job Radar › All jobs

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.

Apply