zach.dev

Zachary O'Donnell

Business Analyst & Data Engineer

hello@zachodonnell.me · South Hadley, MA

Summary

Analyst and builder who turns messy operational data into automated systems, dashboards, and measurable business outcomes. Experienced across Amazon advertising, pricing, ETL pipelines, and full-stack internal tools.

Experience

Business Analyst II

Rug Pad USA

Oct. 2022 – Jan. 2026 · Suffield, CT

  • Managed $5M+ annual Amazon Ads spend supporting $50M+ in revenue, increasing efficiency and driving incremental net sales growth through custom performance metrics, profitability-based bidding, and automated optimization systems.
  • Led pricing and profitability initiatives that increased net sales while reducing unit volume, improving margins and driving more efficient operations.
  • Developed automated bidding and campaign management tools in Python, reducing manual optimization time by 60–80%.
  • Designed and implemented a COGS calculation engine supporting ~3,000 standard SKUs and 800,000+ dynamically generated custom SKUs, enabling SKU-level profitability tracking.
  • Built a centralized data infrastructure (PostgreSQL, Supabase, dbt), reducing reporting time from hours to minutes.
  • Developed interactive dashboards and internal tools (Next.js, TypeScript, Python) to monitor revenue, profitability, and advertising performance.
  • Engineered ETL pipelines and API integrations (Amazon Ads, ChannelAdvisor, Shopify), automating data ingestion and eliminating manual reporting workflows.
  • Improved database performance through schema design and indexing, reducing query times by 30–70%.

Business Analyst

Connecticut APA

Nov. 2020 – Oct. 2022 · Chicopee, MA

  • Handled HR and bookkeeping tasks including hiring, payroll, and 1099 generation.
  • Developed software to fill efficiency gaps in business operations.
  • Piloted automatic payments for players to reduce staff workload.
  • Enhanced operational performance and reduced labor expenses by developing and optimizing standard practices.

Business Analyst

CheckWriters

Nov. 2019 – Sep. 2020 · Northampton, MA

  • Collaborated with stakeholder groups across the organization to ensure business and technology alignment.
  • Used brainstorming sessions and wireframes to build requirements for improved accruals and payroll input.
  • Translated stakeholder requirements into user cases, user stories, and workflow diagrams.
  • Worked with leadership to problem-solve and identify workflow improvements.
  • Created and updated detailed documentation of current and future software implementations.

Operational Support Specialist

MassMutual

Oct. 2017 – Nov. 2019 · Springfield, MA

  • Developed reports pairing associates' monthly work completed with error rates using Alteryx.
  • Presented consolidated error analysis to management and developed measurable action plans.
  • Built a web application to automatically generate tickets for the Employee Engagement Committee recognition program.
  • Developed an automatically generated rotating work schedule built on an optimized skills-based algorithm.
  • Member of the SharePoint/Metrics committee tasked with standardizing and improving productivity tracking.
  • Processed over 6,000 requests per month at a 99%+ accuracy rate.

Education

University of Massachusetts — Bachelor of Science: Resource Economics (May 2017)

Skills

Python · TypeScript · Next.js · SQL · PostgreSQL · dbt · Supabase · Amazon Ads · ETL / API integrations · Data analysis · Agile / Jira · Alteryx · Stakeholder management · Business process mapping