VBA Access Developer

Mindlance; New Castle (DE); On-site; USD 75,000 - 100,000; Full time

Job summary

A national recruiting company is seeking a strong Access developer to manage and support End User Computing (EUC) solutions for one of their banking clients. Responsibilities include maintaining operating procedures, documenting processes, automating reporting, and acting as a support contact for functional and technical issues. The ideal candidate should have extensive knowledge in VBA and Access, with a strong focus on data quality and analytical skills. This role requires the ability to multitask across various projects and to work extended hours if needed.

Qualifications

• Strong Access developer required for database management.
• Experience in VBA code essential.
• Ability to create import/export specifications in Access.

Responsibilities

• Maintain and document operating procedures for EUCs.
• Create and manage a version of Access DB for production.
• Act as support for functional and technical issues related to EUCs.

Skills

Strong Access developer with extensive background in VBA code

Ability to automate Excel from within MS Access

Strong analytical skills

Ability to reverse engineer data for reports

Multitasking across multiple projects

Tools

SAP business objects

Microsoft Access

Microsoft Excel

Job description

Mindlance is a national recruiting company which partners with many of the leading employers across the country. Feel free to check us out at http://www.mindlance.com.

Job Description

Participate in knowledge sharing sessions and acquire business knowledge of all existing EUCs (End User Computing - access database based).

• Review, document and maintain operating procedures for all EUCs.
• Create and maintain a version of the Access DB in a different shared folder to be managed to production standards. The production version will be used to create monthly journals and will serve as a recovery copy if corrupted.
• Own and maintain obfuscation (GEID scrambling mechanism) logic to avoid data compromise on the technology side, as part of SDLC.
• Participate and certify enhancements, changes, and fixes whenever released for any EUC.
• Manage all ad‑hoc reporting, data analysis, forecasting/projection modeling requirements.
• Be responsible for data and data quality within EUCs – acquiring, loading, reconciling, exception reporting, sending to downstream systems.
• Create and manage monthly calendar for Equity Compensation and Benefits separately.
• Publish monthly dashboard of activities to finance and technology senior management.
• Act as Level 1 and Level 2 support for EUCs for both functional and technical issues (see Appendix for definitions of support levels).
• Keep finance and technology in the loop for all communications regarding EUCs, including changes to operating procedures, calendars, issues, enhancements, etc.

Qualifications

1. Strong Access developer with extensive background in VBA code.
2. Ability to automate Excel from within MS Access.
3. Multitasking across multiple projects, departments, and processes.
4. Must have understanding and ability to write import and export specifications within MS Access.
5. Ability to apply several forms of input files to database application; SAP business objects experience helpful.
6. Strong analytical skills.
7. Ability to reverse engineer to determine source and validity of data for downstream reports and feeds.
8. Desire to work extended hours to include weekends to meet system deadlines.
9. Strong independent worker with the drive to understand process flow and interpret process requirements.

Additional Information

This job is with one of our banking clients.