Note: The job is a remote job and is open to candidates in USA. Mavensoft Technologies is seeking a Senior Application Analyst to modernize the Stream Compensatory Mitigation Accounting Calculator (SCMAC). The role will assess its Excel-based formulas and business rules, evaluate application platforms, recommend a solution, and convert the calculator into a user-friendly application while preserving calculation accuracy. The contractor will also conduct testing, document the solution, and collaborate with DSL staff.
Responsibilities
- Review and assess the existing Excel-based SCMAC to understand its functionality, formulas, business rules, and calculation logic
- Evaluate and compare alternative applications, platforms, and tools that could support the SCMAC
- Develop and use a selection matrix to compare potential solutions, including Excel
- Recommend the most appropriate application in collaboration with DSL mitigation staff
- Convert/adapt the existing SCMAC into the selected application or platform
- Preserve the existing calculation methodology and ensure accurate SCMAU outputs
- Implement automated calculations for baseline and predicted stream conditions
- Assess the existing Excel-based SCMAC
- Evaluate and compare potential application platforms
- Recommend the appropriate platform in coordination with DSL
- Adapt and implement the SCMAC in the selected platform
- Beta test the completed solution using DSL-provided project data
- Provide written and verbal documentation of the SCMAC's functionality and objectives
- Provide a written and verbal evaluation of the application alternatives and final platform recommendation
- Participate in required project meetings with DSL staff
Skills
- Experience developing, redesigning, or modernizing business applications, calculators, or decision-support tools
- Strong experience analyzing and translating complex Excel-based business logic, formulas, and calculations into an application or software solution
- Experience evaluating and selecting application platforms based on usability, accessibility, maintainability, security, and cost
- Strong understanding of data validation, automated calculations, business rules, and user interfaces
- Experience developing user-friendly applications for both technical and non-technical users
- Experience with application testing, validation, troubleshooting, and beta/UAT testing
- Strong analytical, problem-solving, documentation, and communication skills
- Ability to work collaboratively with business stakeholders and subject-matter experts
- Experience working with government, regulatory, environmental, natural resources, or public-sector applications
- Experience converting complex Excel workbooks into web-based, low-code/no-code, or commercial off-the-shelf applications
- Experience designing tools that are accessible across computers, tablets, and mobile devices
- Experience implementing role-based access, protected formulas, and controlled data-entry functionality
- Experience creating selection matrices or conducting technology/application evaluations
- Familiarity with environmental mitigation, regulatory compliance, or stream/wetland assessment processes
Benefits
- Remote work arrangement
Company Overview
Company H1B Sponsorship