Brand Media Operations & Analytics Specialist

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

Job summary

G&J Pepsi-Cola Bottlers, Inc. is seeking a Brand Media Coordinator to support our in-house Media team in Columbus. The role requires a self-starter with strong numeracy, attention to detail and the ability to multi-task in a fast-paced environment.

Responsibilities include weekly PowerBI reporting, tracking media buys and budgets, processing orders with vendors, and reconciling invoices. Experience with Excel, PowerPoint and Power BI is a plus, and a Bachelor’s degree or equivalent is required.

Qualifications

• Bachelor's Degree or equivalent work experience required.
• Previous media experience preferred.
• Strong skills with Microsoft Office Suite (Excel, Access, PowerPoint).

Responsibilities

• Weekly reporting from PowerBI.
• Capture media buys into database to create insertion orders.
• Track and manage all budget files with the Brand and Media teams.
• Send insertion and broadcast orders to vendors/stations.
• Track media invoices and address billing discrepancies.
• Maintain confidentiality of financial and customer information.

Skills

Numerate

Detail-oriented

Self-starter

Billing process understanding

Excel

PowerPoint

Power BI

Access

People skills

Media experience

Education

Bachelor's Degree or equivalent

Tools

Microsoft Office

Excel

PowerPoint

Access

Power BI

Job description

G&J Pepsi-Cola Bottlers, Inc. is seeking a Brand Media Coordinator to support our in-house Media team in Columbus. The role requires a self-starter with strong numeracy, attention to detail and the ability to multi-task in a fast-paced environment.

Responsibilities include weekly PowerBI reporting, tracking media buys and budgets, processing orders with vendors, and reconciling invoices. Experience with Excel, PowerPoint and Power BI is a plus, and a Bachelor’s degree or equivalent is required.