Executive - Comm. Planning & Analysis

Date: 29-Jun-2022

Location: Gurgaon

Company: TATA SIA Airlines Limited

Job Overview

The role involves analysis, report generation, process enforcement and modelling for Commercial Planning and Analysis team, with the objective of process improvement and revenue optimization.


Key Responsibilities

  • Reporting: Aid in the development / generation of ad-hoc and regular reports
  • Analysis: Analyze performance and processes on an ad-hoc and regular basis
  • Modelling: Building financial models / tools of processes and/or phenomena to help with optimization and forecasting.
  • Oversight: Conduct audits for Commercial Planning and Analysis team
  • Revenue Analysis: Prepare daily, weekly, monthly and quarterly revenue analysis
  • KPI Reporting: Prepare commercial reports and monitor department targets (sales targets, revenue targets, loyalty enrollments, customer satisfaction etc.)
  • Competitor Analysis: Regular benchmarking against competition

Skills / Attributes

  • Advanced MS Excel (Building models in Excel)
  • MS Office (Word, PowerPoint)
  • Google Sheets
  • SQL
  • VBA (Macro)
  • Power BI/ Tableau/ Other Data Visualization Tool 
  • Good EQ
  • Excellent written and oral communication skills in English
  • General understanding of aviation.
  • Strong analytical and problem-solving skills

Work Experience

  • 0-2 years of experience


  • Graduation from a recognized university




All Vistara employees are required to be fully vaccinated against COVID-19.