VBA Developer (Contract / FTC) - London

Delta Capita; City of Westminster; Hybrid; GBP 80,000 - 100,000; Full time

Job summary

A leading financial services consultancy is seeking a highly skilled VBA Developer for a contract position in London with hybrid working options. The ideal candidate will have substantial experience in building VBA calculations from transaction histories and will be adept at automating data processes and ensuring data integrity. Responsibilities include developing VBA code within Excel, integrating external data, and maintaining robust documentation. Strong communication skills are essential for stakeholder engagement.

Qualifications

• Proven experience in implementing complex VBA calculations in financial settings.
• Ability to work independently and manage deliverables in a fast-paced environment.
• Strong understanding of data integration and automation.

Responsibilities

• Implement interest calculation logic based on transaction histories.
• Design and develop maintainable VBA codebases.
• Automate data processing tasks using advanced VBA scripting.
• Integrate VBA solutions with external data sources.
• Ensure data integrity through validation checks.

Skills

VBA programming

Interest calculations

Stakeholder engagement

Data validation

Data handling and transformation

Tools

Excel

VBA

Access

Outlook

Job description

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 integrate OLEDB/ADO or XML/JSON
• Manage file I/O operations and automate multi-file processing tasks
• Understand authentication protocols and ensure secure data handling
• Deploy and maintain solutions in production environments
• Maintain familiarity with version control practices for VBA (e.g., Git with exported modules)
• Document and maintain VBA solutions in regulated environments
• Configure environments and manage dependencies across Office applications

Ideal Candidate Profile

• Proven experience in financial services or regulated environments
• Ability 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.

Required Skills & Experience

Calculations & Transactions

• Good understanding of interest calculations and proficiency in implementing them 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, XML/JSON, or other APIs

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.

Position Details

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.