Lead Analyst

IndiGo (InterGlobe Aviation Ltd); Gurugram District; On-site; INR 1,800,000 - 2,800,000; Full time

Job summary

IndiGo (InterGlobe Aviation Ltd) is seeking a data‑driven resource planner to own end‑to‑end workforce planning and analytics. You will model scenarios, validate assumptions and deliver actionable insights for leadership.

Expect hands‑on use of Python, SQL and Power BI to automate reporting and build dashboards. The role emphasizes stakeholder collaboration with Operations, HR and Finance, and requires exposure to forecasting and capacity planning in a 24x7 setting.

Qualifications

• 3–8 years of experience, including 1–2 years in resource planning or capacity planning.
• Airline/aviation/logistics or 24x7 operations experience preferred.
• Graduate degree as listed in education section.

Responsibilities

• Resource planning, forecasting and analytics to align with fleet and network plans.
• Own data requirements, build dashboards and automate recurring reports using Excel/SQL/Python/Power BI.
• Stakeholder partnership with Operations, HR and Finance; present leadership-ready recommendations.

Skills

Excel

SQL

Python

Power BI

Forecasting

Statistics

Scenario Modelling

Education

Graduate in Statistics/Math/Economics/Engineering/OR/Data Science

MBA preferred

Job description

Plan the right workforce, at the right place and time, at the right cost. The role owns end-to-end resource planning and analytics for operational workforce, turning data into clear, decision-ready insights for leadership. As an individual contributor, the role combines deep planning expertise with hands‑on use of Python, SQL and Power BI to build models, automate reporting and solve business problems.

• Advanced Excel, SQL, Python and Power BI.
• Forecasting, statistics and scenario modelling.
• Strong analytical thinking and practical problem solving.
• Create SOPs for planning processes and BRDs for automation and system requirements
• Independent ownership, stakeholder management and clear communication.

Qualification & Experience

• Graduate in Statistics, Mathematics, Economics, Engineering, Operations Research or Data Science; post‑graduation/MBA preferred.
• 3-8 years of experience, including 1-2 years in resource planning, workforce management (preferred) or capacity planning.
• Airline, aviation, logistics or other 24x7 operations experience preferred.

Key Responsibilities

1. Resource Planning, Forecasting & Analytics

• Own and validate planning assumptions, including productivity, attrition, leave, training, and fleet plan.
• Deliver short-, medium- and long‑term workforce requirements aligned to the fleet and network plan.
• Monitor capacity and highlight gaps early and recommend workforce actions.
• Review plan versus actuals, explain variances and refine assumptions.
• Build analytical and simulation models to evaluate operational scenarios, cost‑benefit trade‑offs and improvement opportunities.
• Define and validate data requirements, analyse operational trends and recommend the best operational and financial outcome.
• Document assumptions, methodology and changes to maintain transparency and governance.
• Use Excel, SQL, Python and Power BI to analyse data, build dashboards and automate recurring processes.
• Improve data quality, planning accuracy and reporting turnaround time.

3. Stakeholder & Decision Support

• Partners with Operations, HR, Finance and other teams to align assumptions and planning requirements.
• Present complex analysis as simple, leadership‑ready recommendations and support implementation.