Digital Commerce Retail Media Analytics Intern

Responsibilities

• Build a Power BI retail media effectiveness dashboard that consolidates campaign, media, and commerce performance from multiple data sources into a clear, repeatable reporting solution.
• Collect, clean, transform, and validate data from Walmart Connect, Amazon Ads, Roundel, Kroger Precision Marketing, Instacart, DoorDash, agency reporting, and other relevant sources.
• Define and document consistent KPI calculations, data definitions, refresh processes, and quality checks to improve comparability and confidence across retail media networks.
• Analyze media performance using measures such as spend, impressions, clicks, click-through rate, cost per click, attributed sales, return on ad spend, conversion, and other available platform KPIs.
• Partner with the Digital Commerce Analyst to connect retail media results with sales, share, traffic, conversion, promotional, and retailer performance insights where data is available.
• Identify trends, performance drivers, outliers, and optimization opportunities, then translate findings into concise, actionable recommendations for the Retail Media Manager and business partners.
• Collaborate with Shopper Marketing, Digital Commerce, analytics, and agency partners to gather requirements, reconcile inputs, and ensure the dashboard supports business decision-making.
• Create user documentation and present the final dashboard, methodology, key insights, and recommended next steps to cross-functional stakeholders.

Requirements

• Academic, internship, or project experience working with large datasets, marketing analytics, business analytics, or data visualization.
• Experience cleaning, joining, and analyzing data from multiple sources to answer a business question or build a reporting solution.
• Experience developing dashboards or analytical models in Power BI; coursework and portfolio projects are acceptable.
• Experience with digital marketing, retail media, eCommerce, consumer packaged goods, or advertising measurement is preferred but not required.
• Required proficiency in Microsoft Power BI, including data modeling, Power Query, DAX, dashboard development, and data visualization.
• Strong data science and analytical foundation, with working knowledge of data preparation, exploratory analysis, statistical reasoning, and measurement concepts.
• Proficiency in Excel; experience with SQL and Python or R for data manipulation and analysis is strongly preferred.
• Ability to translate complex analyses into clear insights, compelling visualizations, and practical business recommendations.
• Strong attention to detail and commitment to data quality, documentation, and reproducible processes.
• Strong project management, communication, and collaboration skills, with the ability to manage multiple data inputs and stakeholder needs.

Preferred

• Experience with digital marketing, retail media, eCommerce, consumer packaged goods, or advertising measurement is preferred but not required.