Marketplaces Advertising Analyst

Pattern Bioscience

Marketing Analyst running data pulls and analytics for Amazon accounts. Collaborating with teams and maintaining reports and dashboards for brand performance.

Posted 7/14/2026full-timePune • 🇮🇳 IndiaJuniorMid-LevelWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Proficient in SQL for data analysis and reporting, with a strong understanding of Amazon Marketing Cloud (AMC) and the Amazon advertising ecosystem. Capable of building dashboards, maintaining data accuracy, and providing actionable insights to enhance campaign performance.

Highest-signal resume keywords

SQL Query WritingAmazon Marketing Cloud (AMC)Business Intelligence ToolsData Analysis with Python or REcommerce Analytics

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLData AnalysisDashboard CreationAudience AnalysisReporting Accuracy

Soft Skills

Attention to DetailVerbal CommunicationWritten CommunicationCuriosityProactivity

Tools & Technologies

LookerTableauPower BIQuicksight

Certifications & Qualifications

Amazon Marketing Cloud (AMC) Certification

Industry Keywords

EcommerceAdvertisingMarketplacesAmazon Advertising EcosystemRetail Brands

Tech Stack

Tools & technologies

CloudPythonSQLTableau

About the role

Key responsibilities & impact

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
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
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
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
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

Requirements

What you’ll need

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
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

Benefits

Comp & perks

Health insurance
Retirement plans
Paid time off
Flexible work arrangements
Professional development