Astronics Connectivity Systems and Certification (formerly Telefonix PDT and Astronics Armstrong Aerospace) serves as the experienced, global market leader for in-flight entertainment and connectivity (IFEC) solutions for aircraft. As a systems certification provider, Astronics CSC has worked on over 100 projects for industry partners to upgrade commercial and business aircraft with new passenger power systems, IFEC navigation, communication and flight safety systems. Additionally, Astronics CSC offers proven IFEC hardware systems, flexible design platforms, high customer satisfaction, and long-term relationships with industry leaders to help make the connected aircraft a reality. The company now employs over 300 employees and is a six-time recipient of Chicago's Best and Brightest Employers to Work For award.
Summary
The Sr Data Analyst supports the PMO by turning structured and unstructured data into actionable insights that drive program decision-making.
This position will be responsible for collecting, analyzing, interpreting, and presenting operational, financial, supply chain, and customer performance data to support business decisions, improve operational efficiency, and proactively identify risks affecting customer commitments.
The ideal candidate will possess strong analytical and problem-solving skills, with the ability to translate complex data from multiple business systems into actionable insights, meaningful performance metrics, and management dashboards.
A key focus of this role is to move beyond traditional reporting and provide forward-looking analysis, particularly in identifying customer orders at risk of late delivery due to supplier constraints, material shortages, manufacturing delays, regulatory approvals, and other operational challenges.
The Data Analyst will collaborate closely with Program Management, Supply Chain, Manufacturing, Finance, Quality, Customer Service, and the Sales, Inventory & Operations Planning (SIOP) Manager to improve visibility, accountability, and business performance.
Essential Duties and Responsibilities
The essential duties and responsibilities include the following, other duties as may be required from time-to-time.
Operational Performance Metrics & KPI Management
- Develop, maintain, and continuously improve operational dashboards and key performance indicators (KPIs).
- Monitor and analyze key performance metrics, including:
- Customer on-time delivery (OTD)
- Supplier on-time delivery and delivery commitments
- Shipping accuracy
- Customer order entry accuracy
- Customer satisfaction and complaints
- Manufacturing schedule adherence
- Order backlog and past-due orders
- Repair turnaround time (TAT)
- Product quality, defects, and field failure trends
- Inventory accuracy, aging, and turnover
- Program profitability and gross margins
- Identify performance trends, recurring issues, and improvement opportunities.
- Prepare weekly, monthly, and quarterly performance reports for management reviews.
- Establish standardized KPI definitions, calculation methodologies, and reporting practices.
Open Order Analysis & Delivery Risk Management
- Analyze customer sales orders, open order backlog, production schedules, inventory availability, and supplier commitments to identify potential delivery risks.
- Develop and maintain an Open Order Risk Dashboard that provides visibility into customer orders at risk of missing contractual delivery commitments.
- Correlate customer-requested delivery dates with:
- Supplier purchase order commitments and expected receipt dates
- Material availability and shortages
- Manufacturing lead times and production schedules
- Engineering and quality holds
- Regulatory approval milestones, including PMA approval dates where applicable
- Customer-specific delivery and documentation requirements
- Identify discrepancies between customer delivery requirements and material or production readiness.
- Highlight critical exceptions, delivery gaps, and potential schedule conflicts.
- Develop risk indicators and exception reports that categorize orders by severity, such as high, medium, and low delivery risk.
- Support Program Managers and Supply Chain in prioritizing mitigation actions and expediting activities.
- Track changes in supplier commitments and evaluate their downstream impact on customer deliveries.
- Provide forward-looking delivery projections and early-warning indicators to minimize late shipments.
Supply Chain & Supplier Performance Analytics
- Monitor supplier performance, including on-time delivery, lead-time reliability, quality trends, and commitment accuracy.
- Analyze purchase order schedules, supplier acknowledgments, and revised delivery commitments.
- Identify suppliers and components contributing to delivery risks and production disruptions.
- Evaluate supplier lead-time variability and its impact on customer order fulfillment.
- Support Supply Chain in identifying recurring supplier performance issues and opportunities for improvement.
- Develop supplier scorecards and exception-based reporting.
Financial Performance, Cost & Profitability Analysis
- Partner with Finance and Program Management to monitor product and program financial performance.
- Analyze actual product costs against standard costs, budgets, and planned margins.
- Track gross margin performance by product, customer, and program.
- Identify cost variances, margin erosion, and unfavorable profitability trends.
- Analyze material cost increases, manufacturing costs, and repair costs.
- Support profitability analysis for production and aftermarket service programs.
- Develop financial dashboards to provide visibility into cost performance and improvement opportunities.
Inventory Analytics & SIOP Support
- Collaborate with the SIOP Manager to support the Sales, Inventory & Operations Planning process.
- Analyze inventory levels, demand forecasts, sales backlog, and material availability.
- Support demand and supply reconciliation by identifying gaps between customer requirements, available inventory, and supplier capacity.
- Monitor excess, obsolete, slow-moving, and aging inventory.
- Evaluate inventory turnover, days of supply, and inventory exposure.
- Provide analytical support for inventory optimization and working capital improvement initiatives.
- Support scenario modeling to assess the impact of demand changes, supplier delays, and production constraints.
- Prepare data and analysis for monthly SIOP reviews and management decision-making.
Aftermarket Services & Repair Performance Analytics
- Monitor repair turnaround time and performance against customer commitments.
- Analyze repair backlog, aging work orders, and overdue repairs.
- Identify bottlenecks in the repair process, including material shortages, testing constraints, and capacity limitations.
- Analyze repair costs, profitability, and recurring failure trends.
- Support the Aftermarket Services team in improving repair efficiency and customer satisfaction.
- Develop dashboards to monitor repair performance and service-level commitments.
Information Architecture & Continuous Improvement
- Partner with Data Management Specialist to design, implement, and maintain the information architecture across Sharepoint, Microsoft Teams, network drives, and other collaboration platforms to ensure the information is intuitive, organized, and easily accessible.
- Contribute to process improvements related to data collection, reporting cadence, and analytical rigor across the PMO.
- Support the implementation and continuous improvement of Sharepoint, Microsoft Teams, Power BI, and other digital collaboration tools to improve organizational effectiveness.
Qualifications
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.
Required:
- Bachelor's degree in Data Analytics, Business Analytics, Supply Chain Management, Industrial Engineering, Finance, Operations Management, or a related field (or equivalent experience).
- 5+ years of experience in data analysis, business intelligence, or a related analytical role.
- Proficiency with SQL and at least one data visualization tool (Power BI, Tableau, Qlik, etc.).
- Experience working with manufacturing, supply chain, operations, or ERP data.
- Advanced proficiency in Microsoft Excel, including PivotTables, Power Query, complex formulas, and data modeling.
- Experience developing dashboards and reports using Microsoft Power BI or a comparable business intelligence tool.
- Working knowledge of SQL for extracting, joining, and analyzing data.
- Strong analytical and problem-solving skills with the ability to identify trends, anomalies, and operational risks.
- Understanding of key operational metrics such as on-time delivery, inventory turnover, supplier performance, and profitability.
- Ability to consolidate and reconcile data from multiple sources.
- Strong communication and presentation skills, including the ability to translate analytical findings into actionable recommendations.
- Ability to work independently and collaborate effectively with cross-functional teams in a remote or hybrid environment.
Work Environment
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Personal Protective Equipment may be required when working in designated areas. The noise level in the work environment is moderate.
Compensation & Benefits:
- Base salary: $110,000 - $115,000, influenced by several factors including experience, skill set, education, certifications, market conditions, and business needs. . In addition, you will be eligible for our Quarterly Incentive compensation bonus.
- This position may involve access to items subject to U.S. export-control laws. Employment is contingent upon the employee’s authorization to access such items under applicable law. The company does not guarantee and is under no obligation to seek such authorization if it would be necessary.
Astronics CSC provides a comprehensive benefits package available to full-time employees, with part-time employees potentially eligible for these benefits on a pro-rated basis.
- Stay Healthy – Health, dental, vision, disability, life insurance, FSA, HSA, as well as voluntary life/AD&D, voluntary critical illness, accident prevention and hospital indemnity.
- Save for the Future – 401K, Profit Sharing & Employee Stock Purchase Plan
- The Astronics Corporation Profit Sharing/ 401(k) Plan is a “safe harbor” plan. Under the plan, Astronics has committed to contribute 3% of your eligible wages, with the ability to do an annual discretionary adder on top.
- Find Balance – Employee Assistance Program & Wellness Program
- Time for You – Generous Paid Time Off (PTOS), Volunteer Time Off Program (VTO), Paid Holidays and Paid Parental Leave.
- Professional Growth - Tuition Reimbursement Program.
Astronics Corporation (Nasdaq: ATRO) serves the world's aerospace, defense, and other mission critical industries with proven, innovative technology solutions. Astronics works side-by-side with customers, integrating its array of power, connectivity, lighting, structures, interiors, and test technologies to solve complex challenges. For over 50 years, Astronics has delivered creative, customer-focused solutions with exceptional responsiveness. Today, global airframe manufacturers, airlines, militaries, completion centers and Fortune 500 companies rely on the collaborative spirit and innovation of Astronics. The Company's strategy is to increase its value by developing technologies and capabilities that provide innovative solutions to its targeted markets.
For more information on Astronics and its solutions, visit www.Astronics.com.
All qualified applicants will receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity, religion, national origin, disability, veteran status, or other legally protected status.