At a Glance
- Tasks: Design and maintain enterprise data architecture, focusing on data warehouse and ETL frameworks.
- Company: Join a dynamic team in a supportive environment based in Marylebone, London.
- Benefits: Competitive salary, career progression, and a collaborative team culture.
- Other info: Engage in agile practices and work with cutting-edge technologies.
- Why this job: Make a significant impact on data architecture and drive innovation in data management.
- Qualifications: 5+ years of T-SQL experience and expertise in data warehousing and ETL development.
The predicted salary is between 75000 - 90000 £ per year.
Description
The senior data engineer will design, implement, and maintain the enterprise data architecture for ECP, encompassing data warehouse, data hub, data lake, raw/ODS layers, dimensional models, audit and schema‑change tracking, and the load schedules that bind them together.
Responsibilities
- Specify and deliver the 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.
- Perform hands‑on T‑SQL, stored procedure, ETL framework, and Power Shell 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.
- Triage and resolve 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.
Qualifications & Experience
- 5+ years of expert‑level T‑SQL and SQL Server internals experience, including partitioning, indexing strategy, query plan analysis, dynamic SQL, and stored procedure design at scale.
- Experience with Redgate tooling such as Monitor, SQL Prompt, and SQL Source Control.
- Hands‑on data warehouse design and build using Kimball‑style dimensional modelling (fact/dim schemas), incremental and full‑load patterns, slowly changing dimensions, and ETL/ELT framework design.
- Production‑level ETL development with SSIS for legacy job decommissioning, and modern alternatives (custom T‑SQL frameworks, ADF, dbt, or equivalent) for new builds.
- Operational SQL Server experience as the senior responsible person, covering backups, restores, security, monitoring, performance triage, replication, and multi‑instance estate management.
- Proficiency in Azure SQL (database, managed instance, or both) with knowledge of security models (Entra ID groups), Paa S 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.
- Strong skills in data security model design: role‑based access controls, principle of least privilege, AD/Entra ID group design, schema‑level permissions, and elimination of shared/admin account patterns.
- Proficiency in Power Shell for SQL administration, ETL orchestration, and operational scripting.
- Familiarity with agile environments using JIRA and Confluence, including schema documentation and lineage management.
- Key Technologies & Tools
- Azure, Azure SQL, and Paa S
- Confluence and JIRA
- Data Warehouse, Data Lake, and ODS layers
- DAX, M, and Power BI
- ETL Frameworks: ADF, dbt Cloud, custom T‑SQL frameworks
- Power Shell, Redgate Monitor, SQL Prompt, SQL Source Control
- SQL Server (on‑prem and managed instance), SSIS
- AI and Machine Learning capabilities
- Active Directory, Entra ID, and security tooling
- Dev Ops practices and Terraform for infrastructure as code
- Mobile integration and architect‑level design patterns
Compensation & Benefits
Competitive salary of £75,000 to £90,000, with opportunities for career progression and a supportive team environment based in our Marylebone, London office.
#J-18808-Ljbffr
Senior Data Architect in London employer: Euro Car Parks Ltd
As a Senior Data Architect at our Marylebone, London office, you will thrive in a dynamic and supportive work culture that prioritises employee growth and development. We offer competitive salaries alongside opportunities for career progression, ensuring that you can advance your skills while contributing to innovative data solutions. Join us to be part of a collaborative team that values your expertise and fosters a meaningful impact in the data landscape.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Data Architect in London
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Euro Car Parks Ltd!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Senior Data Architect at Euro Car Parks Ltd.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Euro Car Parks Ltd.
✨Apply Directly through Our Website
When you find a suitable opening like Senior Data Architect at Euro Car Parks Ltd, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Senior Data Architect in London
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Euro Car Parks Ltd, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Euro Car Parks Ltd. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Euro Car Parks Ltd
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Euro Car Parks Ltd!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
