Marketplaces Advertising Analyst
pattern · Pune, India
Apply directly on pattern’s careers site — no account needed.
About the role
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
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
Skills
- SQL
- Python
- Tableau
- Power BI
- Looker
- AWS
- GCP
- Azure
- BigQuery
Never be applicant #200 again
Every job here is indexed straight from company career pages — often hours after it opens, before it reaches the big boards. Create a free account and get your best matches in a twice-daily digest.
- Your best matches, twice a day
- No duplicates, no ghost jobs, no recruiter spam
- Every job free to browse — pay only when you apply
Get my matched jobs
Free account — no card required
93 150 live jobs · 17 788 companies tracked · 5 740 added today