What You Will Do
Amazon Marketing Cloud & Data Pulls
• Run regular data pulls from Amazon Marketing Cloud (AMC) for the portfolio of brand
accounts
• Write and maintain SQL queries against AMC clean room data — starting with
established query libraries and progressing to building your own
• Support AMC instance maintenance, audience refreshes, and routine clean room
operations
• Continuously build your AMC expertise — keeping current with feature releases and
best practices
Reporting & Dashboards
• Maintain the team's daily, weekly, and monthly reports — ensuring data accuracy and
timely delivery
• Build and update dashboards that track campaign performance, spend pacing, ROAS,
and other key metrics
• Respond to ad-hoc data requests from the Senior Manager, the execution team, and
brand partners
• Help prepare data and visuals for partner reviews and quarterly business reviews
Insights — Growing Scope
• Support path-to-conversion analysis — how customers discover and convert across
Sponsored Products, Sponsored Brands, Sponsored Display, and DSP
• Help identify where we are losing customers in the funnel and surface patterns to
investigate
• Contribute to ideal customer profiling and audience analysis for brands
• Suggest ad efficiency improvements based on data — bid strategy, budget allocation,
targeting refinement
DSP & Cross-Channel Analytics
• Support analytics for Amazon DSP campaigns — reporting, audience overlap, and
incremental measurement
• Help quantify how upper-funnel DSP activity contributes to lower-funnel conversions
• Assist with new-to-brand analysis and cross-channel reporting
Collaboration
• Work closely with Praveen (Lead Strategist) and the offshore execution team to ensure
insights are translated into action
• Partner with Usaid (Senior Manager) on partner-facing analytics and reporting cadence
• Build relationships with Brand Management, Merchandising, and SEO/Content teams as
you grow into the role