Software Engineer - Demand Planning

Description

This role is responsible for building, debugging, testing, and deploying planning applications that are built on the Data Science Stack [Python, R, SQL] using standard web technologies that meet customer and stakeholder design and technical specifications. Strive to create cross-functional, cutting-edge, and well-tested planning applications.

Essential Duties and Responsibilities

• Maintain a high level of professionalism during direct contact with employees, suppliers, and customers via telephone, facsimile, telex, e-mail, written correspondence, and supplier visits.

• Build, debug, test, and deploy applications meeting system analysis and customer requirements 

• Perform statistical analyses, identify patterns, build basic analytical models, and write SQL queries

• Develop dashboards, charts, and recurring or ad hoc reports for business stakeholders

• Partner with cross-functional teams (Operations, Finance, Supply Chain, Sales) to understand data needs and deliver actionable insights

• Conduct independent industry and market research, reporting on trends, potential disruptions, and growth opportunities

• Support ad hoc analyses that inform both operational execution and strategic decision-making

• Use and adopt software design patterns whenever useful and appropriate

• Stay updated with the latest web technologies and development platforms

• Other duties as directed by Supervisor.

Key Roles

• Development, enhancement, maintenance, documentation, and testing of various software systems in support of SIOP and other cross-functional projects

• Collaboration between Sales, Operations, CI, and IT

• Management of company critical applications (i.e. Demand Planning Monorepo) 

• Write clean, well-documented, testable code following separation of configuration and execution logic (config-driven architecture); Participate in code review, testing, and documentation practices to keep the system maintainable as it scales

Requirements

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.  The requirements listed below are representative of the knowledge, skill, and/or ability required.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education & Experience Requirements:

Bachelor’s degree in management information systems, Computer Science, or a related field, or equivalent practical experience. Minimum of 2 years of software development experience, ideally on complex, UI-intensive applications, or an equivalent combination of education and experience. A working understanding of company operations — specifically demand planning, SIOP processes, and manufacturing data flows — is necessary to perform the duties of this role effectively.

Required Knowledge and Skills:

• Have a working knowledge of the latest Visual Studio releases

• Proficiency in Python (intermediate-to-advanced): data structures, OOP, modular application design, package/dependency management

• Strong SQL skills — writing and optimizing queries, joins, aggregations against relational databases

• Experience with SQL Server specifically, or strong ability to ramp up quickly on it

• Familiarity with database connector libraries (e.g., pymssql, pyodbc, or similar)

• Working knowledge of version control (Git) and collaborative development workflows (branching, pull requests, code review)

• Understanding of configuration-driven architecture — separating config/parameters from execution logic

• Ability to read, debug, and extend an existing modular codebase without a full rewrite

• Ability to translate ambiguous business rules into deterministic logic

• Understanding of basic statistical/forecasting concepts (moving averages, weighted blending, classification-based modeling)

• Basic understanding of data validation and error handling in pipelines that feed business-critical outputs

Preferred Qualifications

A strong candidate in this position would demonstrate the preferred qualities:

• Experience in manufacturing, supply chain, or aerospace/defense environments

• Familiarity with time-series forecasting or statistical modeling concepts

• Experience with pymssql or similar database connector libraries

• Exposure to SIOP/S&OP, demand planning, or inventory optimization concepts

• Experience building internal tools for non-technical business users

• Familiarity with Excel automation/export (openpyxl, xlsxwriter, etc.)

• Experience presenting technical work to non-technical stakeholders

• Familiarity with anomaly detection techniques or libraries

• Experience with up-to-date and emerging machine learning / AI integration technologies and techniques 

Success Metrics

A successful candidate would demonstrate the following success metrics in their first 6-12 months:

• Demonstrated ownership of at least one module in the demand planning stack (e.g., anomaly detector, line-of-balance optimizer)

• Reduced manual intervention/debugging time on existing pipelines

• Contributes to system documentation and onboarding materials

• Build trust with planning stakeholders through reliable, well-tested releases

Physical Demands

The Software Developer will have to spend long hours sitting and using office equipment and computers, which can cause muscle strain, eye strain. 

Work Environment

The work environment characteristics described here are representative of those the employee encounters while performing the functions of this job.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is frequently exposed to an office environment and rarely a manufacturing environment.  

Safety and Policy Practices

The employee in this job must be knowledgeable in regard to the safety policies and procedures of the Company as described in the Company safety manual.  The employee must adhere to all said policies and procedures while supporting the goals and objectives of the organization and recognize the Company’s need to achieve its business objective.  Employee is responsible for complying with company hazardous waste disposal procedures.