Analyst, Commerce (QSR Client)

Publicis Groupe Holdings B.V

Chicago (IL)

On-site

USD 54,000 - 72,000

Full time

8 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Spark Foundry, part of Publicis Groupe, is seeking a Commerce Analyst to own day-to-day commerce media for assigned brands and to support campaign development, activation, and optimization. The analyst will work with their Manager to translate client objectives into actionable recommendations and reporting.

Responsibilities include building campaigns, analyzing keyword and product data, trafficking plans in Prisma, and delivering clear quantitative analyses with strong data visualization to

Qualifications

  • Commerce/paid media experience preferred.
  • Proficient in advanced Excel (VLOOKUP, Pivot Tables).
  • Experience with Amazon, Walmart, Target platforms and digital ad platforms such as AMS/AAP, Criteo, Google Ads.
  • Excellent written and verbal communication; ability to prioritize and organize projects.

Responsibilities

  • Gather and analyze keyword, competitive, and level research to build campaigns.
  • Develop data for plan development and load buys in Prisma.
  • Build campaigns across retail programs and present recommendations.
  • Monitor budgets, pacing, and bid adjustments to hit KPIs.
  • Provide actionable insights with clear data visualizations in reports.

Skills

Commerce/paid media experience
Excel proficiency
Excellent written and verbal skills
Prioritization and organization
Data-driven problem solving

Tools

AMS platform
AAP platform
Google Ads
Criteo
Amazon Retail Analytics (ARA)
Excel (VLOOKUP, Pivot Tables)

Job description

Company description

Spark Foundry was built during the most transformative time in the history of advertising and marketing. We deliver everything a traditional media agency has to offer and have grown into one of the world’s most successful agencies by helping brands evolve their marketing by leveraging identity, commerce, artificial intelligence, and more to connect with people. Transformation is part of our DNA. Spark Foundry’s start-up spirit delivers high-touch approaches and a never-ending desire to challenge the status quo. Combined with Publicis Media’s powerhouse soul leveraging connected data assets, advanced AI applications, and investment clout, we “Bring HEAT to Brands.” No other agency possesses the expertise that we do to address today’s most pressing challenges to drive business transformation through media.

Overview

The Commerce Analyst is the day-to-day steward of Commerce media for assigned brands, and is responsible for monitoring and maintaining campaign development, activation, and innovation. The Analyst will develop and maintain strong knowledge of their client businesses and apply Commerce understanding to help deliver against their needs/objectives. They will work closely with their Manager in the development and communication of all recommendations.

Responsibilities
  • Gather and analyze keyword, competitive, and level research necessary to build new campaigns
  • Responsible for gathering necessary data for plan development
  • Build keyword and product campaigns across retail programs
  • Responsible for presenting recommendations and applying client feedback to campaign proposal
  • Upon campaign approval, responsible for building flowchart and loading authorized buys in Prisma
  • Generate paperwork necessary for purchase authorization and ensure vendor counter signature is received
  • Primary party responsible for trafficking approved plan for retail partners
  • Primary party responsible for QA of all campaign components prior to launch
  • Monitor and maintain campaign budgets, pacing, and bid adjustments to hit client KPIs
  • Proactively advocate for campaign adjustments based on performance trends
  • Monitor campaign performance and competitor landscape
  • Development and implementation of optimizations and/or testing plans
  • Pulling and analyzing data to inform campaign reporting and develop strategic insights with clear actionable items
  • Build clear, concise, and cohesive quantitative analyses inclusive of strong data visualization
  • Actively participate in client status and reporting calls, including presentation of reporting
  • Responsible for granular maintenance of monthly billing cycle, including invoice tracking, buy actualization in Prisma, and draft compilation billing for manager approval
  • Responsible for resolving billing discrepancies in partnership with client strategy and billing reconciliation team
  • Responsible for learning all relevant tools for reporting, analytics, and competitive analysis
  • Develop strong working relationship with client teams and partner agencies (where applicable) by helping to create a seamless communications process
  • Establish professional, productive rapport with sales representatives/media vendors
  • Demonstrate creativity and agility when problem solving
  • Work closely with manager to establish priorities and manage workload
  • Timely delivery of all work
  • Successful completion of training programs and requisite certifications
