Senior Developer, Data

Porter Airlines Inc.; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

A leading airline company in Toronto is seeking a Senior Developer, Data to design and implement scalable data integration solutions. The successful candidate will have over 7 years of experience in data engineering and be a key player in improving data quality and analytics. This role offers an opportunity to work within a dynamic, collaborative environment, mentoring fellow developers and contributing to the company’s operational efficiency.

Benefits

Genuine hospitality with style

Opportunities for professional development

Dynamic work environment

Qualifications

• 7+ years of experience in data integration, ETL/ELT development, and data engineering.
• Strong SQL development experience across relational databases.
• Proficiency in Python for scripting and automation.

Responsibilities

• Lead the design and development of data integration pipelines.
• Mentor other developers and contribute to team standards.
• Collaborate with project managers to deliver high-quality results.

Skills

Data integration

ETL/ELT development

SQL development

Python

REST API integration

Data warehouse design

Cloud-based data platforms

Education

Post-secondary degree in Computer Science or related

Tools

SQL Server

Redshift

PostgreSQL

Matillion

Microsoft SSIS

AWS services

Job description

Job Summary

Data is a critical enabler of operational efficiency, performance insights, and growth at Porter. As a Senior Developer, Data, you will lead the design and implementation of scalable, resilient data integration solutions that support analytics, automation, and enterprise systems. You’ll collaborate across teams to eliminate manual processes, improve data quality, and enable data-driven decision-making — all while enjoying the perks of working at one of Canada’s best airlines.

Duties & Responsibilities

• Lead the design and development of robust data integration (ETL/ELT) pipelines across internal and external systems
• Partner with business and technology stakeholders to gather and refine integration requirements
• Recommend architecture patterns, tooling, and strategies aligned with enterprise data needs
• Build and evolve subject areas in the data warehouse and/or data lakehouse to support analytics, reporting, and operational use cases
• Devise and implement solutions to improve data quality, completeness, and consistency across systems
• Evaluate existing data processes and propose enhancements to improve performance, reliability, or maintainability
• Mentor other developers and contribute to the team's standards and best practices in data engineering
• Document data models, integration flows, and technical decisions to support long-term maintainability
• Collaborate with project managers to estimate effort, define timelines, and deliver high-quality results on time
• Prototype and implement solutions for real-time ingestion, big data processing, or AI/ML data pipelines as needed
• Participate in after-hours support rotation for critical systems, when required
• Perform other duties as assigned by the Senior Manager, Development and Delivery
• Actively participate in Porter’s Safety Management System (SMS) including reporting hazards and incidents; understand, comply with, 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

• Post-secondary degree in Computer Science, Engineering, Mathematics, or related discipline
• 7+ years of experience in data integration, ETL/ELT development, and data engineering
• Deep knowledge of data warehouse and data lake/lakehouse design principles
• Strong SQL development experience across relational and columnar databases such as SQL Server, Redshift, PostgreSQL, etc.
• Experience with REST API integration and modern data exchange protocols
• Proficiency in Python for scripting, data transformation, and automation
• Excellent communication skills, with the ability to influence decisions and explain complex concepts to varied audiences
• Experience with cloud-native data platforms and distributed data systems
• Experience gathering requirements and delivering data solutions within Agile or hybrid project environments
• Airline or transportation industry experience is an asset

TECHNICAL SKILLS:

• 7+ years of experience designing and developing data integration (ETL/ELT) processes using tools like Matillion, Microsoft SSIS, or open-source frameworks
• 7+ years of SQL development with platforms such as SQL Server, Redshift, PostgreSQL, etc.
• 5+ years of Python experience for scripting, automation, and API integration
• 3+ years working with RESTful APIs for system integration
• 3+ years of experience with NoSQL databases (e.g., DynamoDB, MongoDB)
• 2+ years building cloud-based data pipelines
• Experience with AWS services such as Redshift, Kinesis, Lambda, EMR, RDS, or similar

Location

250 Yonge Street, Toronto

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.