Annie Bauer
San Francisco,CA
Overview
6
6
years of professional experience
Work History
Senior Data Analyst
Sephora
10.2023 - 03.2024
- Created, maintained and delivered weekly and monthly Market Share reporting to C-Suite executives.
- Built and owned data pipelines to transition Excel reports to Tableau dashboards for more efficient and less error-prone reporting.
- Analyzed channel, category, brand, and product performance across competitors. Established baseline market share targets across each segment.
- Estimated dollar impact from brands expanding distribution to competitors.
- Formulated Holiday promotion strategy using market share KPIs and identified client segments to target.
- Partnered closely with external vendors to leverage outside data sources, ensure accuracy of competitive data, and forecast overall prestige beauty market.
Data Analyst
Sephora
09.2021 - 09.2023
- Created, maintained and distributed comprehensive retail performance reports in SQL, Tableau, Python, R and Excel.
- Owned 4 end-stage SQL pipelines to report on digital tool, service, and event performance.
- Analyzed service business supply/demand to create a sample service schedule for 500+ stores. Presented findings to leadership and store managers. Results continue to drive labor & planning decisions.
- Estimated incremental value of promotions, events, and digital tool usage on retail KPIs using variety of methods like A/B testing with test & learn software and causal inference with econometric models like difference-in-differences.
- Partnered with data science, product, and finance teams to identify and define new KPIs to measure success, build new tables, and QA existing data sources.
Teaching Assistant
University Of San Francisco
01.2020 - 02.2021
- Teaching Assistant for ECON112, Principles of Macroeconomics.
- Teaching Assistant for ECON621, Data Science for Economics.
Paid Media Analyst
Rank Crankers
06.2018 - 06.2019
- Launched and managed Google Ads and Bing Ads accounts for ecommerce, health care, and B2B clients. Key duties included:
- Oversaw $3M account budgets. Allocated funds to highest performing campaigns, ad groups, and keywords.
- Planned, executed, and analyzed experiments such as A/B testing ad copy, landing pages, and bid strategies.
- Developed and presented monthly and quarterly insights reports to clients using Power BI, Google Analytics and Microsoft Excel.
Education
Master of Science - Applied Economics
University of San Francisco
San Francisco, CA05.2021
Bachelor of Arts - Economics And Spanish
University of Minnesota - Twin Cities
Minneapolis, MN05.2018
Skills
- SQL
- Python
- R
- Tableau
- Power BI
- Google Analytics
- Data Visualization
- Statistical Modeling
- Natural Language Processing
- Experimental Design
Timeline
Senior Data Analyst
Sephora
10.2023 - 03.2024
Data Analyst
Sephora
09.2021 - 09.2023
Teaching Assistant
University Of San Francisco
01.2020 - 02.2021
Paid Media Analyst
Rank Crankers
06.2018 - 06.2019
Master of Science - Applied Economics
University of San Francisco
Bachelor of Arts - Economics And Spanish
University of Minnesota - Twin Cities