Established a unified data model using SQL and dbt, ensuring a single source of truth for all reporting, dashboards, and ad hoc analyses.Developed a comprehensive suite of marketing performance dashboards in Tableau, empowering business teams to track KPIs and optimize campaign investments.Designed and executed A/B tests to assess the effectiveness of product launches and major promotional campaigns, providing data-driven insights for critical business decisions.Implemented an automated KPI monitoring system with Slack alerts, enabling proactive identification of data anomalies and potential campaign issues.Partnered with C-level executives to answer key business questions using advanced exploratory data analysis methods to guide strategic decision making on key projects.Spearheaded the centralization and documentation of key metric definitions, ensuring consistency in data interpretation across the organization.Automated numerous reports and manual analyses using Python and Snowflake, eliminating reliance on external agencies and saving millions of dollars.

Developed real-time KPI reports in Looker to support marketing analysis, enabling business leaders to make data-driven decisions and achieve performance goals.Led weekly KPI reviews with marketing stakeholders, analyzing metric trends, identifying drivers, and recommending strategy adjustments based on data insights.Owned the A/B web testing program, designing and implementing a roadmap of site experiments that increased conversion rates by 20% during peak season, resulting in a $2.3M sales revenue increase.Collaborated with finance and marketing teams to forecast marketing revenue goals using statistical models, guiding campaign and investment strategies.

Collaborated with digital marketing teams to track KPIs, analyze trends, and deliver actionable insights through weekly/monthly performance reports.Developed a Tableau dashboard to analyze A/B test results for email campaigns, optimizing performance and maximizing revenue for this key channel.Created a dashboard to track the success of the new customer loyalty program, providing insights on customer retention and overall program effectiveness.Segmented and targeted high-value and win-back customers through data-driven email campaigns, achieving a 10% YoY increase in monthly revenue ($5.5M annually).

Created multiple interactive Tableau dashboards that provide weekly reporting on product sales, marketing channel performance, website KPIs, and other important business areas.Automated complex reports using SQL and R programming, including weekly sales emails, product performance updates, and scorecards, which save team members an estimated 30 hours of work each week by reducing the time spent on manual reporting.Developed a statistical model of email subject line keywords to predict open rate performance, which was used to create new subject lines and led to increases in email open rates on average.Analyzed t-shirt sales data to identify the top performing t-shirt attributes using a multiple regression model, which was used by buyers to guide purchasing strategies and helped boost overall digital t-shirt sales.Explore web traffic data using Adobe Analytics to understand customer behavior and identify valuable insights and trends in the data.Query Databricks and Snowflake data warehouses to tap into terabytes of historical digital sales and traffic data to be used for analysis and streamlined reporting.Provide market research support in developing survey questionnaires and consulting on focus group studies.Regularly present reports and provide insights at meetings with managers, directors, and non-technical staff.

Analyzed consumer data from over 130 countries to identify trends, insights, and report on key business metrics using ArcGIS maps, Tableau dashboard visualizations, and advanced statistical analysis with R.Led the research design and analysis on 32 in-person focus groups conducted in the U.S., Canada, United Kingdom, India and China to provide insights for a global marketing campaign and development of an online learning program.Designed and conducted over 300 surveys and online focus groups to provide insights for a website redesign, development of a digital magazine, understand college-age customers, and benchmark customer satisfaction and demographics.Collaborated with the IT Department to develop and design a SQL Server database to store relevant consumer data ready for analytics use, which increased overall team efficiency and allowed for further report automation.Used machine learning techniques on large data sets to develop advanced models for predicting customer retention and growth.Conducted market segmentation analysis using clustering to discover customer profiles used for educational program development and marketing purposes.

Supervised a team of data collectors for the National Children’s Study, a longitudinal study on the causes of childhood diseases.Trained data collectors on interview methods, study protocol, and the use of research equipment. Provided research and analysis support on various ad-hoc projects related to the overall study.