Brand Media & ROI Analytics Coordinator

G&J Pepsi-Cola Bottlers, Inc. in; Columbus (OH); On-site; USD 55,000 - 75,000; Full time

Job summary

G&J Pepsi-Cola Bottlers, Inc. seeks a Brand Media Coordinator to support the in-house Media team.

The candidate should be a self-starter with strong numerical skills, detail orientation, and the ability to work collaboratively with prestige customers and media outlets. Responsibilities include weekly PowerBI reports, managing insertion orders, tracking budget files with Brand and Media teams, and coordinating billing and invoices with accounting.

Qualifications

• Bachelor's Degree or equivalent work experience required
• Strong Excel and PowerPoint skills
• Understanding of finance and billing processes

Responsibilities

• Weekly ROI reporting from PowerBI and providing tracking reports to Marketing
• Capture media buys into database to create insertion orders
• Assist with tracking and managing budget files with Brand and Media teams
• Send insertion and broadcast orders to vendors and stations
• Work with accounting on monthly media reimbursements and reconciliations
• Track and reconcile invoices and ensure timely payments
• Traffic media materials to outlets (TV, radio, print, outdoor) and perform media audits
• Manage coupon requests and related invoices

Skills

Highly numerate

Self-starter

Finance & billing

Excel

PowerPoint

Access

Power BI

Customer service

Education

Bachelor's Degree or equivalent

Tools

Power BI

Microsoft Office Suite

Job description

G&J Pepsi-Cola Bottlers, Inc. seeks a Brand Media Coordinator to support the in-house Media team.

The candidate should be a self-starter with strong numerical skills, detail orientation, and the ability to work collaboratively with prestige customers and media outlets. Responsibilities include weekly PowerBI reports, managing insertion orders, tracking budget files with Brand and Media teams, and coordinating billing and invoices with accounting.