JB

Juan Buitrago

Data Analyst II at Relay

Toronto, Ontario

Overview

Work Experience

  • Data Analyst II

    2024 - Current

  • Business Intelligence Analyst

    2023 - 2024

    • Business Intelligence lead for our client, Exchange, the largest military government retailer in the US • Worked with the VP of Sales & the Managing Director to build out a detailed 1.5-month roadmap for the dashboard launch & delivered 1 week ahead of schedule to 30+ users within client group • Defined data requirements across 10+ sources, led the development of ETL workflows & implemented rigorous validation processes, achieving a 97% data accuracy rate • Built & maintained project management tracker while deploying dashboards for sales, labour, productivity, inventory & commissions replacing 30+ hours of manual report pulling every week

  • Operations Analyst

    2023 - 2023

    • Led analytics within the Bell door-to-door sales program managing 1200+ agents across Canada using DOMO, Salesforce & ADP to track KPIs • Played an integral part in the 6-month transition from manual excel reporting to real-time dashboards using a data visualization tool called DOMO; improved reporting accuracy by 23% while removing 20+ hours spent running reports every week • Built, implemented & managed a monthly sales target setting/forecasting process taking into account the channel, region, agent tenure, headcount & past performance; improved target accuracy by 7% and replaced 30+ hours of work for Directors every month • Analyzed and presented a revamped Performance Management System taking into account agent performance quartiling, tardiness & misdemeanour - led to the creation of a new weekly report for sales managers to track consistent low performers (4th quartile)

  • Analytics Consultant

    2023 - 2023

    • Led end-to-end deployment of dashboards for 5 clients, including Speedy Auto Service, Speedy Glass & Ontario Science Centre • Worked directly with clients to gather business requirements & accurately scope timelines, cost & platform requirements • Built and launched all dashboards on Looker Studio with a 60% reduction in time to deployment by the 3rd dashboard • Assisted in putting together pricing proposals & project deliverables to sell BI as a service

  • Founder

    2018 - 2023

    • Founded a healthy, ready-to-eat meal delivery service targeted at busy moms • Drove an efficient sales engine bootstrapping to $550K+ revenue since inception (averaged 141% YoY growth) • Landed a partnership with the largest restaurant group in Hamilton to become sole food provider delivering 35,000+ meals to 1,700+ families across Southern Ontario since March 2020 • Employed 31 people managing end-to-end process including sales, operations, marketing, finances, customer acquisition & user experience • Built weekly analytics reports & dashboards using Looker & Excel to track sales funnels, finances, cashflow, user data, website data & cohort analysis • Led the negotiation and sale of the Prep'd Fresh customer base to HealthyNow in July 2023

  • Strategic Advisor

    2020 - 2023

    • B2B SAAS platform for the meal prep industry; co-founded through Prep’d Fresh • Built the initial GTM strategy and crafted the 2-year product roadmap with dev team • Managed sales operations from prospecting through demos to close, converting at 36% rate • Transitioned to a strategic advisor, providing feedback on operations, product & fundraising • In this span, 3 new platform versions have been launched and 15 clients have been signed (500% ARR growth)

  • Boost Program Founder

    2022 - 2022

    Boost Residency is 12-months, designed and focused on supporting young entrepreneurs who are building scaling startups in Canada. Board of directors includes Ryan Holmes, Manny Padda, Michele Romanow. Accepted into cohort with Prep'd Fresh.

  • Junior Analyst

    2022 - 2022

    • Sourced and evaluated companies against Framework’s investment thesis across numerous industries including fintech, edtech & AI • Assisted in building reports & dashboards in CRM (Salesforce) while monitoring data quality • Conducted initial due diligence on 7 potential investments, including market research and analysis, financial modelling, unit economics and team evaluation • Contacted 500+ start-ups, met with 100+ founders and built relationships with 20+ VCs

  • Sales Analyst

    2020 - 2021

    • Led the analytics department across Canada for 2 separate business units ($250M) at public CPG company; presented quarterly & yearly business reviews to Executives (S&M, Finance) • Worked cross-functionally to clean up data sources & set workflows to maintain data quality; improved reporting accuracy by 21% • Created customer business intelligence reports via Excel, PowerBI to support sales team in tracking KPIs and analyzing current business trends including Vendor Performance Scorecards, YTD/MTD/WTD POS analysis and promotional activity trackers (ROI/Lift %) • Built visual dashboards via PowerBI & Tableau to support sales & marketing with pitch decks • Worked with Director of Sales to understand business inefficiencies such as Lost Sales, In-stock % & fill rates leading to a $3M opportunity in incremental business

  • Finance Intern

    2017 - 2018

    • Analyzed and closed out over $1 Million in outstanding Purchase Orders (PO’s) at year-end using innate problem-solving skills and received a recognition note from GM for leading the project and driving results. • Completed Trial Balance variance analysis for Controller group on a weekly basis • Collaboratively worked with project accounting team to manage 100’s of ongoing activations and created over 1000 new projects

  • Brand Ambassador

    2017 - 2018

    Created exciting and memorable brand experiences for consumers. Sampled multiple brands, such as Sprite, Nescafe and Jackson-Triggs while enhancing consumer interactions, driving awareness of the product and generating shareable content. Represented the Brands in a professional and respectful manner.

  • Assembly Worker

    2016 - 2017

    Produced components by assembling parts and subassemblies. Maintained safe and clean working environment by complying with procedures, rules, and regulations. Contributed to team effort by accomplishing related results as needed.

Relevant Websites