[Hiring] Application Systems Analyst / Programmer @Abacus

Role Description

The purpose of this request is to create and execute a contract for services. A desired contract outcome for DSL is that the successful contractor will remaster an existing draft "Stream Compensatory Mitigation Accounting Calculator (SCMAC)", which is currently in Microsoft Excel workbook format, into a more user-friendly application format. The SCMAC is critical for successful implementation of DSL's newly updated rules that will take effect on May 3, 2027, to implement a new stream compensatory mitigation accounting protocol within Division 85, Section -0692, of Oregon Administrative Rules (OAR's). The SCMAC will be made available to the public on January 1, 2027.

Qualifications

• Excel - Expert (10+ Years)

Requirements

• Assess the current (Excel) version of the SCMAC for general understanding of its functionality.
• Compare the Excel version of the SCMAC against other available applications and tools using a selection matrix.
• Select, in coordination with DSL mitigation staff, the most appropriate application, which may be Excel, with justification provided to DSL staff.
• Adapt the SCMAC by converting it from the current version to a new version to achieve the desired goals.
• Beta Test the new SCMAC using DSL-supplied stream project information.

Benefits

• User friendly – Easy to understand and use.
• Accessible from multiple access technologies (computer, phone, iPad) without the need for specialized software.
• As fully automated as possible with limited direct entry of data.
• Accurate – Able to provide consistent and accurate outputs.
• Adaptable – Easily updated and customized by DSL staff.
• Robust – Introduces low (or no) user error.

Estimated Duration

10/12/2026 - 11/30/2026

Schedule

• Monday: Yes
• Tuesday: Yes
• Wednesday: Yes
• Thursday: Yes
• Friday: Yes
• Saturday: No
• Sunday: No

Location

Position Location - Remote, Salem, Oregon