Senior Associate- CC Productivity

Air India Limited; Gurugram District; On-site; INR 1,500,000 - 2,600,000; Full time

Job summary

Air India Limited invites applications for the role of Assistant Manager – Productivity & DOPS Control to monitor day‑of‑operations crew deployment through data analysis, trend tracking and predictive insight. You will track standby utilisation, roster stability, crew fairness and fatigue indicators to support informed operational decisions.

Key responsibilities include data quality, real-time data integration, dashboard development and stakeholder reporting, leveraging Excel, VBA, Python and

Qualifications

• Master’s or Bachelor’s degree in airline operations or related field.
• 5+ years of experience in regulatory documents and record keeping.
• Extensive knowledge of the Cabin crew division.

Responsibilities

• Collect and validate day-of-operations data from diverse sources to ensure accuracy.
• Integrate real-time data feeds into a centralized dashboard environment.
• Monitor roster stability and fatigue indicators to guide actions.
• Develop dashboards and reports to communicate analytical findings.

Skills

Advanced Excel

VBA

Python

Data mining

Power BI

Rostering system (CAE)

Fatigue analysis

Communication

Attention to detail

Education

Master’s/Bachelor’s degree in airline operations or related field

Tools

CAE rostering system

Job description

To support the Assistant Manager – Productivity & DOPS Control in monitoring day-of-operations crew deployment through data analysis, trend tracking and predictive insight. To track standby utilisation, roster stability, crew fairness and fatigue indicators, and to identify productivity and rationalisation opportunities that support informed operational decision-making.

Key Accountabilities

Data Quality and Integration

• Collect and validate day-of-operations data from diverse sources, ensuring accuracy, completeness and reliability throughout the process.
• Integrate and manage real-time data feeds from multiple sources into a centralised database and dashboard environment for up-to-date analysis.
• Ensure data accuracy, consistency and integrity are maintained throughout the analysis process.

Roster Stability Monitoring

• Track roster stability indicators and flag emerging disruption trends to the Assistant Manager – Productivity & DOPS Control ahead of escalation.
• Apply statistical techniques and data‑mining methods to complex day‑of‑operations datasets to uncover trends, patterns and actionable insight.

Crew Fatigue Monitoring

• Monitor crew fatigue indicators and FDTL‑linked data points, identifying patterns that warrant corrective action.
• Support periodic fatigue risk reviews with data‑driven insight to flag recurring or high‑risk patterns.

Crew Fairness Analysis

• Analyze crew deployment and duty allocation data to identify fairness gaps across standby, flying hours and duty distribution.
• Support periodic fairness reviews with data‑driven insight highlighting deviation from equitable distribution.

Standby Utilization Analysis

To support the Assistant Manager – Productivity & DOPS Control in monitoring day-of-operations crew deployment through data analysis, trend tracking and predictive insight. To track standby utilisation, roster stability, crew fairness and fatigue indicators, and to identify productivity and rationalisation opportunities that support informed operational decision-making.

• Track and analyses standby deployment and utilisation trends across bases, flagging inefficiencies for corrective action.
• Support optimization of standby planning through predictive insight on utilization patterns.

Productivity and Rationalization Analysis

• Analyze crew productivity data, including flying hours, block‑hours distribution and utilisation, to identify rationalization opportunities.
• Predict future productivity trends and flag inducing‑flight and correction‑related anomalies for review.

Reporting and Dashboard Development

• Develop and maintain dashboards and reports covering standby utilisation, roster stability, fairness, fatigue and productivity indicators.
• Develop comprehensive reports and interactive dashboards to effectively communicate analytical findings.
• Redesign template reports to improve work efficiency and enhance insight.

Process Automation

• Leverage advanced Excel, VBA and Python for efficient data organization and process automation.
• Automate recurring reporting processes to reduce manual turnaround and improve team efficiency.
• Support time‑bound day‑of‑operations initiatives that require focused analytical effort to achieve specific objectives and deliver measurable outcomes.
• Support data‑related projects and initiatives across departments as required.

Stakeholder Communication

• Prepare and present detailed weekly and monthly updates to the Assistant Manager – Productivity & DOPS Control and department head using PowerPoint.
• Provide insightful analysis and actionable recommendations to support informed decision‑making.

Skills/Qualities Required

• Advanced Excel and VBA proficiency; working knowledge of Python for data analysis and automation
• Strong statistical and data‑mining ability to identify trends, patterns and operational risk
• Dashboard and reporting tool proficiency (e.g. Power BI or equivalent)
• Working knowledge of CAE (rostering/hosting system) and day‑of‑operations data structures
• Understanding of FDTL regulations and fatigue/fairness principles in crew deployment
• Clear written and verbal communication for stakeholder presentations
• Attention to detail and data‑integrity discipline

Educational and Experience Requirements

• Master’s/Bachelor’s degree and/or related field experience in an airline operational environment
• 5+ years of experience in regulatory documents and record keeping.
• Extensive knowledge of the Cabin crew division