The Role
Manage Amazon Marketing Cloud data pulls and SQL queries, maintain reporting and dashboards, support DSP and cross-channel analytics, analyze path-to-conversion and audience insights, and collaborate with strategists and execution teams to turn insights into actions.
Summary Generated by Built In
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 Required
- Experience with Amazon Marketing Cloud (AMC) and clean room operations
- Proficiency writing and maintaining SQL queries
- Experience building and maintaining reports and dashboards tracking campaign performance and ROAS
- Experience with Amazon DSP and cross-channel advertising analytics
- Path-to-conversion, funnel analysis, and audience profiling experience
- Ability to prepare data and visualizations for partner reviews and business reviews
- Experience collaborating with cross-functional teams and external/remote execution teams
Pattern Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Pattern and has not been reviewed or approved by Pattern.
-
Equity Value & Accessibility — Equity is broadly offered and described as generous, with RSU sharing and access to stock included in total compensation. Equity availability is positioned as a core element for employees across the company.
-
Leave & Time Off Breadth — Unlimited PTO, paid holidays, paid parental leave, and paid sick days indicate a wide-ranging time-off policy. These offerings create breadth for both vacation needs and family-related leave.
-
Retirement Support — A 401(k) with a fully vested company match from day one (up to 4%) strengthens long-term financial security. Immediate vesting underscores emphasis on retirement benefits.
Pattern Insights
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Pattern operates as a worldwide e-commerce growth, protection, control, and distribution platform for brands. Pattern® provides a proven blend of marketplace analytics, product distribution, MAP compliance, and brand management to drive ecommerce acceleration for premium brands. We thrive on high energy, professional excellence, and disciplined creativity.
