Acute Precision Aerospace Inc is seeking a Software Engineer to build and support demand planning applications on-site in Meadville, PA. The role focuses on developing analytical tools, maintaining critical systems, and partnering with cross-functional teams to turn operational data into actionable reporting and models.
Role Overview
In this position, you will build, debug, test, and deploy demand planning applications using Python, R, and SQL, along with standard web technologies. You will collaborate with stakeholders across Operations, Finance, Supply Chain, and Sales to deliver insights through dashboards, reports, and analytical models.
Key Responsibilities
- Maintain professionalism during direct contact with employees, suppliers, and customers via telephone, facsimile, telex, email, written correspondence, and supplier visits.
- Develop, 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.
- Create 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, including trends, potential disruptions, and growth opportunities.
- Support ad hoc analyses that inform operational execution and strategic decision-making.
- Apply software design patterns where useful and appropriate.
- Stay current with the latest web technologies and development platforms.
- Perform development, enhancement, maintenance, documentation, and testing of software systems supporting SIOP and other cross-functional projects.
- Collaborate between Sales, Operations, CI, and IT.
- Help manage company critical applications, including the Demand Planning Monorepo.
- Write clean, well-documented, testable code using separation of configuration and execution logic via a config-driven architecture. Participate in code review, testing, and documentation to support maintainability as the system scales.
- Carry out other duties as directed by the Supervisor.
Required Qualifications
- 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.
- 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 or dependency management.
- Strong SQL skills, including writing and optimizing queries, joins, and aggregations against relational databases.
- Experience with SQL Server, or ability to ramp up quickly.
- Familiarity with database connector libraries such as pymssql or pyodbc (or similar).
- Working knowledge of version control with Git and collaborative workflows (branching, pull requests, code review).
- Understanding of configuration-driven architecture, separating config 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.
Preferred Qualifications
- Experience in manufacturing, supply chain, or aerospace or 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 and export (openpyxl, 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 or AI integration technologies and techniques.
Technologies
- Python, R, SQL
- Visual Studio
- SQL Server
- pymssql, pyodbc
- Git
- Excel automation and export (openpyxl, xlsxwriter)
- Data Science Stack
- Web technologies
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.
- Contributed to system documentation and onboarding materials.
- Built trust with planning stakeholders through reliable, well-tested releases.
Work Location and Schedule Context
Meadville, PA (onsite).
The employee is frequently exposed to an office environment and rarely a manufacturing environment.
Physical Demands
Long hours sitting and using office equipment and computers may cause muscle strain and eye strain.
Safety and Policy Practices
- Knowledgeable in Company safety policies and procedures as described in the Company safety manual.
- Adherence to policies and procedures while supporting organizational goals and business objectives.
- Compliance with Company hazardous waste disposal procedures.
