Position:
Mitigation Calculator Application Systems Analyst / Programmer
Location:
Remote / Salem, OR
Visa:
USC / Green Card
Interview:
Face-to-Face / Webcam
Key Responsibilities
Develop a selection matrix comparing potential application options based on usability, accessibility, automation, accuracy, adaptability, and robustness.
Ensure the application accurately calculates baseline versus predicted stream conditions.
Support calculations for impact sites and compensatory mitigation sites to determine whether proposed impacts are fully offset.
Implement required adjustment factors, including
vegetative temporal loss
and
administrative protection
.
Build appropriate data validation and error-checking functionality to identify missing or incorrectly entered information.
Ensure the calculator is user-friendly, accessible across common devices/systems, and requires minimal direct data entry.
Ensure internal formulas and calculations are protected from unauthorized modification.
Document testing results, functionality, application evaluation, and recommendations.
Desired Qualifications / Skills
Experience as an
Application Systems Analyst, Systems Analyst, Application Developer, or Programmer Analyst
.
Experience evaluating, selecting, and implementing business applications or software tools.
Strong experience with
Microsoft Excel
, including advanced formulas, calculations, data validation, protection, and automation.
Experience converting or modernizing spreadsheet-based business tools into applications or other platforms.
Strong understanding of
business rules, requirements analysis, functional specifications, and application workflows
.
Experience developing complex calculations and ensuring accuracy of business logic.
Experience with data validation, error handling, automation, and user-friendly application design.
Ability to evaluate multiple technology/application options and provide recommendations based on defined criteria.
Experience with
UAT/beta testing
, test scenarios, defect identification, and documentation.
Strong analytical, problem-solving, documentation, and communication skills.
Ability to work collaboratively with business stakeholders and translate business requirements into a functional technical solution.
Experience working with government, regulatory, environmental, or public-sector applications is a plus.