> job detail
P
š½Other
Marketplaces Advertising Analyst
Pattern Ā· Pune, India
// classified as
Other (Adjacent or hard to classify.)
posted
1d ago
location
Pune, India
languages
sql
tools
ā
> stack
sql
> description
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