About the job
Job Description
Job Purpose
To support the Assistant Manager Productivity and 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 Monitor roster stability and highlight disruption trends for proactive action.
Analyze operational data to identify patterns, trends, and actionable insights.
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 Track and analyses standby deployment and utilization 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 and utilization data to identify optimization opportunities.
Monitor productivity trends and flag operational anomalies for review.
Reporting and Dashboard Development Develop and maintain dashboards and reports covering standby utilization, 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 Automate reporting and data processes using Excel, VBA, and Python.
Support operational analytics initiatives and cross-functional data projects.
Stakeholder Communication Prepare and present periodic operational reports and dashboards.
Provide data-driven insights and recommendations to support decision making.
Undertake additional responsibilities and special projects as assigned.
Skills
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 and fairness principles in crew deployment Clear written and verbal communication for stakeholder presentations Attention to detail and data integrity discipline
Education
al and Experience Requirements Minimum Education requirements - Masters or Bachelors degree or related field experience in an airline operational environment Minimum Experience 5 years of experience in regulatory documents and record keeping.
Desired Extensive knowledge of the Cabin crew division