×
Josh Stewart

Josh Stewart


4 Brian Monkman Bay, Winnipeg, Manitoba, CA
204-996-2405

Background


About

About

Recent Business Analytics Graduate focused on building end-to-end data pipelines and translating what the data actually means into decisions that move the business forward. Experienced with dbt, BigQuery, and Python across real client projects, with a track record of finding the revenue story buried inside messy data. Currently learning Claude Code to automate the repetitive stuff and spend more time on the work that actually moves the needle.

Work Experience

Work Experience

  • Property Maintenance Assistant, Self-Employed

    Jun, 2023 - Jan, 20251 year 7 months

    • Managed upkeep of a residential rental property, handling scheduling, seasonal maintenance, and quality control.

    • Performed routine pool chemical testing and safety adjustments, ensuring the property met maintenance standards year-round.

  • Warehouse Associate, Drake International

    Jul, 2022 - Jan, 20236 months

    • Processed 100+ daily shipments using RFID scanning to track inventory flow across Winners retail locations.

    • Organized and staged outbound products in a distribution center, keeping operations running on schedule.

  • Retail Associate, Canadian Tire

    May, 2021 - Jun, 20221 year 1 month

    • Advised customers on product recommendations and processed sales transactions across two departments.

    • Maintained inventory accuracy through regular stock counts, price updates, and POS data entry.

Projects Experience

Projects Experience

  • Shopify Fashion Brand | Meta Ads Audit

    - Present

    SQL, BigQuery, Python, Claude Code

    • Audited $1.1M CAD in Meta ad spend across 50 campaigns and found CPM had risen 17x in a single year, collapsing reach from 3 million people to 216,000 while the brand kept spending the same budget every month without noticing.

    • Found the brand was funneling $310K CAD into their worst-performing creative type (ROAS 1.89) while their best creative (ROAS 5.87) received only $33K CAD, a budget misallocation that cost an estimated $9.8M CAD in unrealised revenue.

    • Built a Claude Code agent to automate data cleaning across three raw CSVs, hitting 96% accuracy and cutting prep time from hours to minutes.

  • Winnipeg Hip Hop Radio Station | Beta Test Analysis

    - Present

    Python, Pandas, Excel

    • Built an automated Python pipeline transforming raw listener data into a self-updating Excel report, giving the team instant visibility to make programming decisions before losing early audience momentum.

    • Identified Monday as peak reach day (67 avg listeners) and Wednesday as peak engagement day (15.9 min avg session), enabling smarter scheduling to maximize both growth and retention.

    • Discovered top 10 artists represent only 11.72% of total plays, proving a diverse rotation strategy that positions the station to win listeners that mainstream radio is ignoring.

  • Kith Ecommerce Analytics Pipeline

    - Present

    Python, dbt, BigQuery, Power BI

    • Built an end-to-end analytics pipeline analyzing 5,000 orders across 9 collab partners to answer one question: which contracts are worth renewing and which are quietly draining margin?

    • Identified Columbia as the highest-value partner ($398 AOV, 6.28% refund rate) versus Adidas (16.67%) and Nike (14.1%), revealing where marketing spend was being wasted on high-refund contracts.

    • Developed 5 dbt data marts ensuring clean, tested, decision-ready data so no business call gets made on bad numbers.

Skills

Skills

  • Analytics Engineering

    Python

    SQL

    dbt

    BigQuery

  • Business Intelligence

    Tableau

  • Tools

    Git

    Excel

    Microsoft Office Suite

  • AI & Automation

    Claude Code

    n8n

    Prompt Engineering

Education

Education

  • Business Analytics, Bachelor, University of Manitoba

    Sep, 2021 - May, 2026

Certificates

Certificates

  • Responsive Web Design, FreeCodeCamp

    Issued on: