Job description
Description
Location: London (Hybrid)
Rate: TBC
Duration: 3-6 months (with potential extension)
Start Date: ASAP
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.
Requirements
Key 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.
Required Skills & Experience
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
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 3 offerings are:
Managed Services
Consulting
Technology
To know more about Delta Capita and our culture click here: Working at DC - Delta Capita.
