Sql analyst h1.location_city

Purpose of Position

This position is responsible for overseeing the alignment of supply and demand within FlightSafety International manufacturing/engineering operations by coordinating cross-functional teams to ensure production, inventory, and sales forecasts are optimized for efficiency and cost-effectiveness in accordance with strategic goals. Responsible for developing strategic insight through the development, maintenance, analysis, and reporting of accurate, timely, and integrated demand, supply, inventory, capacity, and production backlog and forecast.

The SIOP Analyst supports alignment between demand forecasts, inventory levels, and production plans while providing analytical insight to Product Control, Supply Chain, Manufacturing, Engineering, Program Management, and Finance. This role ensures reliable information is available for operational execution, capacity planning, and forward-looking decision-making/forecasting.

Tasks and Responsibilities

SIOP Planning & Analysis

• Collaborate with Civil Ops, Commercial, and Defense to ensure that current backlog and new product forecasts are included in the aggregate demand.
• Develop, maintain, and analyze demand forecasts using historical data, operational inputs, and business assumptions.
• Review and analyze the forecast demand versus actual demand, understanding changes and trends.
• Analyze and upload timely and accurate periods of 18 months’ forecast on a monthly basis and quarterly out to 5 years.
• Develop capacity simulation processes to run sensitivity analysis for growth.
• Facilitate monthly demand forecast aggregation, including consensus between functions and stakeholders.
• Notify Scheduling and Manufacturing of significant forecast or capacity changes on a timely basis.
• Assist in the resolution of key supply-demand/service-cost issues.
• Gather, consolidate, validate, and analyze data to support inventory control, purchasing, planning, manufacturing, and project execution.
• Assist with the coordination, facilitation, and documentation of regularly scheduled planning meetings.
• Participate in the development of statistical models to optimize safety stocks without negatively affecting customer service levels.
• Ensure consistency of definitions, calculations, and data sources across operational and planning reports.
• Measure, control, and improve S&OP plan accuracy through clearly defined metrics such as, but not limited to, forecast accuracy, inventory turnover, schedule adherence, and service levels.

Minimum Education

• Bachelor’s degree in Supply Chain Management, Business, Operations Management, or other technical/engineering discipline preferred.

Minimum Experience

• 10 years of experience in Supply Chain (Demand Planning, Supply Planning, and Inventory Planning in an environment of both manufactured and sourced finished goods) and/or related supply chain management including design, implementation, and execution of SIOP related processes preferred.

Knowledge, Skills, Abilities

Technical Skills:

• Understanding of Sales, Inventory, and Operations Planning concepts and integrated supply chain processes.
• Knowledge of manufacturing operations, material flow, procurement, and inventory management principles.
• Demonstrated understanding of financial systems and the key drivers within the manufacturing environment.
• Expertise with forecasting methods, planning logic, and performance measurement.
• Proficiency in Excel and common business tools (e.g., PowerPoint, ERP systems, reporting platforms).

Other Skills:

• Strong intellectual curiosity.
• Strategic and tactical thinking.
• Communication (both oral and written).
• Interpersonal strengths.
• Strong organizational skills in strategy, communication at all levels and execution.
• Strong leadership skills. Ability to lead, contribute, and influence others in a team-based organization.
• Excellent people skills, project management skills, with an ability to openly convey information to team members in a timely, concise manner.
• Strong analytical and problem-solving skills with ability to interpret complex operational data.
• Experience with multiple support platforms, including but not limited to planning systems (MRP/ERP), data visualization tools, obsolescence tools, and statistical forecasting methods.

Physical Demands and Work Environment

The physical demands and work environment described here are representative of those that must be met and/or encountered by an employee to successfully perform the essential 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 regularly required to sit. The employee is frequently required to use hands to finger, handle, or feel; reach with hands and arms and talk or hear. The employee is occasionally required to stand; walk; climb or balance and stoop, kneel, crouch, or crawl.

The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, depth perception and ability to adjust focus.

While performing the duties of this Job, the employee is occasionally exposed to moving mechanical parts. The noise level in the work environment is usually moderate.