Professional Summary
Junior Data Engineer with hands-on experience designing, testing, and maintaining automated batch and streaming data pipelines in cloud environments.
Proficient in Python, SQL, Apache Airflow, and Snowflake, with an emphasis on rigorous data quality testing, schema governance, and query optimization.
Professional Experience
Kestrel Logistics Platform
Calgary
Junior Data Engineer
May 2024 – Present
- Construct automated dbt models and SQL transformations within Snowflake to support operational reporting across 12 regional distribution depots.
- Orchestrate daily batch DAG workflows using Apache Airflow to ingest logistics telemetry and inventory records from external REST APIs into staging tables.
- Implement Great Expectations validation suites that identify upstream schema drift and null anomalies, lowering pipeline reprocessing runs by 24 percent.
- Partner with business intelligence analysts to tune query performance and clustering keys, reducing median dashboard refresh times from 14 minutes to 3 minutes.
Prairie Basin Energy Analytics
Calgary
Data Engineering Intern
May 2023 – Dec 2023
- Assisted in migrating legacy Bash and cron ingestion jobs into modular Python extract-and-load scripts targeting AWS S3 data lake storage.
- Wrote PySpark transformation jobs to standardize time-series telemetry data gathered from field monitoring equipment.
- Documented database schemas and updated column-level metadata dictionaries across 40 reporting views in PostgreSQL.
Education
University of Calgary
Bachelor of Science · Computer Science · Calgary · 3.7 GPA · Sep 2019 – Apr 2023
Coursework focused on database management systems, distributed computing, algorithms, and software engineering principles.
Completed an undergraduate capstone project building an end-to-end telemetry ingestion pipeline for municipal transit datasets.
Technical Projects
Transit Telemetry Stream Processor
Jan 2023 – Apr 2023
- Built a local streaming simulation pipeline utilizing Apache Kafka and Python to consume and parse transit positioning feeds.
- Persisted windowed speed and route aggregates into PostgreSQL and exposed data via lightweight analytical views.
Core Skills
Python
SQL
Apache Airflow
Snowflake
dbt
Apache Spark
PostgreSQL
Amazon Web Services
Docker
Git
Languages
English
C2
French
B1
Certifications
AWS Certified Data Engineer - Associate
Amazon Web Services · Aug 2024
SnowPro Core Certification
Snowflake · Feb 2025
Community Involvement
Calgary Youth STEM Guild
Calgary · Jan 2024 – Jun 2025
- Volunteer Coding Mentor
- Led hands-on introductory Python workshops for secondary school students, covering basic data structures and syntax.
- Mentored small student teams on exploratory data analysis mini-projects using open municipal datasets.