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 cutting-edge 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

Develop solutions on various reporting objects like SQL/Power BI/MS Access as per requirement

Creation of intelligent/smart dashboards in Power BI platform, data mining, handling large data sets

Collaborate with teams to integrate systems

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