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.