Assistant Manager- Resource Planning & Analytics

Role & responsibilities Business Intelligence Development : Design, build, and maintain robust BI solutions that support operational and strategic decision-making. Ensure these tools are scalable, user-friendly, and aligned with business goals. Reporting & MIS : Generate and distribute accurate, timely, and insightful management reports. These reports should reflect key metrics and trends across planning, scheduling, and actual performance. Trend & Variance Analysis : Continuously monitor key performance indicators (KPIs), identify trends, and investigate the root causes of any unexpected variances. Provide actionable insights to improve planning accuracy and operational efficiency. Problem Solving & Innovation : Proactively identify issues in planning and analytics processes. Collaborate with stakeholders to propose and implement innovative, data-driven solutions that enhance performance and reduce inefficiencies. Forecasting & Budgeting Tools : Lead the development and refinement of tools for budgeting, forecasting, and KPI modeling. Ensure these tools are accurate, dynamic, and support scenario planning. Executive Presentations : Prepare and deliver comprehensive presentations for quarterly and monthly reviews. These should clearly communicate performance insights, challenges, and recommendations to senior leadership. Schedule & Planning Analysis : Analyze complex crew scheduling and planning data to provide timely, data-backed recommendations. Support decision-making with clear, concise insights. Strategic Planning Support : Evaluate alternative planning strategies by analyzing cost, efficiency, and feasibility. Recommend the most effective course of action based on data analysis. Data Validation & Statistical Testing : Define data requirements, gather and validate information, and apply appropriate statistical methods to ensure data integrity and reliability. Gap-to-Goal Analysis : Closely track planned vs. actual performance for both cockpit and cabin crew. Identify gaps and develop strategies to bridge them effectively. Data Visualization & Dashboards : Create intelligent, interactive dashboards using Power BI. Present complex data in a visually compelling and easy-to-understand format for various stakeholders. Technical Translation : Translate business requirements into technical specifications. Develop solutions using SQL, Power BI, and MS Access to meet reporting and analytics needs. Cross-Functional Collaboration : Work closely with other teams to integrate systems and ensure seamless data flow and reporting across departments. Preferred candidate profile Experience : 5-10 years in Analysis / BI / Operations Support Skills : Advanced Excel Project Management Business Analytics Power BI SQL