At a Glance
- Tasks: Join us as a Data Engineer to develop ETL processes and optimize data performance.
- Company: Be part of a leading wealth management firm with over 60 years of expertise.
- Benefits: Enjoy a hybrid work model and a supportive, collaborative culture.
- Why this job: Work on exciting projects while maintaining a great work-life balance in a close-knit team.
- Qualifications: Must have experience in SQL, T-SQL, SSIS, and data warehousing.
- Other info: Interviews are ongoing, so apply now to secure your spot!
The predicted salary is between 42000 - 84000 £ per year.
Job Description
Data Engineer / Data Warehouse Developer – £70,000 – Hybrid – London
Company Overview:
My client, an established wealth management company, is currently hiring for a Data Engineer / Data Warehouse Developer. They are a multinational corporation who have been experts in their field for over 60 years, with the UK branch currently managing over £18 billion in assets.
Despite their size, they pride themselves on being a close-knit, collaborative business where everyone helps everyone. This business model means they always try to promote from within and push their own talents as far as they can go, as can be proven by many company success stories!
Role Overview:
Business developments and growth within my client’s company have led to a lot of new work becoming available, with a few big projects on the cards, including a large-scale integration. In this role, you’ll be uplifting and developing ETL processes to ingest source data from different systems into a unified warehouse. This will be on-prem work for security reasons, so it will include a lot of T-SQL and SSIS work. Additional responsibilities will include performance optimisation, ensuring scalability, and testing and validation of processes.
My client has no plans to move to a cloud platform.
Essential Responsibilities:
- Solid, recent experience in SQL & T-SQL programming, and SSIS for ETL
- Scripting experience in C#, PowerShell and/or Python
- Strong Data Warehousing experience, including designing, developing, and implementing Data Warehouse solutions with a focus on data integration
- Data mapping experience
Desirable Qualifications:
- Financial Services experience
Interviews ongoing; don’t miss your chance to secure a role working with cutting-edge technology while maintaining exceptional work-life balance.
Contact me at or on 0191 338 6641.
Keywords: Data Warehousing, SQL, SSIS, Python, PowerShell, ETL, SQL Server, fintech, investment, on-prem.
#J-18808-Ljbffr
Data Engineer / Warehouse Developer - £70,000 - Hybrid - London employer: ZipRecruiter
Contact Detail:
ZipRecruiter Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer / Warehouse Developer - £70,000 - Hybrid - London
✨Tip Number 1
Make sure to brush up on your SQL and T-SQL skills. Since the role heavily relies on these technologies, being able to demonstrate your proficiency during the interview will set you apart from other candidates.
✨Tip Number 2
Familiarize yourself with SSIS and ETL processes. Being able to discuss your past experiences with data integration and how you've optimized performance in similar projects will show that you're a strong fit for this position.
✨Tip Number 3
Highlight any experience you have in financial services. Since this company operates in wealth management, showcasing relevant industry knowledge can give you an edge in the selection process.
✨Tip Number 4
Prepare to discuss your experience with data mapping and designing data warehouse solutions. Being able to articulate your approach to these tasks will demonstrate your capability to handle the responsibilities of the role effectively.
We think you need these skills to ace Data Engineer / Warehouse Developer - £70,000 - Hybrid - London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with SQL, T-SQL, and SSIS. Include specific projects where you've developed ETL processes or worked on data warehousing solutions.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Mention your relevant skills in programming languages like C#, PowerShell, or Python, and how they align with the company's needs.
Showcase Relevant Experience: When detailing your work experience, focus on your achievements in data integration and performance optimization. Use metrics to demonstrate the impact of your contributions.
Proofread Your Application: Before submitting, carefully proofread your application for any errors or typos. A polished application reflects your attention to detail, which is crucial for a Data Engineer role.
How to prepare for a job interview at ZipRecruiter
✨Showcase Your Technical Skills
Be prepared to discuss your experience with SQL, T-SQL, and SSIS in detail. Highlight specific projects where you've developed ETL processes or worked on data warehousing solutions, as this will demonstrate your technical expertise.
✨Understand the Company Culture
Research the company's collaborative environment and their focus on promoting from within. Be ready to share examples of how you've contributed to team success in previous roles, as this aligns with their values.
✨Prepare for Scenario-Based Questions
Expect questions that assess your problem-solving skills, especially related to performance optimization and scalability in data warehousing. Think of scenarios where you successfully tackled challenges in these areas.
✨Express Your Interest in Financial Services
If you have any experience in financial services, make sure to mention it. Even if it's not extensive, showing an understanding of the industry can set you apart and demonstrate your enthusiasm for the role.