At a Glance
- Tasks: Join a team to uplift and redevelop a Data Warehouse for a major integration project.
- Company: A leading Financial Services organization in Central London with a hybrid work model.
- Benefits: Enjoy a competitive salary, 25 days leave, private medical insurance, and more perks.
- Why this job: Be part of a transformative initiative and collaborate with diverse stakeholders in a dynamic environment.
- Qualifications: Strong T-SQL and SSIS skills required; experience in Data Warehouse development is essential.
- Other info: UK residents only; no sponsorship available.
The predicted salary is between 46200 - 58800 £ per year.
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, rebuild 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 various 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 with Data Warehouse development Experience in scripting with PowerShell, C# and Python 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 environment Benefits: 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 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 Fabric and Power BI User Group. To find out more and speak confidentially about your job search or hiring needs, please contact me directly at v.simpson@tenthrevolution.com
Data Warehouse Engineer employer: Tenth Revolution Group
Contact Detail:
Tenth Revolution Group Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Warehouse Engineer
✨Tip Number 1
Familiarize yourself with the specific technologies mentioned in the job description, especially SSIS and T-SQL. Consider working on personal projects or contributing to open-source projects that utilize these tools to showcase your skills.
✨Tip Number 2
Network with professionals in the Financial Services sector. Attend industry meetups or webinars to connect with potential colleagues and learn more about the challenges they face in data warehousing.
✨Tip Number 3
Prepare to discuss your experience with ETL processes in detail during interviews. Be ready to share specific examples of how you've optimized data ingestion and integration in previous roles.
✨Tip Number 4
Highlight your collaboration skills. Since this role involves working closely with various stakeholders, be prepared to discuss how you've successfully worked in team-oriented environments and managed diverse communication styles.
We think you need these skills to ace Data Warehouse Engineer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your extensive T-SQL and SSIS skills, as well as your experience with Data Warehouse development. Use specific examples to demonstrate your ability to uplift and optimise ETL processes.
Craft a Strong Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Mention your relevant experience in Financial Services, if applicable, and how you can contribute to the large-scale Data Warehouse integration project.
Showcase Your Technical Skills: Clearly outline your technical skills in scripting with PowerShell, C#, and Python. If you have experience with WhereScape Red, be sure to include that as well, as it could set you apart from other candidates.
Highlight Collaboration Experience: Since the role involves working closely with diverse stakeholders, emphasize your excellent communication and interpersonal skills. Provide examples of past collaborations that showcase your ability to work effectively in a team-oriented environment.
How to prepare for a job interview at Tenth Revolution Group
✨Showcase Your SSIS Expertise
Since the role heavily relies on SSIS for ETL processes, be prepared to discuss your experience in detail. Share specific examples of how you've rebuilt or optimized ETL processes in previous projects.
✨Demonstrate T-SQL Proficiency
Highlight your extensive T-SQL skills by discussing complex scripts you've written or stored procedures you've developed. Be ready to explain your thought process and the impact of your work on data management.
✨Emphasize Collaboration Skills
This position requires working closely with various stakeholders. Prepare to share examples of how you've successfully collaborated with teams or subject matter experts in past roles, showcasing your communication and interpersonal skills.
✨Familiarize Yourself with Financial Services
While experience in Financial Services is not essential, having some knowledge can set you apart. Research the industry and be ready to discuss how data warehousing can impact financial organizations.