Consultant, Airline and Airports

At Inter

VISTAS Consulting Inc., we lead the way in specialized consulting services, focusing in aviation, transportation, and tourism. With offices in Canada, the United States, and the UK, we’ve successfully delivered projects to over 500 clients in over 70 countries worldwide. We are an energetic team of top-caliber professionals dedicated to making a difference.

We are seeking a Consultant, Airline and Airports to support our Airlines, Air Service Development and Aviation Policy consulting practice, to provide analytical expertise supporting our airline and airport clients, including network planning, market demand analysis and forecasting, and schedule analysis. Inter

VISTAS’ clients are airports, airlines, trade associations and investors seeking to understand, stay ahead of, and capitalize on the latest challenges and opportunities confronting the aviation industry.

In this role, you will develop leading-edge analytics, reports, tools, and data-driven insights that underpin transformational airline network planning and analysis, revenue management, and air service development projects. Your deep quantitative analytical expertise will be relied upon by senior aviation executives across the industry. Additionally, you will have the opportunity to assist with business development, including proposals, client engagement, and product development.

Location of role will be US/Canada Remote or Washington, DC, Toronto, ON, or Vancouver, BC

Here’s what you MUST bring:

• Undergraduate or Graduate degree in economics, business, commerce, statistics, transportation, and/or mathematics. Candidates with a degree in other disciplines with substantial quantitative and data analysis experience will be considered.
• At least 5 years’ experience required in an airline commercial function, air service development, or management consulting role in the aviation, travel or transportation industries
• Demonstrated experience in airline network / revenue management data sources and modeling tools, including QSI, schedules, and demand data (e.g., US DOT Data Sources).
• Familiarity in airline route profitability systems, airline inventory management and/or pricing background, and/or understanding of airline fleet assignment principles
• Very strong quantitative analytical capabilities, a passion for large data sets, and a data-centered approach to problem solving
• Experience with Excel modeling required, and Alteryx experience is highly preferred. VBA, SQL, Python, and/or statistics software, as well as using business intelligence platforms (e.g., Tableau, Power BI) for data analysis, aggregation, and visualization desired.
• Strong writing and presentation creation skills that include report writing and developing captivating presentations
• Passion for assessing and answering the “so what” from the analysis of large data sets and complex quantitative, iterative analysis
• An entrepreneurial spirit and willingness to take on new challenges
• Willingness and availability to travel up to 30%, as required by business need
• Ability to work collaboratively in a remote work environment, as part of a cohesive team

• Strong interest in and knowledge of the airline and aviation industry, preferably including key airline competitors by region, and airline network commercial principles
• Airline/aviation policy interest, and familiarity with current industry topics
• Ability to translate airport, airline, and client positions into clear analysis
• Develop market analysis, route forecasts, passenger choice models, catchment areaanalyses,and network designtomaximizefinancial return forclientairlinesand airports
• Perform airport route studies todeterminethe strategic and financial viability foradditionalair services
• Lead market analysis and feasibility studies for start-up carriers
• Provideairline revenue modellingexpertiseand develop models that account for passenger and non-passenger revenues, as well as direct and indirect costs
• Develop business plans for airline turnaroundandstart-up projects
• Develop pro-forma financial statements for airlines
• Develop aviation and route…