Sorry, this listing is no longer accepting applications. Don’t worry, we have more awesome opportunities and internships for you.

Analyst, Commerce (Adult Beverage Client)

Spark Foundry

Analyst, Commerce (Adult Beverage Client)

Chicago, IL
Full Time
Paid
  • Responsibilities

    Job Description

    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.

    Role Objectives:

    • 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

    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

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

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

    #24-2226