1. SQL, Python, Excel, Powerpoint, LLM usage to extract, manipulate, model and analyze retail and media data to measure marketing effectiveness;
2. Hands on expertise with Adobe Analytics with experience navigating workspace, building segments, creating calculated metrics, and extracting insights on channels from traffic to conversion;
3. Ability in both PowerBI and Tableau to construct and design functional dashboards and visualizations; interpret for storytelling, trend analysis, and executive reporting;
4. Understanding of Marketing Mix Modeling inputs and outputs and ability to interpret results for marketing optimization, with experience building diminishing return and saturation curves;
5. Understanding of media optimization KPIs and diagnostics including: Return on ad spend (ROAS), CPM / CPC, reach / frequency, Cost / Acquisition, CAC, CLV and Ecommerce metrics including Conversion, Average Unit Retail (AUR), and Average Order Size (AOS);
6. Clear understanding of the roles of incrementality vs attribution vs experimentation for marketing effectiveness measurement;
7. Ability to project manage media testing, reporting and ad hoc requests from start to finish via robust project plans and attention to detail;
8. Direct collaboration with external stakeholders including Meta, Google, 3rd party marketing agencies and proven partnership with internal stakeholders including Finance, Marketing;
9. Ability to develop, deliver and communicate findings and recommendations via data visualizations and PowerPoint presentation decks and level up insights for leadership teams; and
10. Consultative approach to identifying media investment opportunities and budget optimization strategies; ability to translate data-driven insights into actionable recommendations that maximize marketing impact and efficiency.
Master’s degree in Mathematics, Statistics, Data Science, Computer Science, or related field and 3 years of experience in the job offered or related role.