Analyst, Business Intelligence

Porter Airlines Inc.; Toronto; On-site; CAD 85,000 - 110,000; Full time

Job summary

A leading airline in Canada seeks a Business Intelligence Analyst to drive data-informed decision-making across its network. The successful candidate will excel in data analytics and have a passion for the aviation industry, applying both analytical and technical skills to enhance operations.

Qualifications

• 2+ years of experience in data analytics and/or business intelligence.
• Strong working knowledge of SQL and Tableau.
• Excellent communication skills to analyze data and explain insights.

Responsibilities

• Develop, prototype, and maintain analytics and dashboards using Tableau.
• Design and optimize SQL queries from the data warehouse.
• Collaborate with stakeholders to define requirements and develop KPIs.

Skills

Analytical Ability

Problem Solving

Critical Thinking

Communication

Education

Bachelor’s degree in technology, data, or business-related fields

Tools

SQL

Tableau

Python

Job description

Join to apply for the Analyst, Business Intelligence role at Porter Airlines Inc.

Continue with Google Continue with Google

Join to apply for the Analyst, Business Intelligence role at Porter Airlines Inc.

Job Summary

The Business Intelligence (BI) Analyst is central to driving informed decision-making across our growing Porter network. Our team’s mission is to empower business units across the organization with timely, accurate, and actionable data to support strategic and operational decision making. We are looking for someone who has a strong analytical ability, likes to be inquisitive, and is passionate about data analytics and the aviation industry.

Job Summary

The Business Intelligence (BI) Analyst is central to driving informed decision-making across our growing Porter network. Our team’s mission is to empower business units across the organization with timely, accurate, and actionable data to support strategic and operational decision making. We are looking for someone who has a strong analytical ability, likes to be inquisitive, and is passionate about data analytics and the aviation industry.

Duties & Responsibilities

• Develop, prototype and maintain company-wide analytics and dashboards using Tableau.
• Design and optimize SQL queries from the data warehouse to extract critical information that meets business needs.
• Collaborate with stakeholders from multiple teams (technical and nontechnical) in solving ambiguous problems through defining requirements, developing KPIs, and articulating solutions.
• Validate data quality and identify opportunities 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.
  
  

Behavioural Competencies

• 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.
  
  

Qualifications

• 2+ years of experience in data analytics and/or business intelligence.
• Bachelor’s degree in technology, data, or business-related fields.
• Strong working knowledge of SQL for querying and analyzing large datasets.
• Proven ability to build intuitive data visualizations using Tableau or similar tools.
• Previous experience or interest in the aviation industry is an asset.
• Proficiency in Python or equivalent for data wrangling is an asset.
• Excellent communication skills, with the ability to convey complex data insights to technical and non-technical audiences.
• Proactive mindset, with advanced problem-solving and critical thinking skills.
  
  

Location

Toronto Downtown Office (250 Yonge Street)

Company Description

Since 2006, Porter Airlines has been elevating the experience of economy air travel for every passenger, providing genuine hospitality with style, care and charm. Porter’s fleet of Embraer E195-E2 and De Havilland Dash 8-400 aircraft serves a North American network from Eastern Canada. Headquartered in Toronto, Porter is an Official 4 Star Airline in the World Airline Star Rating. Visit www.flyporter.com or follow @porterairlines on Instagram, Facebook and X.

Seniority level

• Seniority level

  Not Applicable

Employment type

• Employment type

  Full-time

Job function

• Job function

  Research, Analyst, and Information Technology

• Industries

  Airlines and Aviation

Referrals increase your chances of interviewing at Porter Airlines Inc. by 2x

Sign in to set job alerts for “Business Intelligence Analyst” roles.

Continue with Google Continue with Google

Continue with Google Continue with Google

Toronto, Ontario, Canada $85,000 - $110,000 2 weeks ago

Business Analyst-Azure data/ datawarehouse

Senior Business Intelligence Analyst (Power Automate / Apps)

Greater Toronto Area, Canada CA$87,596.60 - CA$109,509.40 1 day ago

Senior Analyst, Business Analysis and Insights

Business Analyst (Intermediate) 8733-0611

Senior Business Intelligence Analyst, Business Innovation and Operations Management (Hybrid, Toronto)

Richmond Hill, Ontario, Canada 1 week ago

Business Analyst - Information Technology

Senior Analyst - Marketing Campaign Performance and Analytics

Business Analyst (Intermediate) 8472-1612

Senior Analyst, Business Analysis and Insights

Business Analyst (Intermediate) 8366-1612

Toronto, Ontario, Canada CA$75 - CA$80 2 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.