Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join us as an ETL Developer to create data processing solutions and automate data ingestion.
- Company: Be part of a leading bank in the heart of London, driving innovation in data management.
- Benefits: Enjoy flexible working options and a dynamic work environment with great corporate perks.
- Why this job: Make a real impact by enhancing operational resilience and preventing system outages.
- Qualifications: Experience in ETL, SQL Server, and data analysis is essential; familiarity with Python and Excel VBA is a plus.
- Other info: Ideal for tech-savvy individuals eager to tackle complex data challenges in finance.
The predicted salary is between 36000 - 60000 £ per year.
A Bank, based in the City of London, is currently seeking an ETL Developer to help deliver infrastructure data processing solutions for the business. The company is seeking an experienced ETL Application Developer with experience of Extract/Transform/Load, SQL Server and data-processing of infrastructure-sourced capacity metrics.
This role is critical to strengthening operational resilience by ensuring that the correct level of capacity monitoring is in place to highlight and mitigate potential system outages in a timely fashion to minimise potential disruptions.
Developing scripts, and ETL to obtain such data from the providers and working with a DBA to load this data into SQL Server from an application server. This person will also help normalise raw infrastructure and monitoring data into structured formats suitable for graphing and trending. Other tasks include automating regular data ingestion processing.
Demonstrate evidence of working on similar data analysis and capture projects in the financial or other sector of equal complexity.
- Strong proficiency in data extraction methods using RESTful APIs
- Experience of extracting and transforming data from infrastructure management tools such as Nutanix Prism Central, VMware vCenter, Dell EMC Storage platforms (Unisphere), and OpManager desirable
- Experience with data storage platforms, Microsoft SQL Server in particular
- Knowledge and general understanding of Python (for trending), SQL Server scripts (T-SQL), Excel VBA (2019 minimum)
Developer - Excel / VBA employer: Sterlings
Contact Detail:
Sterlings Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Developer - Excel / VBA
✨Tip Number 1
Familiarise yourself with the specific tools mentioned in the job description, such as Nutanix Prism Central and VMware vCenter. Having hands-on experience or even completing relevant online courses can give you a significant edge during interviews.
✨Tip Number 2
Network with professionals in the banking and finance sector who work with ETL processes. Attend industry meetups or webinars to gain insights and potentially get referrals that could help you land the job.
✨Tip Number 3
Prepare to discuss your previous projects involving data extraction and transformation. Be ready to explain your role, the challenges you faced, and how you overcame them, especially in relation to operational resilience.
✨Tip Number 4
Brush up on your Excel VBA skills, as this is a key requirement for the role. Consider creating a small project or tool that showcases your ability to automate tasks using VBA, which you can then discuss during your interview.
We think you need these skills to ace Developer - Excel / VBA
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with ETL processes, SQL Server, and any relevant data extraction methods. Use specific examples from your past roles that demonstrate your ability to handle similar projects.
Craft a Strong Cover Letter: In your cover letter, explain why you are interested in the Developer position and how your skills align with the company's needs. Mention your experience with RESTful APIs and any familiarity with infrastructure management tools like Nutanix or VMware.
Showcase Relevant Projects: If you have worked on data analysis or capture projects, be sure to include these in your application. Detail your role, the technologies used, and the outcomes achieved to demonstrate your capability in this area.
Proofread Your Application: Before submitting, carefully proofread your CV and cover letter for any spelling or grammatical errors. A polished application reflects your attention to detail, which is crucial for a Developer role.
How to prepare for a job interview at Sterlings
✨Showcase Your ETL Experience
Be prepared to discuss your previous experience with Extract/Transform/Load processes. Highlight specific projects where you successfully implemented ETL solutions, especially in a financial context, as this will demonstrate your capability to handle the complexities of the role.
✨Demonstrate SQL Server Proficiency
Since the role requires strong skills in SQL Server, be ready to answer technical questions related to T-SQL. You might also want to prepare examples of how you've used SQL Server in past projects, particularly in relation to data processing and storage.
✨Familiarise Yourself with Relevant Tools
Research the infrastructure management tools mentioned in the job description, such as Nutanix Prism Central and VMware vCenter. Being able to discuss how you've worked with these tools or similar ones will show that you're well-prepared for the tasks at hand.
✨Prepare for Technical Questions
Expect technical questions that assess your knowledge of data extraction methods, especially using RESTful APIs. Brush up on your understanding of Python and Excel VBA, as these skills are crucial for the role. Consider preparing a small coding example or script to demonstrate your proficiency.
