[Remote] Sr. Application Analyst - Excel

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