
Information Resource Group, Inc.
Salem, Oregon • 3d ago
Easy Apply
Third Party, Contract
Depends on Experience
308 results (3 new)

Information Resource Group, Inc.
Salem, Oregon • 3d ago
Easy Apply
Third Party, Contract
Depends on Experience











ICF Consulting Group, Inc.
Remote or Reston, Virginia • Today
Full-time
USD 81,499.00 - 167,644.00 per year



Synergy Business Innovation & Solutions Inc
Remote • Today
Full-time
USD 105,000.00 - 121,000.00 per year


The Oregon Department of State Lands (DSL) seeks a contractor to evaluate, select, adapt, and beta‑test a new application for the Stream Compensatory Mitigation Accounting Calculator (SCMAC). The SCMAC is currently built in Excel and must be remastered into a more user‑friendly, automated, and secure application that supports DSL’s updated stream compensatory mitigation rules (effective May 3, 2027).
This role requires a blend of technical application development, data modeling, requirements analysis, and environmental program understanding. The contractor will work closely with DSL mitigation staff to ensure the new SCMAC is accurate, robust, accessible, and easy for both internal and public users.
Assess the current Excel‑based SCMAC to understand its formulas, logic, workflows, and intended regulatory use.
Research and compare alternative applications/platforms (including Excel) using DSL’s selection matrix.
Recommend the most appropriate application based on usability, automation, accessibility, cost, security, and adaptability.
Convert the existing SCMAC into the selected application while preserving all foundational formulas and accounting logic.
Build automated calculations for:
Value‑weighted stream function changes (baseline vs. predicted conditions)
Temporal loss adjustments
Administrative protection adjustments
Impact‑site vs. mitigation‑site SCMAU comparisons
Ensure the tool is:
User‑friendly and intuitive
Accessible across devices without specialized software
Locked against formula manipulation by external users
Easy for DSL staff to update without external support
Conduct beta testing using DSL‑provided project examples.
Provide written and verbal summaries, documentation, and final deliverables.
Participate in three required 1–2 hour meetings with DSL staff throughout the contract.
Strong experience developing calculators, assessment tools, or decision‑support applications.
Expertise with Excel, low‑code/no‑code platforms, or commercial off‑the‑shelf applications (e.g., Power Apps, Tableau, custom web apps, etc.).
Ability to evaluate multiple software platforms using structured criteria.
Experience converting complex Excel models into automated applications.
Strong understanding of data modeling, formulas, and structured calculations.
Ability to design user‑friendly interfaces with error‑flagging and guided data entry.
Experience building secure tools where internal logic is protected from external modification.
Excellent documentation and communication skills.
Ability to collaborate with regulatory or environmental program staff.
Background in environmental science, stream assessment, mitigation, or regulatory programs.
Familiarity with Oregon Administrative Rules (OAR) or similar regulatory frameworks.
Experience with SFAM (Stream Function Assessment Method) or compensatory mitigation tools.
Prior work with government agencies or public‑facing applications.
Written and verbal summary of SCMAC functionality.
Evaluation of alternative applications using DSL’s selection matrix.
Recommendation and justification for the selected application.
Fully adapted SCMAC in the new application format.
Beta test results using DSL‑provided project scenarios.
Final SCMAC tool ready for public release.
To see how well you match this job, please log in or create an account.
Once logged in, be sure to complete your profile to get the most accurate match score.
Hillsboro, Oregon
•
2d ago
CCS Global Tech is a rapidly growing Information Technology company with a diverse portfolio of technology products and services and a large network of industry partnerships. With over 22 years of being a successful business with a global talent pool and presence, CCS is a certified Microsoft Gold Partner and specializes in delivering expert Microsoft based solutions for technical and business needs. We have been recognized by Inc. 500 Magazine as one of the fastest growing small companies in th
Easy Apply
Contract, Third Party
Remote
•
6d ago
Requisition ID: Mitigation Calculator Application Systems Analyst / Excel Expert Location:775 Summer St NE # 100 Salem, Oregon Duration: 12+ Months Client: OR DSL 100% Remote Job The purpose of this request is to create and execute a contract for services. A desired contract outcome for DSL is that the successful contractor will remaster an existing draft Stream Compensatory Mitigation Accounting Calculator (SCMAC), which is currently in Microsoft excel workbook format, into a more user-friend
Easy Apply
Third Party, Contract
80 - 85
Remote
•
2d ago
Hi Please find my direct client job requirement for your consideration. Title: Application Developer Excel to Application Modernization Locations: Remote The purpose of this request is to create and execute a contract for services. A desired contract outcome for DSL is that the successful contractor will remaster an existing draft Stream Compensatory Mitigation Accounting Calculator (SCMAC) , which is currently in Microsoft excel workbook format, into a more user-friendly application format. Th
Easy Apply
Contract
Depends on Experience
Remote
•
4d ago
Application Systems Analyst / Programmer Mitigation Calculator (SCMAC) Contract | Remote About the Role: Oregon DSL is replacing its Excel-based Stream Compensatory Mitigation Accounting Calculator (SCMAC) with a more user-friendly application. You will assess the current workbook, evaluate platforms against DSL's selection matrix, recommend the best fit (which may still be Excel), convert the calculator, and beta test it with DSL staff. Responsibilities: Assess the current Excel SCMAC and doc
Easy Apply
Third Party, Contract
Depends on Experience