Principal B.I. Analyst - Klaviyo

Klaviyo

February 2024 - present

• Developed and owned core analytical data models using dbt, SQL (Snowflake), and Git, providing a reliable source of truth that powered all marketing analytics and reporting.
• Managed and enhanced the paid marketing analytics dashboard, providing stakeholders with real-time visibility into full-funnel performance, from campaign spend to MQLs and Closed Won revenue.
• Spearheaded the complete overhaul of the marketing attribution model, integrating predictive analytics to forecast campaign performance and enhance strategic budget allocation.
• Conducted statistical analysis of marketing A/B tests, delivering key insights that informed strategies to increase free-to-paid conversion and customer reactivation rates.

Sr. Business Intellience Analyst

Klaviyo

October 2021 - February 2024

• Creating and maintaining analytical tables using SQL (Snowflake), Git/GitHub, and dbt.
• Creating a marketing analytics dashboard for the Paid Marketing Campaigns, including campaign spend, MQLs, and Closed Won Revenue.
• Researching and performing multiple touch attribution and regression based attribution analysis for the Paid Marketing Campaigns using SQL and Python.
• Assisting in SMS Revenue Forecasts and other adhoc analyses.
• Co-leading the Families Employee Resource Group.

Risk Adjustment Analyst

April 2017 - August 2019

• Produced the analytics and reporting for an entire line of business using the ACA risk adjustment model. Coordinated data submission for government regulations.
• Wrote SAS and Excel VBA code for reporting on member risk scores, year-over-year diagnosis gaps, and other key performance metrics. Optimized exisiting VBA code to reduce production time by 50% for hundreds of monthly external reports.
• Facilitated cross-department meetings for yearly data submission for government regulations. Researched data submission errors and their solutions. Enhanced error reports with team-requested information, such as identifiers and indicators to prioritize work.
• Reduced data submission rejections to less than 1% and documented process improvements for subsequent governmental submissions.

Volunteer Work

April 2017 - August 2019

Participating in United Way Day of Caring & working in the company's garden where the produce is donated to the local food bank.

Ph.D. in Physics

2009-2016

University of Notre Dame

• Resolved an existing discrepancy in the field and presented my results through published works and tailored presentations to a variety of audiences, including subject matter experts and the general public.
• Authored C++ and Python software to identify the decay rates of rare isotopes while reducing false positives from contamination. Wrote LabView software to operate equipment such as a spectrograph magnet and particle detectors.
• Trained junior research group members in experimental techniques and data analysis.

Volunteer Work

2010-2016

Guide at the Nuclear Science Lab, giving tours to local groups including students, Boy & Girl Scouts, and University officials.

Coordinator for Physics Olympics, a friendly competition between students from different universities, involving physics experiments.