Data Lakehouse Engineer

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

Job summary

A leading airline company in Toronto is looking for a skilled Data Lakehouse Engineer. You will design and implement scalable data architectures, ensuring quality and compliance while collaborating with cross-functional teams to support business intelligence efforts. This role requires a strong background in data engineering and experience with real-time streaming technologies.

Qualifications

• 5+ years of experience in data engineering using SQL, Python, or Scala.
• Hands-on experience with MACH architecture and CRM systems.
• Strong proficiency in data lakehouse technologies.

Responsibilities

• Design and maintain a scalable data lakehouse.
• Collaborate with stakeholders to create data models.
• Ensure data quality and compliance with regulations.

Skills

Data lakehouse storage and query technologies

SQL

Python

Scala

Real-time data streaming technologies

ETL/ELT development

Problem-solving and debugging

Communication skills

Tools

AWS Glue

Matillion

Mulesoft

CRM systems

Customer Data Platforms

Security frameworks

Job description

Job Summary

We are seeking a skilled Data Lakehouse Engineer to design, implement, and optimize our modern data lakehouse architecture—enabling seamless data ingestion, transformation, storage, and analytics. You will be responsible for building scalable, high-performance data pipelines, ensuring data quality and governance, and integrating structured and unstructured data to support business intelligence, AI, and machine learning use cases.

A key focus of this role will be enabling a comprehensive, data-driven view of our customers by bringing together data from multiple systems—including CRM, CDP, and transactional sources—into an accessible, trusted foundation. To be successful, you will collaborate closely with data engineers, architects, BI analysts, and data scientists to develop a unified platform that supports both real-time streaming and batch processing workloads. You will also play a key role in ensuring security, privacy, and compliance across the data lakehouse environment.

Duties & Responsibilities

• Design, implement, and maintain a scalable data lakehouse using modern data engineering frameworks
• Collaborate with business stakeholders to translate requirements into data models,and understand how business processes can translate into data requirements
• Design and implement Customer 360 data models and transformation logic using SQL stored procedures
• Design and build ETL/ELT pipelines across lakehouse storage zones for efficient ingestion, transformation, and optimization
• Develop real-time streaming data pipelines using industry-standard tools and ensure seamless integration into the lakehouse architecture
• Demonstrate curiosity to deeply understand complex business challenges and opportunities, collaborate on data-driven solutions, and balance an experimentation mindset with an agile implementation approach
• Implement secure, automated data ingestion pipelines with end-to-end lineage tracking, aligned to enterprise architecture standards and governed by role-based access controls and encryption
• Apply data masking, anonymization, and auditing practices to meet privacy and compliance standards (e.g., GDPR, PIPEDA)
• Maintain a centralized data catalog with complete metadata, source tracking, and transformation business rule documentation, alongside up-to-date records of system architecture, data models, and operational workflows
• Partner with data scientists, analysts, and BI teams to deliver accessible, well-structured, and high-quality datasets
• Ensure infrastructure scalability, performance, and resiliency, while maintaining high security standards
• 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

• Strong experience with data lakehouse storage and query technologies
• 5+ years of experience in data engineering using SQL, Python, or Scala, with advanced SQL skills in stored procedure development, optimization, and complex transformations
• Experience with versioned data models and incremental processing
• 3–5 years of hands-on experience with real-time data streaming technologies
• Hands-on experience with MACH architecture (Microservices, API-first, Cloud-native, Headless), along with strong proficiency in CRM systems, Customer Data Platforms (CDPs)
• Proficient in ETL/ELT development using AWS Glue, Matillion, Mulesoft or similar tools
• Familiar with data orchestration tools, governance frameworks, catalogiing solutions and security best practices in modern cloud-based environments
• Strong problem-solving and debugging skills
• Collaborative mindset and ability to work across cross-functional teams in an Agile environment
• Excellent communication and documentation skills, with proven track record of communicating technical contecpts to non-technical stakeholders
• Airline and/or aviation experience strongly preferred

Location

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