Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Develop and automate VBA solutions for financial data processing and reporting.
- 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 in the financial sector while honing your VBA skills.
- Qualifications: Proficient in VBA with experience in financial calculations and data handling.
- Other info: Fast-paced environment with potential for contract extension.
The predicted salary is between 36000 - 60000 £ per year.
Location: London (Hybrid)
Rate: TBC
Duration: 3-6 months (with potential extension)
Start Date: ASAP
This is an excellent opportunity for a highly skilled VBA Developer to support a strategic client engagement. We are seeking someone with proven experience in building VBA calculations based on account transaction histories. The ideal candidate will be proficient in processing large transaction datasets and have a strong understanding of interest calculations.
Key Responsibilities:
- Implement defined interest calculation logic of customer transaction histories
- 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.
Required Skills & Experience:
- Calculations & Transactions: Good understanding of interest calculations and proficient in implementation in VBA; Experience with customer transaction histories e.g. initial loan, interest accrual and payment transactions; Understanding of remediation calculations based on either commission or interest.
- 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.
- Data Handling & Transformation: 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.
- API & Integration: 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.
- Deployment & Maintenance: 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
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.
VBA Developer (Contract / FTC) – London employer: Delta Capita
Contact Detail:
Delta Capita 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 financial services sector and let them know you're on the lookout for a VBA Developer role. You never know who might have the inside scoop on opportunities or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best VBA projects, especially those involving interest calculations and data processing. This will give potential employers a taste of what you can do and set you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on common VBA scenarios and problem-solving questions. Practice explaining your thought process clearly, as communication is key in collaborating with IT and business teams.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you're serious about joining our team at Delta Capita.
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 with interest calculations. We want to see how your background aligns with the role, so don’t be shy about showcasing relevant 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 specific examples of your work with transaction datasets and any automation tasks you've tackled.
Showcase Your Problem-Solving Skills: In your application, mention instances where you’ve successfully debugged or optimised VBA code. We love candidates who can demonstrate their analytical thinking and problem-solving abilities!
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 the ball rolling on your application process. Don’t wait too long – we’re excited to hear from you!
How to prepare for a job interview at Delta Capita
✨Know Your VBA Inside Out
Make sure you brush up on your VBA skills before the interview. Be ready to discuss your experience with modular code design, error handling, and debugging techniques. They’ll want to know how you’ve tackled challenges in previous projects, so have some examples at the ready!
✨Understand Interest Calculations
Since this role involves implementing interest calculation logic, it’s crucial to have a solid grasp of how these calculations work. Prepare to explain your understanding of customer transaction histories and how you’ve applied this knowledge in past roles.
✨Showcase Your Data Handling Skills
Be prepared to talk about your experience with automating data processing tasks and transforming large datasets. Highlight any specific projects where you’ve used VBA to streamline workflows or improve data integrity, as this will demonstrate your practical skills.
✨Communicate Effectively
Strong communication skills are key for this position. Practice articulating your thoughts clearly and concisely, especially when discussing technical concepts. Remember, they’re looking for someone who can collaborate with IT and business teams, so show that you can engage stakeholders effectively.
