May 6, 2021
08-67-39
Company Description
Porter Airlines has revolutionized short-haul flying with a warm and effortless approach to hospitality, restoring glamour and refinement to air travel. Porter is an Official 4 Star Airline® in the World Airline Star Rating®.
The airline currently offers flights to Toronto, Ottawa, Montreal, Quebec City, Fredericton, Saint John, Moncton, Halifax, St. John’s, Stephenville, N.L, Thunder Bay, Sault Ste. Marie, Sudbury, Timmins, Windsor, New York (Newark), Chicago (Midway), Boston and Washington (Dulles), and has seasonal flights to Mt. Tremblant, Que., Muskoka, Ont., and Myrtle Beach, S.C.
Job Description
Reporting to the Manager, Business Intelligence, the Business Intelligence (BI) Analyst will play a key role in the expansion of Porter’s Business Intelligence (BI) capabilities. Our team’s goal is to ensure business units within the organization have access to the data they need to make informed and insightful decisions. We are looking for someone who has a strong analytical ability, likes to be inquisitive, and is passionate about data analytics and reporting.DUTIES AND RESPONSIBILITIES:
- Prototype, develop and support company-wide analytics and dashboards using Tableau
- Design SQL queries that sift through large amount of data in the data warehouse to extract critical information that meet business needs
- Work closely with stakeholders from multiple teams (technical and non-technical) in solving ambiguous problems through defining requirements, developing KPIs, and articulating solutions
- Validate data quality and look for ways to automate recurring processes
- Train and provide support for users on business intelligence products
- Proactively explore the data and identify opportunities for improvement
- Actively participate in Porter’s Safety Management System (SMS) including reporting hazards and incidents encountered in daily operations; understand, comply and promote The Company Safety Policy
- Concern for Safety: Identifying hazardous or potentially hazardous situations and taking appropriate action to maintain a safe environment for self and others.
- Teamwork: Working collaboratively with others to achieve organizational goals.
- Passenger/Customer Service: Providing service excellence to internal and/or external customers (passengers).
- Initiative: Dealing with situations and issues proactively and persistently, seizing opportunities that arise.
- Results Focus: Focusing efforts on achieving high-quality results consistent with the organization’s standards.
- Fostering Communication: Listening and communicating openly, honestly, and respectfully with different audiences, promoting dialogue and building consensus.
- Concern for Safety: Identifying hazardous or potentially hazardous situations and taking appropriate action to maintain a safe environment for self and others.
QUALIFICATIONS:
- 1+ years’ of experience in data analytics and/or business intelligence
- Bachelor’s degree in technology or related business fields
- Possess strong working knowledge of SQL to query and analyze large datasets
- Experience in creating intuitive data visualizations in Tableau
- Ability to wrangle data programmatically (using Python or equivalent) is preferred
- Able to convey complex ideas to a diverse audience
- Highly proactive, possess advanced problem-solving ability and critical thinking skills
LOCATION: Billy Bishop Toronto City Airport (YTZ)
