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.