Qualifications
  • Some Commerce/paid media experience preferred
  • Demonstrated expertise in core MS Excel functions (vlookup, pivot tables) required
  • Knowledge of the following is a plus:
    • Amazon, Walmart, Target platforms
    • AMS platform, AAP platform, Criteo, and/or Google Ads
    • Amazon Retail Analytics (ARA), 3rd Party Digital Shelf Reporting, i.e. Clavis or EDGE
    • ComScore, Hitwise
  • Excellent written and verbal communication skills
  • Ability to prioritize and organize projects
  • Ability to accurately apply principles of media math
  • Demonstrates initiative/”hunger”
  • Collaborative approach/attitude
Additional information

Our Publicis Groupe motto “Viva La Différence” means we’re better together, and we believe that our differences make us stronger. It means we honor and celebrate all identities, across all facets of intersectionality, and it underpins all that we do as an organization. We are focused on fostering belonging and creating equitable & inclusive experiences for all talent.

Publicis Groupe provides robust and inclusive benefit programs and policies to support the evolving and diverse needs of our talent and enable every person to grow and thrive. Our benefits package includes medical coverage, dental, vision, disability, 401K, as well as parental and family care leave, family forming assistance, tuition reimbursement, and flexible time off.

If you require accommodation or assistance with the application or onboarding process specifically, please contact USMTTACompliance@publicis.com.

All your information will be kept confidential according to EEO guidelines.

#LI-MS6

Compensation Range: USD $53,960.00 - USD $71,610.00/Annually. This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. Temporary roles may be eligible to participate in our freelancer/temporary employee medical plan through a third-party benefits administration system once certain criteria have been met. For regular roles, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off. The Company anticipates the application deadline for this job posting will be 1/4/2027.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Analyst, Commerce (CPG client)
Analyst, Commerce (CPG client)

Publicis Groupe Holdings B.V • New York (NY)

On-site
USD 54,000 - 80,000
Medical coverage
Dental coverage
Vision coverage
+4
Senior Analyst, Commerce/Retail Media
Senior Analyst, Commerce/Retail Media

Publicis Groupe • Chicago (IL)

On-site
USD 66,000 - 91,000
Senior Analyst, Commerce
Senior Analyst, Commerce

Publicis Groupe • Chicago (IL), New York (NY)

On-site
USD 66,120 - 91,350
Medical coverage
Dental and vision care
401K plan
+1
Senior Analyst, Commerce
Senior Analyst, Commerce

Connect at Publicis Media • Chicago (IL)

On-site
USD 66,785 - 101,085
Medical coverage
401K
Flexible time off
+1
Manager, Commerce
Manager, Commerce

Publicis Groupe • Chicago (IL)

On-site
USD 81,000 - 117,000
Medical coverage
Dental and vision
401(k) plan
+3
Senior VP, Commerce & Growth Strategy
Senior VP, Commerce & Growth Strategy

Publicis Groupe • Chicago (IL)

Hybrid
USD 180,000 - 269,000
Medical coverage
Dental and vision benefits
401K and parental leave
Manager, Commerce
Manager, Commerce

Publicis Groupe • Chicago (IL)

On-site
USD 81,225 - 116,655
Manager, Commerce (AlchBev)
Manager, Commerce (AlchBev)

Publicis Groupe Holdings B.V • Chicago (IL)

On-site
USD 81,000 - 117,000
Medical coverage
401K
Paid time off
Associate Director
Associate Director

Publicis Groupe • Chicago (IL), New York (NY)

On-site
USD 107,000 - 153,000
Medical coverage
Dental
Vision
+2
SVP, Commerce, Amazon
SVP, Commerce, Amazon

Publicis Groupe • Chicago (IL)

On-site
USD 140,000 - 200,000
Medical coverage
Dental
Vision
+3