Patrick Kozlow.

Senior Software Engineer @ Instacart

Sept 2024 – Dec 2025

• Partnered with executive stakeholders in the advertisement domain to design and build a scalable data warehouse, enabling real-time tracking of Ads KPIs like ROAS, CPI, and CTR for global clients.
• Led the migration of legacy ETL pipelines to Apache Iceberg on AWS, deprecating outdated datamarts and achieving $1M in annual infrastructure cost savings through optimized storage and processing.
• Engineered AI productivity tooling using Anthropic APIs, building MCP integrations and prompt-engineered workflows that accelerated onboarding, reduced support tickets, and improved overall engineering velocity.
• Built a self-service Terraform framework for data governance, enabling engineers to safely manage production database attributes through standardized CI/CD pipelines and deployment controls, reducing platform team dependency.

Lead Data Engineer / Senior Data Engineer @ Air Canada

Aug 2022 – Sept 2024

• Conducted technical discovery workshops and business analysis to translate complex requirements into architectural roadmaps, ensuring adherence to data governance and compliance standards.
• Led the data engineering workstream for Air Canada's Digital Simulation initiative, delivering a network-wide operational risk forecasting system that identified 100+ risks at 95% accuracy and generated $50M+ in savings by preventing last-minute operational disruptions.
• Architected enterprise Databricks and Spark infrastructure and automated data quality monitoring, delivering a 35% reduction in processing time and 40% reduction in debugging overhead across production pipelines.
• Engineered deep neural network models and feature extraction pipelines powering real-time risk prediction across Air Canada's operational network, optimizing workflows from POC to production and achieving a 15% reduction in compute costs.
• Delivered 100+ batch and real-time ingestion pipelines using SQL and Scala, optimizing large-scale transformations and data availability for production environments.

Data Engineer @ Nureva Inc.

Feb 2019 – Aug 2022

• Developed and maintained ETL workflows using Apache Spark and Airflow to migrate millions of records from an on-premises deployment to a modern cloud-native architecture.
• Engineered a star schema data model for normalized data storage, facilitating reporting and analysis on over $10M in annual marketing expenditures.
• Automated ETL deployment workflows through CI/CD and version control, accelerating release cycles and reducing deployment errors across the data pipeline.

Electronic Design Engineer @ OrbSurgical Ltd.

Oct 2018 – Feb 2019

• Led documentation and prototype development for projects valued over $5 million, aligning technical solutions with end-user requirements and modernizing operations.
• Conducted system and component-level testing, identified root causes of operational issues, and implemented solutions to improve system reliability and performance.

Graduate Assistant @ University of Calgary

(Research & Teaching)

Aug 2016 – May 2018

• Designed and delivered technical material on Python, SQL, Scala, and distributed systems, focusing on architectural patterns and production engineering practices to prepare students for large-scale data initiatives.
• Presented research and led technical discussions on biometric applications, data governance, and security for academic panels, establishing strategic frameworks for complex data environments.

Engineering Technical Writer @ Arc Reactions Inc.

2016 – 2017

• Researched and created articles that highlighted new developments occurring in the energy sector related to engineering.
• Conducted peer reviews for materials published by colleagues as well as provided feedback.
• Responsible for organizing interviews and scheduling meetings between key individuals from growing industries.