Sr. Executive-Comm Planning & Analysis

Date: 21-Sep-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)
  • VBA (Visual Basic Application)
  • SQL (Structure Query Language)
  • Power-BI
  • Power-BI - App & Automation
  • Python – Analytic Part
  • MS Office (Word, PowerPoint)
  • Google Sheets

Work Experience

  • 4 to 5 years of experience in data analytics profile


  • Post-Graduation / MBA from a recognized university




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