Software Engineer - Demand Planning

Acutec Precision Aerospace•Meadville, PA

About The Position

The Software Engineer is responsible for building, debugging, testing, deploying, enhancing, maintaining, and documenting planning applications built on the data science stack (Python, R, and SQL) and standard web technologies. The role supports SIOP and other cross-functional projects, including management of company-critical applications such as the Demand Planning Monorepo. The engineer works with business and technical stakeholders to meet customer and system requirements and to develop reliable, well-tested applications. The position combines software development with statistical analysis and business reporting. Responsibilities include analyzing data, identifying patterns, building basic analytical models, writing SQL queries, and developing dashboards, charts, and reports. The engineer collaborates with Operations, Finance, Supply Chain, Sales, CI, and IT to understand data needs and deliver actionable insights, while also conducting industry and market research and supporting operational and strategic analyses. The successful candidate writes clean, documented, testable code; uses configuration-driven architecture to separate configuration from execution logic; and participates in code review, testing, and documentation practices. A working understanding of company operations, particularly demand planning, SIOP processes, and manufacturing data flows, is necessary. The role is primarily in an office environment, with rare exposure to a manufacturing environment, and involves extended periods of sitting and computer use.

Requirements

Bachelor’s degree in management information systems, computer science, or a related field, or equivalent practical experience.
At least 2 years of software development experience, ideally on complex, UI-intensive applications, or an equivalent combination of education and experience.
Working understanding of company operations, especially demand planning, SIOP processes, and manufacturing data flows.
Working knowledge of the latest Visual Studio releases.
Intermediate-to-advanced Python proficiency, including data structures, object-oriented programming, modular application design, and package and dependency management.
Strong SQL skills, including writing and optimizing queries, joins, and aggregations against relational databases.
Experience with SQL Server or strong ability to ramp up quickly on it.
Familiarity with database connector libraries such as pymssql, pyodbc, or similar.
Working knowledge of Git and collaborative development workflows, including branching, pull requests, and code review.
Understanding of configuration-driven architecture and separating configuration or 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 and forecasting concepts, including moving averages, weighted blending, and classification-based modeling.
Basic understanding of data validation and error handling in pipelines that feed business-critical outputs.

Nice To Haves

Experience in manufacturing, supply chain, or aerospace and 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 tools such as openpyxl or xlsxwriter.
Experience presenting technical work to non-technical stakeholders.
Familiarity with anomaly detection techniques or libraries.
Experience with up-to-date and emerging machine learning and AI integration technologies and techniques.

Responsibilities

Build, debug, test, and deploy applications that meet system analysis and customer requirements.
Develop, enhance, maintain, document, and test software systems supporting SIOP and cross-functional projects.
Manage company-critical applications, including the Demand Planning Monorepo.
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 Operations, Finance, Supply Chain, Sales, CI, and IT to understand data needs and deliver actionable insights.
Conduct independent industry and market research and report on trends, potential disruptions, and growth opportunities.
Support ad hoc analyses that inform operational execution and strategic decision-making.
Write clean, well-documented, testable code using configuration-driven architecture.
Participate in code review, testing, and documentation practices to help keep systems maintainable as they scale.
Use software design patterns when useful and appropriate, and stay current with web technologies and development platforms.
Maintain professionalism in contact with employees, suppliers, and customers.
Follow company safety policies and procedures, including hazardous waste disposal procedures.
Perform other duties as directed by the Supervisor.