Senior Data Architect

Senior Data Architect in Central London (W1) | Euro Car Parks My career My jobs MA My account Search These jobs were popular with other job seekers Systems Developer - Dynamics 365 (FTSE250!) Robert Half Limited City of London (EC1), EC1 Up to £45000 per annum + bonus, pension, medical care 3 weeks ago Data Architect Experis City of London (EC1), EC1 £650 - £700 per day 1 month ago Data Engineering Technical Lead Hackajob Ltd South West London (SW1) Competitive 1 month ago Power Platform Developer Morson Edge London £500 - 550 per day 2 weeks ago BI Architect - Oracle Analytics & Access Randstad Digital City of London (EC1), EC1 £500 - £505 per day 2 weeks ago Data Consultant Lynx Recruitment Limited South West London (SW1E) Up to £50,000 per annum 3 weeks ago PowerBi/PowerApps Developer Morson Edge London Market related 3 weeks ago Nexthink Platform SME Matchtech Mobility London Negotiable 3 weeks ago Data Modeller Response Informatics London £500 per day 2 weeks ago Data Integration Lead Developer Sanderson Recruitment City of London (EC1) £90000 - £98000 per annum 2 weeks ago Senior Data Architect Euro Car Parks Central London (W1) Permanent Contract; On-site Published: 5 hours ago From £75,000 to £90,000 per annum Apply Save Senior Data Architect Euro Car Parks Apply Senior Data Architect, Central London An exciting Senior Data Architect role with a salary of £75,000 to £90,000 and career progression opportunities for a permanent role based full-time in our Marylebone, London office. We are offering a fantastic opportunity for an experienced Data Architect with an immediate start at a market leading, dynamic and renowned property, technology and innovative, technology-based car parking company. Euro Car Parks is a market leading, renowned UK business, established over 50 years ago. The company operates over 3500 sites across the UK and Ireland providing specialist services to a wide range of blue-chip clients. The role We are looking for a hands-on Senior Data Architect who is equally comfortable designing the target state for a multi-system SQL data estate, writing and tuning the T-SQL that delivers it, and standing up the security, monitoring and operational practices that keep it running. You will own data architecture across our reporting, ANPR, finance and operational domains, working alongside our Solutions Architect, Head of Business Solutions and Head of Development as part of a small, high-impact architecture cluster. This is not a paper-architect role. The successful candidate will pick up an in-flight, multi-year programme to decouple and replatform the ETL processes that sit behind every report and every operational data feed at ECP, continue the migration of our data warehouse and data lake to a modern dimensional model, finish the rollout of a principle-of-least-privilege security model across a multi-server SQL estate, and continue the migration of our reporting estate from SSRS to Power BI. You will set the technical direction for the data team and personally deliver the most architecturally significant pieces of work. Main Responsibilities Duties will include: · Setting and personally delivering target architecture for the ECP data estate — 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. · Hands-on T-SQL, stored procedure, ETL framework and PowerShell development at expert level — partition design and partition-aligned indexing, clustered/nonclustered index strategy, deduplication, parallel-run cutovers, schema migration, performance tuning of high-impact production queries. · Driving the in-flight ETL replatform — replacing legacy SSIS jobs with a table-driven, parallel-run E-L-T framework, removing Linked Server dependencies, eliminating the BI-server database-restore dependency, and adding monthly partitioning to support retention and archival. · Owning the SQL estate end-to-end as the senior practitioner — security model design and rollout (EntraID groups for Azure SQL, Active Directory groups for SQL on VM, role-based access controls, elimination of shared/admin accounts), backup and restore strategy, retention and archival, replication, monitoring (Redgate Monitor and equivalents), licensing, performance triage, and incident response. · Acting as design authority for the wider data team — coaching the SQL Developers on Power BI authorship, dimensional modelling, query optimisation and report development; reviewing data-related changes from across IT Dev; and providing data-architecture input on cross-team initiatives (mobile, finance, AI, Amdaris partnership). · Owning the Power BI / SSRS reporting platform technically — driving the SSRS-to-Power BI migration, designing the dataset and refresh strategy, and stewarding the report glossary, naming convention and underlying SQL views. · Owning the canonical data dictionary and data domain definitions — keeping types, domains, lineage and load schedules current as the source of truth for engineering decisions across IT Dev. · Triaging and resolving the data-related ticket tail from the application support service desk — ETL job failures, ad-hoc data corrections for blue-chip clients (e.g. visit deduplication, cross-system reconciliations), permissions requests, performance investigations, replication failures. · Active participation in all team ceremonies — daily stand-up, sprint planning, retros, sprint reviews, story-mapping, and architecture review — helping the entire delivery team be the best that they can be. · Contributing to forward planning for the SQL estate direction — Azure SQL adoption, on-prem retirement, tooling roadmap (e.g. dbt, Redgate), and integration with new business systems (e.g. Workday integration currently in flight). Essential Skills: · 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 — SSIS for understanding/decommissioning legacy work, plus modern alternatives (custom T-SQL frameworks, ADF, dbt, or equivalent) for new build. · 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. · Azure SQL (database, managed instance, or both) including security model (EntraID groups), PaaS limitations, and migration patterns from on-prem. · Power BI / SSRS authorship and architecture — dataset design, semantic model authoring, refresh and gateway strategy, DAX, M, and report-developer-coaching experience. · Data security model design — role-based access controls, principle of least privilege, AD/EntraID group design, schema-level permissions, and elimination of shared/admin account patterns. · PowerShell for SQL administration, ETL orchestration glue, and operational scripting. · Working in an agile environment using JIRA and Confluence — including using Confluence as the canonical home for data dictionary, schema documentation and lineage. · Affinity with AI-driven development tooling for SQL development, code generation, code review and operational automation. We expect the successful candidate to have a view on which tools add value where, and to bring that view to the role. Desirable Skills: · Experience with dbt or comparable analytics-engineering frameworks. · Experience working with legacy SSRS estates and migrating reporting workloads to Power BI. · Experience with on-prem SQL Server on VM as well as Azure SQL — multi-environment estates with different operational characteristics. · Experience with SQL replication (transactional and merge), and the operational realities of running it in production. · CDC and change tracking experience for incremental load patterns. · Experience working in a data-centric organisation with significant volumes of operational data and a heavy reporting consumption pattern. · Domain experience in vehicle/ANPR/parking, transport, retail or financial-services data — high-volume transactional data with complex temporal characteristics. · Azure DevOps experience — YAML pipelines, infrastructure-as-code awareness (Terraform). · Familiarity with ISO 27001 controls relevant to data systems. · Experience designing or maintaining operational data dictionaries and data lineage documentation in Confluence or comparable wikis. Interested? If you feel you have the skills and qualities to undertake this role, please click apply. We are an equal opportunities employer. Apply Euro Car Parks IT & Tech Similar Senior Data Architect Jobs Popular with Other Job Seekers Systems Developer - Dynamics 365 (FTSE250!) Robert Half Limited City of London (EC1), EC1 Up to £45000 per annum + bonus, pension, medical care 3 weeks ago Data Architect Experis City of London (EC1), EC1 £650 - £700 per day 1 month ago Data Engineering Technical Lead Hackajob Ltd South West London (SW1) Competitive 1 month ago Power Platform Developer Morson Edge London £500 - 550 per day 2 weeks ago BI Architect - Oracle Analytics & Access Randstad Digital City of London (EC1), EC1 £500 - £505 per day 2 weeks ago Data Consultant Lynx Recruitment Limited South West London (SW1E) Up to £50,000 per annum 3 weeks ago PowerBi/PowerApps Developer Morson Edge London Market related 3 weeks ago Nexthink Platform SME Matchtech Mobility London Negotiable 3 weeks ago Data Modeller Response Informatics London £500 per day 2 weeks ago Data Integration Lead Developer Sanderson Recruitment City of London (EC1) £90000 - £98000 per annum 2 weeks ago Senior Data Architect jobs Senior Data Architect jobs in Central London IT jobs IT jobs in Central London Architecture jobs Architecture jobs in Central London Jobs in Central London Senior Data Analyst jobs Data Officer jobs Senior Architect jobs Senior Software Engineering jobs Junior Data Architect jobs Software Architect jobs Senior Analyst jobs Information Architect jobs Junior Data Engineer jobs Chief Data Officer jobs Data Architect jobs Senior Systems Architect jobs Senior Technical Designer jobs Senior Digital Architect jobs Senior IT Engineer jobs Senior Design Engineer jobs Get hired. Find success. Totaljobs About us Careers at Totaljobs Press Partners Privacy policy Terms and conditions Cookies Legal and compliance Accessibility Jobseekers Salary Planner Jobseeker help centre Career advice Recruiters Post job ads Recruiting news Courses Contact us - recruiters Recruit internationally Download App store Play store The Stepstone Group UK Ltd © 2026 We use cookies We use cookies to operate our website, measure how people use our services to help us improve them, enrich usage profiles and personalise the content displayed to you. We also share information about your use of our site with our social media, advertising, and analytics partners, who may combine it with other information, to show you relevant ads on other websites, and to measure the performance of our advertising. Some cookies are essential for the operation of our website. If you would prefer us not to use the non-essential cookies, click “Just necessary”, but please be aware that this may impact your experience of our site and the services we are able to offer. Click “Accept” if you’re happy for us to place these cookies. You can change your mind at any time. Store and / or access information on a device Cookies, device identifiers, or other information can be stored or accessed on your device for the purposes presented to you. Personalised ads and content, ad and content measurement, audience insights and product development Ads and content can be personalised based on a profile. More data can be added to better personalise ads and content. The performance of ads and content can be measured. Insights about audiences who have viewed the ads and content can be extracted. Data can be used to build or improve user experience, systems and software. Display third-party content (social networks, videos) Content from social networks and embedded content from third-party providers can be displayed. Identifiers derived from authentications If an identifier is created based on authentication data, such as contact details associated with online accounts you have set up on websites or apps (e.g. email address, phone number) or customer identifiers (e.g. an identifier provided by your telecommunications provider), then this identifier can be used to recognize you across websites, apps and devices if you are logged in with the same contact details. Just Necessary Accept All Cookie Settings You can also exercise your right to object to data processing based on legitimate interests under “Privacy Policy”. Privacy Policy Cookie policy