Andrew Jaroncyk

Data Science | Advanced Analytics | Business Intelligence | Revenue & Product Strategy

Greater Boston

About

Data professional with experience driving analytics across financial services, ad tech, insurance, and multi-state retail operations. I specialize in transforming complex sales, product, and operational data into scalable reporting, forecasting, and decision-support frameworks that directly influence revenue strategy and executive planning, and have built and automated analytics solutions using SQL, Python, R, AWS, and modern BI platforms to improve metric consistency, stakeholder alignment, and performance visibility across technical and non-technical teams.

Experience

  • Senior Wholesale Project Analyst at The Cannabist Company
    Jan 2025 - Feb 2026 · 1 yr 2 mos

    Led analytics and forecasting across a ~$70M multi-state wholesale organization, transforming sales, inventory, and distribution data into scalable reporting frameworks that improved executive visibility, revenue recovery, and cross-market performance management. Standardized wholesale KPI definitions, reporting cadences, and data validation processes across disparate systems and markets, increasing stakeholder trust in metrics and enabling consistent forecasting, demand planning, and leadership reporting. Owned external brand partner analytics, delivering weekly inventory and out-of-stock performance reporting that quantified lost revenue, product availability gaps, and store-level coverage — strengthening partner alignment and informing strategic sales decisions.

  • Data Analytics Specialist at Federal Home Loan Bank of Boston
    Jul 2023 - Nov 2024 · 1 yr 5 mos

    Developed analytics and dashboarding solutions supporting a $40B+ financial portfolio, enabling Treasury, MPF, and Member Services leadership to monitor risk exposure, liquidity, and strategic initiatives through automated reporting and data pipelines. Built scalable SQL-driven workflows to ingest, validate, and transform multi-source internal and regulatory datasets, improving operational transparency and reducing manual reporting overhead. Analyzed HMDA mortgage origination trends across New England, contributing to the launch of a Permanent Rate Buydown Program that improved home affordability for 198 borrowers and aligned lending strategy with regional equity goals.

  • Product Analyst at Cybba
    Dec 2021 - Mar 2023 · 1 yr 4 mos

    Architected internal analytics infrastructure on AWS, designing S3-based data pipelines to ingest and process 300GB+ of API data from demand-side platforms and building QuickSight dashboards measuring profitability across marketing and ad-tech products. Partnered cross-functionally with Product, Engineering, Sales, and Account Management to define KPIs and optimize campaign performance, ensuring variable margin targets were met across channels and tactics. Delivered a scalable data discovery solution for an ~$84B luxury brand client by integrating 10TB+ of behavioral and conversion data across six international sub-brands, enabling unified performance insights and strategic upsell opportunities.

  • Product Analyst at Homesite Insurance
    Jun 2020 - Sep 2021 · 1 yr 4 mos

    Conducted advanced exploratory and prescriptive analytics across a ~$140M homeowner insurance portfolio, identifying underwriting, retention, and profitability trends that informed state-level pricing and performance strategy. Established a JIRA-driven performance tracking framework supporting a $5B+ book of business across four operating companies, enabling 150+ stakeholders to monitor regulatory filings, automate rate projections, and improve resource allocation. Supported geographic expansion into a ~$50M Michigan market through pricing analysis, regulatory alignment, and competitive benchmarking, contributing to strategic growth and product performance optimization.