About this Marketplaces Advertising Analyst role at Pattern
Pattern · Hybrid · Pune, India
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
What You Will Need to Thrive
Must-Have
• 1–2 years of hands-on experience in analytics, data, or business intelligence — ideally in
ecommerce, advertising, or marketplaces
• Working knowledge of SQL — comfortable writing queries with joins, aggregations, and
basic optimisation
• Familiarity with Amazon Marketing Cloud (AMC) and clean room concepts — or strong
willingness to certify within the first 90 days
• Understanding of the Amazon advertising ecosystem — Sponsored Products,
Sponsored Brands, Sponsored Display, and DSP at a foundational level
• Strong attention to detail with reporting and data accuracy
• Good verbal and written communication skills — able to clearly summarise findings
• Curious, proactive, and eager to learn in a fast-paced environment
Nice to Have
• Amazon Marketing Cloud (AMC) certification (or willingness to obtain within 90 days of
joining)
• Experience with BI tools (Looker, Tableau, Power BI, Quicksight)
• Exposure to Python or R for data analysis
• Experience working with retail / ecommerce brands
• Background in marketplace marketing, particularly Amazon
Must-Have
• 1–2 years of hands-on experience in analytics, data, or business intelligence — ideally in
ecommerce, advertising, or marketplaces
• Working knowledge of SQL — comfortable writing queries with joins, aggregations, and
basic optimisation
• Familiarity with Amazon Marketing Cloud (AMC) and clean room concepts — or strong
willingness to certify within the first 90 days
• Understanding of the Amazon advertising ecosystem — Sponsored Products,
Sponsored Brands, Sponsored Display, and DSP at a foundational level
• Strong attention to detail with reporting and data accuracy
• Good verbal and written communication skills — able to clearly summarise findings
• Curious, proactive, and eager to learn in a fast-paced environment
Nice to Have
• Amazon Marketing Cloud (AMC) certification (or willingness to obtain within 90 days of
joining)
• Experience with BI tools (Looker, Tableau, Power BI, Quicksight)
• Exposure to Python or R for data analysis
• Experience working with retail / ecommerce brands
• Background in marketplace marketing, particularly Amazon
Ready to apply to Pattern?
Apply to Pattern
