Purpose: Support crew planning & manpower planning teams with daily/weekly/monthly analysis for constructive roster through pre-assignment, published & actual analysis, ownership of standby planning & utilization, maintain robust short term planning variances, own and manage reporting on various KPIs. Work on Automation/SQL/Power BI dashboard/MIS/Analytics (incl. Stats) to improve OCC function.

Knowledge, Skills, Other Abilities: -

Qualification : Graduate – Any

Experience : Minimum 2-5 years of experience in Analysis / BI / Operations Support

Skillset : Hands on experience on Advanced Excel / Project Management / Business Analytics / Power BI / SQL

Responsibilities

• Designing, developing and maintaining business intelligence solutions
• Generate and distribute management reports in accurate and timely manner
• Analyse current and past trends in key performance indicators including all areas of planning, Scheduling, actuals
• Monitor performance indicators, highlighting trends and analysing causes of unexpected variance




• Proactively bringing issues and problems to the attention of the team; generating, proposing and implementing creative solutions as resolutions to any problems and issues.
• Oversee and manage the continued development of Budgeting, KPI Forecasting, Operating Plan and Modelling tools
• Quarterly and Monthly Presentations
• Analyse complex schedule & planning information and reports to provide accurate and timely recommendations to management for decision making purposes
• Study and analyse information about alternative courses of action to determine which plan will offer the best outcomes to cost, efficiency and feasibility to business.
• Define data requirements, gather & validate information, apply judgment & statistical tests.
• Close tracking of planned vs. actual & water tight gap to goal analysis both for cockpit & cabin
• Presenting information through reports and visualization
• Translate business needs to technical specifications

📌 Executive- Analytics (Gurugram)
🏢 IndiGo (InterGlobe Aviation
📍 Gurugram