Junior Data Analyst
Harbor Analytics · Boston, MA
Aug, 2024 · Present
• Build and maintain SQL models and Looker dashboards tracking fulfillment SLA, return rates, and promo lift for 8+ mid-market retail clients.
• Automated weekly KPI packs in Python (pandas + BigQuery), cutting analyst prep time ~6 hours/week and reducing manual copy errors.
• Partnered with client ops leads to define metric dictionaries and alert thresholds; reduced ad-hoc Slack requests ~25% after rollout.
• Designed and read A/B tests on email/SMS offers; flagged underpowered tests early and recommended sample-size gates.
• Documented pipeline runbooks and peer-reviewed PRs for dbt-style transforms shared across a 5-person analytics pod.
Data Analyst Intern → Junior Analyst
Northbridge Retail Co. · Cambridge, MA
Jun, 2023 · Jul, 2024
• Supported merchandising and inventory analytics: stockout risk, sell-through by SKU class, and store cluster performance.
• Built Tableau workbooks used in weekly merch meetings; standardized filters and date logic so regional managers trusted the numbers.
• Wrote reusable SQL for cohort retention and first-order vs repeat revenue; briefed marketing on which cohorts drove Q4 lift.
• Cleaned and joined POS, ecom, and returns extracts; cut weekly reconciliation cycle from 2 days to under 4 hours.
• Presented monthly insight decks to cross-functional leads; translated statistical findings into plain-language actions.
Undergraduate Research Assistant
Boston University (Questrom / IS dept.) · Boston, MA
Sep, 2022 · May, 2023
• Assisted faculty research on consumer choice and digital shelf data; scraped and structured product attribute panels.
• Ran exploratory analysis in R/Python; produced figures and appendix tables for working papers and conference posters.
• Maintained shared code notebooks and data dictionaries for a 4-student research team.