Marketplaces Advertising Analyst
PatternIndiaFull-time (Salary)2w ago
Analystremotecurated-jd
Job description
Marketplaces Advertising Analyst at Pattern.
About the role
Pattern is hiring an analyst to support advertising analytics across Amazon marketplace accounts. You will extract and interpret data from Amazon Marketing Cloud, maintain reporting systems, and help translate findings into actionable recommendations for brand partners.
Key facts
What you'll do
- Execute recurring data extractions from Amazon Marketing Cloud for a portfolio of brand accounts
- Author and manage SQL queries within AMC clean room environments, starting from existing query libraries and eventually developing custom queries
- Handle AMC instance upkeep, audience refresh cycles, and standard clean room tasks
- Stay current with AMC feature updates and evolving best practices
- Produce and maintain daily, weekly, and monthly reports with accurate data and on-time delivery
- Create and refine dashboards covering campaign results, spend pacing, ROAS, and related metrics
- Fulfill ad-hoc data requests from leadership, execution staff, and brand partners
- Prepare data visualizations for partner reviews and quarterly business reviews
- Assist with path-to-conversion studies across Sponsored Products, Sponsored Brands, Sponsored Display, and DSP
- Identify funnel drop-off points and flag patterns worth further investigation
- Contribute to ideal customer profiling and audience segmentation for brands
- Recommend efficiency improvements such as bid strategy adjustments, budget reallocation, and targeting refinements
- Support Amazon DSP campaign analytics including audience overlap and incremental measurement
- Help measure how upper-funnel DSP efforts influence lower-funnel conversions
- Conduct new-to-brand analysis and cross-channel reporting
- Collaborate with Brand Management, Merchandising, and SEO/Content teams as responsibilities expand
Requirements
- SQL proficiency for querying clean room data
- Experience with Amazon Marketing Cloud or willingness to develop deep expertise quickly
- Ability to build and maintain dashboards and reports
- Strong attention to data accuracy and deadlines
- Comfortable working with cross-functional teams across time zones
Skills & tools
- SQL
- Amazon Marketing Cloud (AMC)
- Amazon DSP
- Dashboard and reporting tools
- Familiarity with Sponsored Products, Sponsored Brands, and Sponsored Display ad formats