Chicago, Illinois, USA
33 days ago
Analyst, Commerce (CPG Client)

Company Description

About Spark Foundry:
 
Spark Foundry is a global media agency that exists to bring HEAT – Higher Engagement, Affinity, and Transactions – to brands. By combining flawless media fundamentals with aggressive innovation, Spark inspires consumers to pay more attention, to care more about our clients’ brands, and to buy more products and services from them.
 
Balancing the nimble spirit of a startup with the powerhouse soul of Publicis Media, Spark Foundry delivers the best of both worlds to a client roster that spans some of the world’s best and most beloved brands and companies. We combine boutique-caliber insights and service with the buying clout and first-look access of a global leader, bringing the heat to challenger brands that want to act like giants, and to giant brands that want to act like challengers.
 
With a bottom-up culture that celebrates diversity and aims for all voices to be heard, Spark has become a magnet for the industry’s best talent, with one of the best retention rates in the industry. And by applying a whole-person approach to professional and personal development, Spark develops a workforce that is well prepared for today’s challenges, and also poised to create meaningful careers in the years to come. 
 
Because we know that heat arises the intersection of complementary forces, our professionals come from myriad disciplines and backgrounds: data, analytics, and insights, content and creative production, communications and strategy, finance and marketing, and sociology, psychology, and other liberal arts disciplines.

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 campaignsResponsible for gathering necessary data for plan developmentBuild keyword and product campaigns across retail programsResponsible for presenting recommendations and applying client feedback to campaign proposalUpon campaign approval, responsible for building flowchart and loading authorized buys in PrismaGenerate paperwork necessary for purchase authorization and ensure vendor counter signature is receivedPrimary party responsible for trafficking approved plan for retail partnersPrimary party responsible for QA of all campaign components prior to launchMonitor and maintain campaign budgets, pacing, and bid adjustments to hit client KPIsProactively advocate for campaign adjustments based on performance trendsMonitor campaign performance and competitor landscapeDevelopment and implementation of optimizations and/or testing plansPulling and analyzing data to inform campaign reporting and develop strategic insights with clear actionable itemsBuild clear, concise, and cohesive quantitative analyses inclusive of strong data visualizationActively participate in client status and reporting calls, including presentation of reportingResponsible for granular maintenance of monthly billing cycle, including invoice tracking, buy actualization in Prisma, and draft compilation billing for manager approvalResponsible for resolving billing discrepancies in partnership with client strategy and billing reconciliation teamResponsible for learning all relevant tools for reporting, analytics, and competitive analysisDevelop strong working relationship with client teams and partner agencies (where applicable) by helping to create a seamless communications processEstablish professional, productive rapport with sales representatives/media vendorsDemonstrate creativity and agility when problem solvingWork closely with manager to establish priorities and manage workloadTimely delivery of all workSuccessful completion of training programs and requisite certifications

QualificationsSome Commerce/paid media experience preferredDemonstrated expertise in core MS Excel functions (vlookup, pivot tables) requiredKnowledge of the following is a plus: Amazon, Walmart, Target platforms AMS platform, AAP platform, Criteo, and/or Google AdsAmazon Retail Analytics (ARA), 3rd Party Digital Shelf Reporting, i.e. Clavis or EDGEComScore, HitwiseExcellent written and verbal communication skillsAbility to prioritize and organize projectsAbility to accurately apply principles of media mathDemonstrates initiative/”hunger”Collaborative approach/attitude

Additional Information

This is a hybrid role, requiring three days in-office each week. If you are contacted for an interview, your recruiter will discuss specifics with you, inclusive of any necessary reasonable accommodations.

If you require accommodation or assistance with the application or onboarding process specifically, please contact [email protected].

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

24-4848

Confirm your E-mail: Send Email