London, United Kingdom Of Great Britain And Northern Ireland (On-site)

Access VBA Developer

10 Months ago • 6-8 Years

Quality Assurance

Job Description

This role involves maintaining and enhancing approximately 60 MS Access applications (600,000 lines of VBA code) for a UK subsidiary of a global financial house. Responsibilities include the full SDLC: design, coding, testing, implementation, and support of Access and SQL Server solutions. The developer will work closely with operations heads and SMEs, producing analysis, requirements documents, design documents, applications, test scripts, and test plans. Reusing existing components and adhering to established standards are crucial. Strong communication and project management skills are essential for handling small to medium-sized projects and collaborating with senior stakeholders. The role requires working UK hours.

Good To Have:

Banking experience

Must Have:

End-to-end SDLC experience
MS Access & SQL Server expertise
VBA development proficiency
Requirement analysis & design
Testing & documentation
Strong communication skills
UK working hours

Add these skills to join the top 1% applicants for this job

sql

oops

software-development-lifecycle-sdlc

Project description

Our client is a UK subsidiary of a global financial house working in multiple markets and asset classes.
We are currently for a VBA developer, who will work in the technology team within Operations for EMEA, which is responsible for around 60 MS Access applications with about 600,000 lines of VBA code. The role is for maintenance and enhancement of existing systems, and development of new systems to support business requirements.

The candidate will work closely with the heads of operations departments and SMEs, operating as a senior analyst and programmer to support system development and implementation. They will be responsible for the production of various project elements including but not limited to; Analysis, Business Requirements, Design Documents, Application Programs, Test Scripts and Test Plans. The end solutions should be consistent with the design and implementation of existing solutions, and reuse existing components where relevant.

Strong communication and interpersonal skills is a must, and the candidate must have a well organised and structured approach to managing small/medium projects and working with senior stakeholders.

Required candidate will need to work UK hours.

Responsibilities

Undertake the design, coding, and testing of solutions using MS Access and SQL Server technologies.

Re-use and leverage functional components from existing MS Access systems if applicable.

Analyse user requirements and design technical solutions to business problems.

Document requirements, system designs/specifications and user guides as per department standards.

Applies agreed standards and tools, to achieve well-engineered outcomes.

Prepare test plans including test cases and coordinate UAT with users.

Works iteratively with stakeholders, to identify potential benefits and available options for consideration, and in defining acceptance tests.

Accepts responsibility for creation of test cases using own in-depth technical analysis of both functional and non-functional specifications (such as reliability, efficiency, usability, maintainability and portability).

Specifies requirements for environment, data, resources and tools. Interprets, executes and documents complex test scripts using agreed methods and standards.

Records and analyses actions and results, and maintains a defect register.

Access VBA Development