Note: The job is a remote job and is open to candidates in USA. Ventures Unlimited Inc is seeking a Mitigation Calculator Application Systems Analyst/Programmer to evaluate and develop an application for calculating baseline and predicted stream conditions. The role involves implementing mitigation calculations, validating data and business logic, protecting formulas, evaluating technology options, and documenting testing and recommendations.
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
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
Company Overview