Software Engineer - Demand Planning

At Acutec Precision Aerospace Inc, this onsite Software Engineer role supports demand planning by building, enhancing, and maintaining planning applications that turn operational data into actionable insights. You will work closely with cross-functional teams to deliver reliable functionality through dashboards, reports, and analytical models, while maintaining maintainable, testable software as the system scales.

This position is based in Meadville, PA and requires a minimum of 2 years of software development experience. The work involves hands-on development with Python, R, and SQL, along with standard web technologies and tools such as Visual Studio and Git.

Responsibilities

• Maintain a high level of professionalism during direct contact with employees, suppliers, and customers through telephone, facsimile, telex, e-mail, written correspondence, and supplier visits.
• Build, debug, test, and deploy applications that meet 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 including Operations, Finance, Supply Chain, and Sales to understand data needs and deliver actionable insights.
• Conduct independent industry and market research, reporting trends, potential disruptions, and growth opportunities.
• Support ad hoc analyses that inform operational execution and strategic decision-making.
• Use and adopt software design patterns when useful and appropriate.
• Stay updated with the latest web technologies and development platforms.
• Assist with other duties as directed by the Supervisor.
• Participate in development, enhancement, maintenance, documentation, and testing of software systems supporting SIOP and other cross-functional projects.
• Collaborate between Sales, Operations, CI, and IT.
• Support management of company critical applications, including the Demand Planning Monorepo.
• Write clean, well-documented, testable code following separation of configuration and execution logic (config-driven architecture), and take part in code review, testing, and documentation to keep the system maintainable as it scales.

Requirements

• Bachelor’s degree in management information systems, Computer Science, or a related field (or equivalent practical experience).
• Minimum 2 years of software development experience, ideally involving complex, UI-intensive applications, or an equivalent combination of education and experience.
• Working understanding of company operations, specifically demand planning, SIOP processes, and manufacturing data flows.
• Working knowledge of the latest Visual Studio releases.
• Proficiency in Python (intermediate-to-advanced), including data structures, OOP, modular application design, and package/dependency management.
• Strong SQL skills, including writing and optimizing queries with joins and aggregations against relational databases.
• Experience with SQL Server, or strong ability to ramp up quickly.
• Familiarity with database connector libraries such as pymssql, pyodbc, or similar.
• Working knowledge of version control with 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 including moving averages, weighted blending, and classification-based modeling.
• Basic understanding of data validation and error handling in pipelines that feed business-critical outputs.

Technologies

• Python, R, SQL
• Visual Studio
• SQL Server
• pymssql, pyodbc
• Git
• Excel automation/export (openpyxl, xlsxwriter)
• Data Science Stack
• Web technologies

Preferred Qualifications

• 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

• Demonstrated ownership of at least one module in the demand planning stack (for example, an anomaly detector or line-of-balance optimizer).
• Reduced manual intervention and debugging time on existing pipelines.
• Contributes to system documentation and onboarding materials.
• Builds trust with planning stakeholders through reliable, well-tested releases.

Physical Demands

The role involves spending long hours sitting and using office equipment and computers, which can cause muscle strain and eye strain.

Work Environment

Employees are frequently exposed to an office environment and rarely a manufacturing environment while performing job duties.

Safety and Policy Practices

• Be knowledgeable about the Company safety policies and procedures as described in the Company safety manual.
• Adhere to safety policies and procedures while supporting organizational goals and recognizing the need to achieve business objectives.
• Comply with company hazardous waste disposal procedures.