Open to opportunities

Jeremy Gonsalves

@jeremygonsalves

Customer-facing data and AI engineer building production PySpark ETL, agentic reporting, and automated executive reporting.

Canada

Message

What I'm looking for

I’m looking to build and deploy production data + AI systems that reduce manual reporting, automate customer workflows, and turn technical discovery into shipped solutions.

I’ve been building customer-facing data and automation systems across TD Bank, startups, and fintech—turning raw transactions into fund-flow signals, reconciliation workflows, and executive-ready reporting.

At TD Bank, I’ve deployed production PySpark ETL pipelines for chequing and savings performance and built modular Python feature pipelines that power attrition-risk models and retention campaigns against fintech competitors.

I also spend time on automation that ships: I’ve engineered Airflow-based and Databricks ETL/ELT workflows, delivered Power BI KPI reporting, and improved stakeholder reporting SLAs while reducing manual effort.

As the founder of Pipeline AI, I designed an end-to-end agentic reporting system for physiotherapy clients—extracting data from PDFs, integrating OpenAI, Slack, and Google Workspace APIs, and automating action-item tracking and report generation.

Experience

Work history, roles, and key accomplishments

Current

Data Scientist II

Current

TD Bank

Feb 2026 - Present (5 months)

Built a production PySpark ETL pipeline processing 18M+ customer records daily, improving reconciliation accuracy to 99.5% and validating $2.6B+ in promotional deposit payouts. Engineered modular Python feature pipelines for attrition-risk models and retention campaigns.

Python SQL PySpark Databricks ETL AWS

Current

Founder & GTM Engineer

Current

Pipeline AI

May 2025 - Present (1 year 2 months)

Designed an end-to-end agentic reporting system for physiotherapy clients using Python, PDF extraction, Supabase, OpenAI API, and AWS, generating $5K MRR. Built a document-ingestion pipeline and integrated APIs to automate report generation, reducing manual effort by 70%.

Python OpenAI API Supabase AWS

Business Intelligence Analyst

TD Bank

Jun 2025 - Feb 2026 (8 months)

Deployed Python, SQL, and Databricks ETL/ELT pipelines for chequing and savings performance reporting, reducing manual reporting effort by 20%. Partnered with teams to automate analytics workflows, improving data delivery SLAs by 30%.

Python SQL Databricks ETL Power BI PySpark

Founder

Jeremy's Tutoring Academy

Sep 2020 - Jun 2025 (4 years 9 months)

Founded and managed a tutoring business that generated over $20,000 in profit across North America. Promoted the academy and maintained continuous student engagement through online educational videos.

Business Intelligence Engineer

Credit Sesame

Jul 2024 - May 2025 (10 months)

Improved revenue reporting accuracy and efficiency by 20% by engineering Python, SQL, and Airflow ETL/ELT workflows from AWS Redshift. Reduced ETL processing time by 35% by deploying Airflow DAGs and production Python scripts for executive KPI reporting.

Python SQL Airflow AWS RedShift ETL

Teaching Assistant

Queen's University

Sep 2021 - Apr 2024 (2 years 7 months)

Directed interactive tutoring sessions for 100+ engineering students in Calculus to foster essential learning skills.

Software Developer Co-op

Ontario Teachers' Pension Plan

Jan 2023 - Aug 2023 (7 months)

Reduced data processing time by 30% by integrating SQL, Excel, APIs, JSON, Python, GitHub, and Power BI into executive dashboards. Improved data accuracy to 97% by validating Python scripts and delivering Power BI metric updates.

SQL Python Power BI GitHub JSON