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 vario