Senior Data Architect

• Set and deliver the target architecture for the ECP data estate, encompassing the data warehouse, data hub, data lake, raw/ODS layers, dimensional model, audit and schema-change tracking, and the load schedules that tie them together.
• Perform hands-on T-SQL, stored procedures, ETL framework and PowerShell development at expert level, focusing on partition design and indexing strategy.
• Drive the in-flight ETL replatform, replacing legacy SSIS jobs with a modern E-L-T framework, and eliminating dependencies that hinder efficiency.
• Own the SQL estate end-to-end as the senior practitioner, managing security model design and rollout, backup and restore strategy, and performance triage.
• Act as design authority for the wider data team, coaching SQL Developers on Power BI authorship and dimensional modelling, and reviewing data-related changes.
• Own the Power BI / SSRS reporting platform, leading the SSRS-to-Power BI migration and overseeing data refresh strategies.
• Maintain the canonical data dictionary and data domain definitions, ensuring accuracy for engineering decisions across IT.
• Triaging and resolving data-related tickets from the application support service desk, including ETL job failures and ad-hoc data corrections.
• Actively participate in all team ceremonies and contribute to forward planning for the SQL estate direction.

Technologies:

• Azure
• Confluence
• Data Warehouse
• DAX
• ETL
• Support
• JIRA
• PaaS
• Power BI
• PowerShell
• Redgate
• SQL
• Security
• SSIS
• dbt
• Cloud
• AI
• Active Directory
• Architect
• DevOps
• Mobile
• Terraform

• 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.

We are Euro Car Parks, a market-leading technology-based car parking company operating over 3500 sites across the UK and Ireland. With over 50 years of experience, we pride ourselves on our dynamic work environment and commitment to innovation. We offer a competitive salary of £75,000 to £90,000, along with opportunities for career progression and working in a supportive team based in our Marylebone, London office.