Position: Lead MS Access/VBA Developer
Company: Luxoft
Experience required: 3y
Category: SQL
English level: upper
Published: 2020-03-01T00:00:00+02:00

**Project Description88
Our client is a UK subsidiary of a global financial house working in multiple markets and asset classes.
We are currently looking to expand our Kyiv team with a VBA developer, who will 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.

Successful candidate may be required to travel to London, UK for initial induction.
**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.
**Mandatory Skills**
Minimum 5 years Microsoft Access experience and proven expert.
MS Access VBA proven expert
Ability to design, code, verify, test, document, amend and refactor complex programs/scripts and integration software services.
Ability to contribute to selection of the software development approach for the project, selecting appropriately from predictive (plan-driven) approaches or adaptive (iterative/agile) approaches.
Ability to create traceability records, from test cases back to requirements.
Ability to produces test scripts, materials and regression test packs to test new and amended software or services.
Proven track record on providing reports on progress, anomalies, risks and issues associated with the overall project.
Excellent communication skills.
Results driven, with a strong sense of accountability.
A pro-active, motivated approach.
Strong decision making skills, the ability to demonstrate sound judgement.
Strong mathematical skills
**Nice-to-Have Skills**
Experience of working as programmer or developer in another Financial Institution would be beneficial.
Knowledge of loan operations would be beneficial.
**Languages**
English: Advanced/Fluent