Pattern
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