Alex Morgan
Data Analyst with 6 plus years of experience turning customer, transaction, and marketing data into growth insights using SQL, Snowflake, Tableau, Python, pandas, and dbt. Delivered faster decision making through automated reporting, standardized metric models, and rigorous A B testing, including 35 percent faster dashboards and measurable lifts in conversion and repeat purchase behavior.
SKILLS
Data Querying and Modeling: SQL, Snowflake, Data modeling, Data joins and transformations, Analytics engineering fundamentals
Business Intelligence and Dashboards: Tableau, Dashboard development, KPI design and tracking, Sales and retention reporting, Campaign performance reporting
Experimentation and Statistics: A B testing, Experiment design, Statistical hypothesis testing, Incrementality measurement, Results interpretation and recommendations
Automation and Analytics Engineering: Python, pandas, dbt, Automated reporting pipelines, Reusable data marts and metrics layers
Growth Analytics and Stakeholder Communication: Marketing analytics, Merchandising analytics, Product analytics, Executive ready storytelling, Stakeholder management and cross functional collaboration
EDUCATION
Northeastern UniversitySep 2016 - May 2020
B.S., Economics
EXPERIENCE
Data Analyst, WayfairMar 2022 - Present
Boston, MA
Made weekly sales reports in Excel for the sales team.
Helped the product team with tests on the website.
Cleaned data for other analysts.
Answered data questions from managers.
Wrote complex SQL in Snowflake to join customer, order, and marketing tables, enabling weekly growth reporting across sales, retention, and campaigns.
Built and maintained Tableau dashboards tracking revenue, repeat purchase rate, and email conversion, used by marketing and merchandising leaders weekly.
Designed and analyzed 12 plus A B tests for onsite merchandising and email experiences, applying statistical testing to recommend winning variants.
Automated recurring reporting with Python and pandas, reducing manual Excel preparation time by 8 hours per week and improving refresh reliability.
Developed dbt models for curated growth metrics, standardizing definitions for net sales, cohort retention, and campaign attribution across teams.
Optimized Snowflake SQL queries using clustering and selective joins, cutting dashboard load times by 35 percent for high traffic Tableau workbooks.
Business Analyst, ChewyJun 2020 - Feb 2022
Boston, MA
Worked on reports for the marketing team.
Pulled data from the database when people needed it.
Made some dashboards.
Worked with different teams on projects.
Wrote complex SQL in Snowflake to join customer, order, and campaign tables, enabling weekly growth reporting across marketing and merchandising.
Built and maintained Tableau dashboards tracking sales, retention cohorts, and email performance, improving stakeholder self service adoption by 45 percent.
Designed and analyzed 12 A B tests for onsite and email experiences, using statistical testing to lift conversion rate by 3.8 percent.
Automated recurring KPI reporting with Python and pandas, reducing manual spreadsheet work by 10 hours weekly and improving data consistency.
Developed dbt models for clean marketing attribution tables, standardizing definitions for CAC, ROAS, and LTV across five cross functional teams.
Presented experiment results and growth recommendations to senior leaders monthly, translating technical findings into prioritized roadmap actions and budget shifts.
PROJECTS
Customer churn analysisJan 2023 - Apr 2023
Looked at why customers stop buying and made a model to guess who will leave.
Built a churn and retention analytics model by joining Snowflake customer, order, and campaign tables with SQL, then modeling in Python.
Automated weekly cohort retention and LTV reporting with dbt models and pandas, cutting manual analysis time 60 percent across teams.
CERTIFICATIONS
Google Data Analytics Certificate, GoogleApr 2020
