Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the design and implementation of a cutting-edge data architecture for a dynamic tech company.
- Company: Join Euro Car Parks, a market leader in innovative car parking solutions with over 50 years of experience.
- Benefits: Enjoy a competitive salary, career progression, and a vibrant work environment in Central London.
- Other info: Be part of a collaborative culture with opportunities for professional growth and development.
- Why this job: Make a real impact by transforming data processes and driving innovation in a high-impact team.
- Qualifications: Expert-level T-SQL skills and hands-on experience in data architecture and ETL processes required.
The predicted salary is between 75000 - 90000 £ per year.
An exciting opportunity for an experienced Data Architect 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 looking for a hands-on Senior Data Architect who is comfortable designing the target state for a multi-system SQL data estate, writing and tuning the T-SQL that delivers it, and implementing 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, 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 including 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 including 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 including 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 including ETL job failures, ad-hoc data corrections for clients, permissions requests, performance investigations, and replication failures.
- Active participation in all team ceremonies including daily stand-up, sprint planning, retros, sprint reviews, story-mapping, and architecture review.
- Contributing to forward planning for the SQL estate direction including 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 including Kimball-style dimensional modelling.
- Production ETL development experience.
- Operational SQL Server experience as the senior responsible person.
- Multi-instance estate experience is essential.
- Azure SQL experience including security model and migration patterns.
- Power BI / SSRS authorship and architecture experience.
- Data security model design experience.
Senior Data Architect in Islington employer: Euro Car Parks
Contact Detail:
Euro Car Parks Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Data Architect in Islington
✨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 some projects that highlight your T-SQL expertise or data architecture prowess, make sure to share them during interviews. It’s a great way to demonstrate what you can bring to the table.
✨Tip Number 3
Prepare for those tricky interview questions! Brush up on your knowledge of ETL processes, data security models, and Power BI. We want to see how you think on your feet, so practice explaining your thought process clearly.
✨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 our team at Euro Car Parks.
We think you need these skills to ace Senior Data Architect in Islington
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 warehousing, and any relevant projects that showcase your hands-on skills. We want to see how your background aligns 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 expertise can contribute to our team. Be sure to mention specific experiences that relate to the responsibilities outlined in the job description.
Showcase Your Technical Skills: Since this role is all about technical prowess, don’t shy away from detailing your experience with SQL Server internals, ETL processes, and Power BI. We love seeing concrete examples of how you've tackled challenges in your previous roles!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows you’re keen on joining our team at Euro Car Parks!
How to prepare for a job interview at Euro Car Parks
✨Know Your Data Inside Out
Make sure you brush up on your T-SQL and SQL Server internals. Be ready to discuss your experience with partitioning, indexing strategies, and query plan analysis. The interviewers will want to see that you can not only talk the talk but also walk the walk when it comes to hands-on data architecture.
✨Showcase Your Problem-Solving Skills
Prepare to share specific examples of how you've tackled complex ETL processes or data migration projects in the past. Highlight your experience with modern frameworks like ADF or dbt, and be ready to discuss how you’ve improved performance or resolved issues in production environments.
✨Demonstrate Your Leadership Abilities
As a Senior Data Architect, you'll be expected to lead and coach others. Think of instances where you've guided teams or influenced architectural decisions. Be prepared to explain how you approach mentoring SQL developers and driving best practices in data modelling and report development.
✨Understand the Company’s Vision
Research Euro Car Parks and their innovative approach to technology in car parking. Familiarise yourself with their current projects and challenges. Showing that you understand their business model and how your skills can contribute to their goals will set you apart from other candidates.