Application Systems Analyst / Programmer

Decca Consulting LLC; Salem (OR); On-site; USD 90,000 - 120,000; Full time

Job summary

Decca Consulting LLC is seeking a results-driven analyst-developer to modernize an Excel-based SCMAC system for environmental/workflow applications. You will analyze business rules, document requirements, and design a web-based or standalone solution with robust validation and user-friendly interfaces.

You will collaborate with business stakeholders to evaluate platforms, implement automated calculations, and ensure secure, accessible access across devices.

Qualifications

• Bachelor's degree in CS/IS/SE or equivalent experience.
• Experience in application development, systems analysis, or business application implementation.
• Experience translating business requirements into application functionality.
• Experience with Microsoft Excel, including complex formulas and data-driven workflows.
• Experience with development, configuration, or modernization.
• Strong analytical and problem-solving skills.
• Experience in testing, debugging, and quality assurance.
• Ability to document technical requirements, business rules, workflows, and application functionality.
• Strong communication with non-technical stakeholders.

Responsibilities

• Analyze and document functionality, rules, formulas, and workflows of the existing Excel-based SCMAC.
• Collaborate with stakeholders to understand requirements and intended functionality.
• Evaluate Excel and other platforms using established selection criteria.
• Design and adapt a solution to replace or modernize the Excel-based system.
• Develop automated calculations for baseline and predicted stream conditions.

Skills

Analytical thinking

Problem solving

Documentation

Communication

QA and testing

Requirements analysis

Excel expertise

Education

Bachelor's degree in CS/IS/SE

Related field or experience

Tools

JavaScript

HTML/CSS

SQL

Web development

Security basics

C# / .NET

Job description

Key Responsibilities

• Analyze and document the functionality, business rules, formulas, and workflows of the existing Excel-based SCMAC.
• Work closely with business stakeholders and subject-matter experts to understand application requirements and intended functionality.
• Evaluate and compare Excel and other commercially available application platforms using established selection criteria.
• Recommend an appropriate technology/platform based on usability, accessibility, accuracy, adaptability, robustness, cost, and maintenance requirements.
• Design, develop, configure, or adapt the selected application to replace or modernize the existing Excel-based solution.
• Implement automated calculations for baseline and predicted stream conditions.
• Develop functionality to calculate changes in value-weighted stream functions and resulting SCMAUs.
• Implement required adjustment calculations, including temporal loss and administrative protection factors.
• Ensure calculations and business rules are accurate, consistent, and protected from unauthorized modification.
• Develop validation and error-checking functionality to identify missing, invalid, or incorrectly entered data in real time.
• Design an intuitive user interface using plain language and straightforward formatting.
• Ensure the application can be accessed across commonly used devices and systems without requiring specialized software where applicable.
• Implement appropriate controls to limit external users to permitted data-entry functionality while protecting underlying formulas and calculations.
• Support application configuration so authorized business staff can make future updates without requiring extensive external development support.
• Conduct beta testing using project information provided by business stakeholders.
• Identify, document, troubleshoot, and resolve application defects and calculation discrepancies.
• Prepare technical and user documentation describing application functionality, calculations, workflows, and usage.
• Participate in stakeholder meetings, demonstrations, requirements discussions, and application reviews.
• Incorporate stakeholder feedback into application enhancements and final implementation.
• Provide written and verbal presentations covering application functionality, platform evaluation, testing results, and recommendations.
• Support final deployment and delivery of the completed application.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Software Engineering, or a related field, or equivalent professional experience.
• Experience in application development, systems analysis, programming, or business application implementation.
• Experience analyzing and translating business requirements into application functionality.
• Experience working with Microsoft Excel, including complex formulas, calculations, validation, and data-driven workflows.
• Experience with application development, configuration, or modernization.
• Strong analytical and problem-solving skills.
• Experience with application testing, debugging, and quality assurance.
• Ability to document technical requirements, business rules, workflows, and application functionality.
• Strong communication skills and ability to work directly with non-technical business stakeholders.

Preferred Qualifications

• Experience converting spreadsheet-based processes into web-based or standalone applications.
• Experience developing calculators, decision-support tools, or rules-based applications.
• Experience with web application development and responsive user interfaces.
• Experience with JavaScript, HTML, CSS, SQL, or a comparable application development technology.
• Experience with application security and protecting business logic from unauthorized modification.
• Experience evaluating and selecting commercial off-the-shelf software or application platforms.
• Experience conducting user acceptance testing or beta testing.
• Experience working with government, regulatory, environmental, or compliance-related applications.
• Experience documenting complex calculations and translating them into software requirements.