At a Glance
- Tasks: Join a team to uplift and redevelop a Data Warehouse for a major integration project.
- Company: A well-established Financial Services organization in Central London with a hybrid working model.
- Benefits: Enjoy a competitive salary, 25 days annual leave, private medical insurance, and more perks.
- Why this job: Be part of a transformative initiative in a collaborative environment with diverse stakeholders.
- Qualifications: Strong T-SQL and SSIS skills required; experience in PowerShell, C#, and Python is a plus.
- Other info: UK residents only; no sponsorship available.
An exciting opportunity has arisen for an experienced Data Engineer / Data Warehouse Developer to join a well-established Financial Services organisation in their Central London office – they operate a hybrid working model, and you will spend 2-3 days per week in their modern office to collaborate with your team. Following a recent company acquisition, they have kicked-off a large integration programme of work, including a large-scale Data Warehouse integration project. This will be a core focus of your role, and will involve uplifting and redeveloping their existing Data Warehouse to serve the needs of both entities. The role requires extensive experience with SSIS to uplift, re-build and optimise ETL processes, ensuring seamless data ingestion, analysis and integration from various source systems, into their unified Data Warehouse. You'll ensure the stability and scalability of the Data Warehouse, ensuring it can handle increasing data volumes and user demands. In doing so, you'll collaborate closely with the wider data and development team, subject matter experts and business stakeholders. This role would be well-suited to a Developer with strong T-SQL and SSIS skills, who is keen to play a key role in a large-scale and transformative Data Warehousing initiative. Requirements: Extensive T-SQL programming skills – writing complex scripts, developing and optimising stored procedures etc. Extensive SSIS skills – to rebuild and optimise ETL processes Experience in scripting with PowerShell, C# and Python Experience with Data Warehouse development Experience in Financial Services would be beneficial but not essential Experience with WhereScape Red would be beneficial but not essential Excellent communication and interpersonal skills, with the ability to collaborate effectively with diverse stakeholders and work in a team-oriented environmentBenefits: Salary from £55-70,000 depending on level of experience 25 days annual leave, increasing with tenure, with option to buy & sell days Contributory pension scheme Private medical insurance Life assurance Other optional add-ons Please Note: This is role for UK residents only. This role does not offer Sponsorship. You must have the right to work in the UK with no restrictions. Some of our roles may be subject to successful background checks including a DBS and Credit Check. Tenth Revolution Group (and Nigel Frank) are the go-to recruiter for Power BI and Azure Data Platform roles in the UK, offering more opportunities across the country than any other. We're the proud sponsor and supporter of SQLBits, and the London Power BI User Group. To find out more and speak confidentially about your job search or hiring needs, please contact me directly at
Data Warehouse Developer employer: Tenth Revolution Group
Contact Detail:
Tenth Revolution Group Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Warehouse Developer
✨Tip Number 1
Make sure to highlight your extensive experience with SSIS in your conversations. This is a core requirement for the role, and demonstrating your expertise can set you apart from other candidates.
✨Tip Number 2
Familiarize yourself with the company's recent acquisition and how it impacts their data strategy. Being knowledgeable about their integration program will show your genuine interest in the role and the organization.
✨Tip Number 3
Prepare to discuss your experience with T-SQL and any complex scripts you've developed. Providing specific examples of your work can demonstrate your problem-solving skills and technical proficiency.
✨Tip Number 4
Emphasize your ability to collaborate with diverse stakeholders. Strong communication skills are essential for this role, so be ready to share examples of how you've successfully worked in team-oriented environments.
We think you need these skills to ace Data Warehouse Developer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your extensive T-SQL and SSIS skills. Include specific examples of how you've rebuilt and optimized ETL processes in previous roles, especially in a Data Warehouse context.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Mention your experience with Data Warehouse development and how you can contribute to their integration programme.
Showcase Relevant Experience: If you have experience in Financial Services or with tools like WhereScape Red, be sure to mention this. Highlight any projects where you've collaborated with diverse stakeholders, as this is crucial for the role.
Proofread Your Application: Before submitting, carefully proofread your application materials. Ensure there are no typos or grammatical errors, as clear communication is key in this role.
How to prepare for a job interview at Tenth Revolution Group
✨Showcase Your SSIS Expertise
Make sure to highlight your extensive experience with SSIS during the interview. Be prepared to discuss specific projects where you rebuilt and optimized ETL processes, as this will demonstrate your ability to handle the core focus of the role.
✨Demonstrate T-SQL Proficiency
Since strong T-SQL skills are crucial for this position, come ready to discuss complex scripts you've written and stored procedures you've developed. You might even be asked to solve a problem on the spot, so brush up on your T-SQL knowledge.
✨Emphasize Collaboration Skills
This role involves working closely with diverse stakeholders. Share examples of how you've successfully collaborated with teams in the past, especially in data-related projects. Highlight your communication skills and ability to work in a team-oriented environment.
✨Prepare for Technical Questions
Expect technical questions related to Data Warehouse development and integration. Review your knowledge of PowerShell, C#, and Python, as well as any experience with WhereScape Red. Being well-prepared will show your commitment and expertise in the field.