VBA Developer

Job Responsibilities:
Working with internal business users and subject matter experts, the selected candidate will maintain and evolve existing Excel spreadsheets, Access databases, and reports used throughout the Fund Accounting business unit on a daily basis. Additionally, this person will build new spreadsheets and reports, as required. Finally, they will be responsible for change management and documentation of their solutions.

Specific Responsibilities
Migrate existing MS Access databases and Excel spreadsheets to newer file extensions.
Test for downstream impacts of file extension changes.
Create new and maintain existing excel spreadsheets that contain complex formulas and macros that will be used within business units to support everyday business functions.
Extract and manipulate data as part of business analysis and operational reporting.
Automate the running of specific macros to improve the efficiency of manual processes.
Act as a liaison to the business to surface issues and resolve problems.

Qualifications and Skills
Bachelor’s degree (Accounting, Finance, Computer Science, or similar preferred)
3+ years of experience with Excel Macros / VBA Development and MS Access DB Development
Capital Markets/Financial Services Administration knowledge and experience desired
Ability to work with a targeted direction in a fast-paced environment
Strong attention to detail with an ability to maintain a high level of information integrity and accuracy
Strong experience with the process and data analysis
Extensive experience with documentation and problem solving
Excellent communication skills, both written and verbal
Possess a can-do attitude, resourceful, excellent work ethic, enthusiastic, customer-oriented
Past exposure to SQL development experience
Gift for making things better than when they were found
Excellent organizational and interpersonal skills