At a Glance
- Tasks: Design and develop scalable VBA solutions for data automation and workflow optimisation.
- Company: Join Delta Capita, a global leader in financial services and technology innovation.
- Benefits: Enjoy hybrid working, competitive pay, and opportunities for professional growth.
- Why this job: Make an impact by automating processes and enhancing data integrity in a dynamic environment.
- Qualifications: Proficient in VBA with experience in data handling and integration.
- Other info: Fast-paced role with potential for contract extension and career advancement.
The predicted salary is between 36000 - 60000 £ per year.
Location: London (Hybrid)
Rate: TBC
Duration: 3-6 months (with potential extension)
Start Date: ASAP
Overview
This is a great opportunity for a highly skilled VBA Developer to support a strategic client engagement. We are looking for candidates who can deliver robust, scalable VBA solutions across data automation, Excel integration, and workflow optimisation.
Responsibilities
- Design and develop modular, maintainable VBA codebases within Excel and other Microsoft Office applications.
- Automate data processing tasks and reporting workflows using advanced VBA scripting.
- Implement field-level and cross-file data validation checks to ensure data integrity and consistency.
- Integrate VBA solutions with external data sources (e.g., databases, web services) using OLEDB/ADO.
- Collaborate with IT and business teams to deploy and maintain solutions in production environments.
- Manage version control and documentation for VBA scripts and macros.
Qualifications
Core VBA Development- Advanced proficiency in VBA for Excel, Access, and Outlook.
- Strong understanding of error handling and debugging techniques.
- Experience in modular code design for scalability and maintainability.
- Expertise in automating bulk data ingestion and transformation within Excel.
- Familiarity with schema validation, cleansing routines, and dynamic reporting.
- Experience with rule-based logic and custom validation frameworks.
- Experience integrating VBA with external systems via OLEDB/ADO or XML/JSON.
- Ability to manage file I/O operations and automate multi-file processing tasks.
- Understanding of authentication protocols and secure data handling.
- Familiarity with version control practices for VBA (e.g., Git with exported modules).
- Experience in documenting and maintaining VBA solutions in regulated environments.
- Ability to configure environments and manage dependencies across Office applications.
Ideal Candidate Profile
- Proven experience in financial services or regulated environments.
- Able to work independently and manage deliverables in a fast-paced setting.
- Strong communication skills and stakeholder engagement.
How We Work
Delta Capita is an equal opportunity employer. We positively encourage applications from suitably qualified and eligible candidates regardless of age, colour, disability, national origin, ancestry, race, religion, gender, sexual orientation, gender identity and/or expression, veteran status, genetic information, or any other status protected by applicable law. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. If you require any reasonable adjustments through your interview process, please use the designated space within the application questionnaire.
This is a Contract or FTC position located in London with hybrid working. As the selection and interview process is ongoing, please submit your application in English as soon as possible; if your profile is selected, a member of our team will contact you within 4 weeks. For this role, a valid working permit for the UK is mandatory.
Who We Are
Delta Capita Group (a member of the Prytek Group) is a global managed services, consulting and solutions provider with a unique combination of experience in Financial Services and technology innovation capability. Our mission is to reinvent the financial services value chain providing technology based mutualised services for financial institutions for non-differentiating services.
Our Offerings
- Managed Services
- Consulting
- Technology
To know more about Delta Capita and our culture, please refer to our website or contact the recruitment team for more information.
VBA Developer (Contract / FTC) – London employer: Delta Capita Group
Contact Detail:
Delta Capita Group Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land VBA Developer (Contract / FTC) – London
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend meetups, and join online forums. You never know who might have the inside scoop on a VBA Developer role or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best VBA projects. This could be anything from automating reports to integrating with external data sources. A strong portfolio can really set you apart during interviews.
✨Tip Number 3
Prepare for those interviews! Brush up on common VBA interview questions and be ready to demonstrate your problem-solving skills. Practice coding challenges that focus on data automation and Excel integration.
✨Tip Number 4
Apply through our website! We make it easy for you to submit your application and get noticed. Plus, it shows you're genuinely interested in joining our team. Don't miss out on this opportunity!
We think you need these skills to ace VBA Developer (Contract / FTC) – London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your VBA skills and experience relevant to the role. We want to see how you've tackled similar challenges in the past, so don’t hold back on those specific projects!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're the perfect fit for this VBA Developer role. Share your passion for data automation and how you can contribute to our team at StudySmarter.
Showcase Your Problem-Solving Skills: In your application, give examples of how you've solved complex problems using VBA. We love candidates who can think outside the box and deliver scalable solutions, so let us know how you've done this before!
Apply Through Our Website: We encourage you to submit your application through our website. It’s the best way for us to receive your details and get you into our system quickly. Plus, it shows you’re keen to join the StudySmarter family!
How to prepare for a job interview at Delta Capita Group
✨Know Your VBA Inside Out
Make sure you brush up on your VBA skills before the interview. Be ready to discuss your experience with Excel, Access, and Outlook, and have examples of your work handy. They’ll want to know how you’ve tackled error handling and debugging in past projects.
✨Showcase Your Data Handling Expertise
Prepare to talk about your experience with data automation and transformation. Think of specific instances where you've automated bulk data ingestion or implemented validation checks. This will demonstrate your ability to deliver robust solutions that ensure data integrity.
✨Familiarise Yourself with Integration Techniques
Since the role involves integrating VBA with external systems, be ready to discuss your experience with OLEDB/ADO or XML/JSON. Have a couple of examples where you successfully managed file I/O operations or automated multi-file processing tasks.
✨Communicate Effectively
Strong communication skills are key, especially when collaborating with IT and business teams. Practice explaining your technical solutions in simple terms, as this will help you engage with stakeholders during the interview and show that you can bridge the gap between tech and business.