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
-