At a Glance
- Tasks: Design and implement cutting-edge data architecture for a leading tech-driven car parking company.
- Company: Join Euro Car Parks, a renowned UK business with over 50 years of innovation.
- Benefits: Competitive salary, career progression, and a dynamic work environment in Central London.
- Other info: Be part of a collaborative team with excellent growth opportunities in a fast-paced industry.
- Why this job: Make a real impact on data architecture while working with advanced technologies.
- Qualifications: Expert-level T-SQL and SQL Server experience required; hands-on data architecture skills essential.
An exciting 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.
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
- 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, backup and restore strategy, retention and archival, replication, monitoring, 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.
- 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, 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.
- Contributing to forward planning for the SQL estate direction: Azure SQL adoption, on-prem retirement, tooling roadmap, and integration with new business systems.
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.
- Hands-on data warehouse design and build: Kimball-style dimensional modelling, incremental and full-load patterns, slowly changing dimensions, ETL/ELT framework design.
- Production ETL development: SSIS for understanding/decommissioning legacy work, plus modern alternatives for new build.
- Operational SQL Server experience as the senior responsible person.
- Multi-instance estate experience is essential.
- Azure SQL including security model and migration patterns from on-prem.
- Power BI / SSRS authorship and architecture experience.
- Data security model design.
- PowerShell for SQL administration, ETL orchestration glue, and operational scripting.
- Working in an agile environment using JIRA and Confluence.
- Affinity with AI-driven development tooling.
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.
- Experience with SQL replication 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.
- Domain experience in vehicle/ANPR/parking, transport, retail or financial-services data.
- Azure DevOps experience.
- Familiarity with ISO 27001 controls relevant to data systems.
- Experience designing or maintaining operational data dictionaries and data lineage documentation.
If you feel you have the skills and qualities to undertake this role, please click apply. We are an equal opportunities employer.
Senior Data Architect in London employer: Euro Car Parks
Euro Car Parks is an exceptional employer, offering a vibrant work culture in the heart of Central London, where innovation meets opportunity. With over 50 years of industry leadership, we provide our employees with robust career progression paths, hands-on experience in cutting-edge technology, and a collaborative environment that fosters personal and professional growth. Join us to be part of a dynamic team that values your contributions and supports your development in a market-leading company.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Data Architect in London
✨Tip Number 1
Network like a pro! Get out there and connect with people in the industry. Attend meetups, webinars, or even just grab a coffee with someone who works at Euro Car Parks. You never know who might have the inside scoop on job openings!
✨Tip Number 2
Show off your skills! If you’ve got a portfolio or examples of your work, bring them along to interviews. For a Senior Data Architect role, showcasing your T-SQL expertise or data architecture projects can really set you apart from the crowd.
✨Tip Number 3
Prepare for those tricky questions! Brush up on your knowledge of SQL Server internals and ETL processes. Be ready to discuss how you’d tackle challenges like migrating reporting workloads to Power BI or designing a robust security model.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining the team at Euro Car Parks.
We think you need these skills to ace Senior Data Architect in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Senior Data Architect role. Highlight your experience with T-SQL, data architecture, and any relevant projects you've worked on. We want to see how your skills align with what we're looking for!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about this role and how your background makes you the perfect fit. Don't forget to mention your hands-on experience with ETL processes and Power BI.
Showcase Your Technical Skills:In your application, be sure to showcase your technical skills, especially in SQL Server internals and data warehouse design. We love seeing specific examples of how you've tackled challenges in previous roles, so don't hold back!
Apply Through Our Website:We encourage you to apply through our website for the best chance of getting noticed. It helps us keep track of applications and ensures you’re considered for the role. Plus, it’s super easy to do!
How to prepare for a job interview at Euro Car Parks
✨Know Your Data Inside Out
As a Senior Data Architect, you’ll need to demonstrate your expertise in T-SQL and SQL Server internals. Brush up on your knowledge of partitioning, indexing strategies, and query plan analysis. Be ready to discuss specific projects where you've applied these skills, as this will show your hands-on experience.
✨Showcase Your Architectural Vision
Prepare to articulate your vision for data architecture. Think about how you would approach the migration of the data warehouse and the ETL replatforming. Bring examples of how you've successfully designed and implemented similar architectures in the past, focusing on the impact it had on the organisation.
✨Demonstrate Your Problem-Solving Skills
Expect to face scenario-based questions that test your problem-solving abilities. Prepare examples of how you've triaged and resolved data-related issues in previous roles. Highlight your experience with performance tuning and incident response, as these are crucial for the role.
✨Engage with the Team Dynamics
Since collaboration is key in this role, be prepared to discuss how you’ve worked within agile teams. Share your experiences from daily stand-ups, sprint planning, and retrospectives. This will show that you’re not just a technical expert but also a team player who can contribute to a positive team culture.
