Description
Resource 1 is seeking a VBA Developer with finance/accounting experience to partner with its internal resources to develop a profit model for its Contract Lifecycle Management project.
The resource will be collaborating with our business partner on a daily basis. The new profit model will replace an existing one. The output of the profit model will feed a third-party contract management software tool. Maintain MS Access Finance applications including tables, queries, macros and Visual Basic for Applications modules, developing enhancements as needed.
RESPONSIBILITIES:
- Maintain MS Excel Finance applications including Visual Basic for Applications modules and pivot tables, developing enhancements as needed.
- Compile, Organize, and Reconcile Data between multiple systems using MS Excel and MS Access. Demonstrate Strong Attention to Detail to ensure accuracy of financial reports.
- Document and maintain clear procedures and flowcharts.
- Makes suggestions for problem solutions or software enhancements, which will typically be reviewed by a more senior developer.
- Provide accurate and timely status reports on work progress.
- Other duties will include; Production support and subsequent defect research, assistance in technical and/or system.
SKILLS:
- Must come from a finance or accounting background.
- 3+ years of experience developing financial models.
- Must be fluent in financial concepts.
- Must be proficient in Microsoft Excel and Visual Basic.
- Microsoft Access experience is also required though Excel and VBA will be the primary tools.
- Work must be thoroughly documented.