Freelance Excel Vba Developer Jobs in California

Location: Naval Postgraduate School, Monterey, CA / Remote from contractor facilities, as appropriate
Clearance Required: U.S. Citizenship Required
Employment Type: Full-Time
Salary Range: $143,000-$160,000

MKS2 is seeking a highly skilled Software Developer - Journeyman / Operations Research Software Engineer to support modernization of the Naval Postgraduate School Replenishment at Sea Planner (RASP), a government-owned software platform used for real-world Navy logistics planning, budgeting, and operational decision support.

This position will develop, maintain, and enhance optimization code, web-based interfaces, Excel/VBA tools, and Microsoft Office 365-enabled capabilities that support Navy replenishment-at-sea operations, multi-tier logistics modeling, consolidation event planning, and operational scenario development.

The ideal candidate will bring strong experience in Python, Pyomo, mathematical optimization, Navy logistics operations, and software engineering best practices, with the ability to translate complex operational requirements into professionally tested and executable software solutions.

• Develop, maintain, and enhance RASP software using Python, Pyomo, GAMS, and related open-source or optimization environments.
• Evaluate and support integration of advanced optimization tools, including NVIDIA cuOpt, where appropriate.
• Develop and deploy an Excel/VBA front-end to support local RASP installations.
• Support transition of RASP capabilities into Microsoft Office 365 environments.
• Design, develop, and deploy web-based RASP user interfaces within Naval Postgraduate School-hosted computing environments.
• Enhance RASP to support multi-tier logistics modeling, consolidation events, operational planning workflows, and replenishment-at-sea decision support.
• Maintain and update interfaces between RASP and other funded Navy programs that align with RASP objectives.
• Translate logistics, optimization, and user-interface requirements into executable, documented, and professionally tested software solutions.
• Produce fully documented code, comments, repositories, technical reports, test results, benchmark outputs, and open-source component documentation.
• Validate benchmarked outputs, minimize processing lag, identify defects, and troubleshoot software performance issues.
• Support user acceptance testing, stakeholder feedback, and iterative software improvements.
• Develop operational scenarios and provide technical support to NPS faculty and student research efforts.
• Ensure all work complies with CUI, OPSEC, and government intellectual-property requirements.

• Master of Science degree required.
• Degree requirement may be waived for candidates with ten (10) years of at-sea replenishment experience and strong evidence of advanced mathematical modeling skills.

• Minimum five (5) years of experience with Python, Pyomo, and other open-source software systems.
• Minimum five (5) years supporting Department of the Navy logistics commands in replenishment-at-sea operations.
• Experience supporting operational analysis, scheduling improvement recommendations, and participation in wargames, exercises, or operations.
• Minimum five (5) years developing or supporting Python web-server environments.
• Demonstrated experience translating logistics, optimization, and user-interface requirements into executable, professionally tested software solutions.

• U.S. citizenship is required.

• Experience with GAMS, Python/Pyomo optimization models, and advanced optimization tools such as NVIDIA cuOpt.
• Advanced proficiency with Microsoft Office, Excel, Visual Basic for Applications (VBA), and Office 365 interface development.
• Experience developing web-based user interfaces and deploying software in hosted server environments.
• Knowledge of mathematical optimization, multi-tier logistics modeling, and consolidation event planning.
• Strong software documentation, code repository management, testing, benchmarking, troubleshooting, and operational scenario-development skills.
• Experience supporting Navy logistics, operational research, maritime planning, or replenishment-at-sea mission areas.

• Strong understanding of mathematical optimization, logistics modeling, and operational decision-support tools.
• Proficiency developing Python-based software solutions in structured, professional software environments.
• Ability to work with Pyomo, GAMS, and related optimization frameworks.
• Strong understanding of Python web-server environments and hosted application deployment.
• Ability to develop intuitive user interfaces for technical and operational users.
• Advanced Excel, VBA, and Office 365 development skills.
• Strong technical documentation, software testing, benchmarking, and troubleshooting abilities.
• Ability to collaborate with government stakeholders, faculty, researchers, students, and technical teams.
• Strong analytical mindset with the ability to translate Navy logistics requirements into practical software capabilities.
• Ability to work independently while supporting complex software modernization objectives.

• Work may be performed at the Naval Postgraduate School in Monterey, CA or remotely from contractor facilities, as appropriate.
• Supports government-owned software modernization efforts and Navy logistics decision-support tools.
• Requires close coordination with NPS faculty, student researchers, Navy stakeholders, and technical development teams.
• Must comply with CUI, OPSEC, and applicable government intellectual-property requirements.

At MKS2, we support critical defense missions by delivering innovative technology, operational analysis, and software modernization solutions. Our teams work alongside government partners to improve mission readiness, operational planning, and decision-support capabilities across the Department of Defense.