Brand Media Coordinator

G&J-Pepsi-Col; Columbus (OH); On-site; USD 48,000 - 64,000; Full time

Job summary

G&J-Pepsi-Col, based in Columbus, OH, seeks a Brand Media Coordinator to support the in-house Media team in a fast-paced setting.

The role requires strong numeracy, detail orientation, and the ability to multi-task while collaborating with prestige customers and media outlets. Experience with Power BI and MS Office is preferred.

Qualifications

• Bachelor's Degree or equivalent work experience required.
• Strong numeracy and attention to detail.
• Experience with Power BI and Microsoft Office preferred.

Responsibilities

• Produce weekly PowerBI reports to track ROI on promos.
• Enter media buys into database to create insertion orders.
• Track and manage all budget files with Brand and Media teams.
• Coordinate with vendors for invoice processing and reconciliation.
• Assist with monthly media reimbursements and audits.

Skills

Numeracy

Detail oriented

Self-starter

Multitasking

Communication

Education

Bachelor's Degree or equivalent

Tools

PowerBI

Excel

PowerPoint

Access

Job description

Posted Tuesday, September 8, 2026 at 4:00 AM

POSITION SUMMARY

The Brand Media Coordinatoris a key role working to support the in-house Media team. Positioned within a fast-paced environment that requires the candidate to be a self-starter, ability to multi-task, detail oriented, sense of urgency, highly numerate and have the skill set to work collaboratively both internally and externally with prestige customers and media outlets.

ESSENTIAL FUNCTIONS

Reasonable Accommodations Statement

To accomplish this job successfully, an individual must be able to perform, with or without reasonable accommodation, each essential function satisfactorily. Reasonable accommodations may be made to help enable qualified individuals with disabilities to perform the essential functions.

Essential Functions Statement(s)

• Weekly reporting from PowerBI
  • Provide Marketing team with tracking reports to track ROI on promos
• Capture media buys into database to create insertion orders
• Assist with tracking and managing all budget files with the Brand and Media teams
• Send insertion and broadcast orders to vendors/stations
• Work with parent companies on monthly media reimbursements and reconciliations
• Keep track of all billing and responsible for providing accounting with monthly billing
• Keep track that all invoices are accounted for on a monthly basis
• Track and check media invoices and address billing discrepancies with media vendors and approve vendor invoices in database
• Work with accounting department to confirm receipt of all invoices and reconcile invoices when necessary
• Traffic media materials (TV, Radio, Print, and Outdoor) to media outlets
• Monthly media audits
• Manage all coupon requests for the whole company and all invoices associated with those orders
• Assist with Ticketing tracking as needed
• Assist with updating recap decks as programs are developed and after they conclude.
• Maintains confidentiality of financial information, customer information and other sensitive and confidential information.
• Works assigned schedule, exhibits regular and predictable attendance and works outside of normal schedule as required to meet workload demands. Performs other related duties as required.

POSITION QUALIFICATIONS

SKILLS & ABILITIES

• Highly numerate with strong attention to detail
• Self-starter, self-motivated, can deliver to tight deadlines
• An understanding of the finance process and billing process.
• Extremely competent in Microsoft Office applications, strong Excel and PowerPoint
• Experience in Access and Power BI a plus.
• Personable and confident

Education:

Bachelor's Degree or equivalent work experience required

Experience:

Computer Skills:

Strong skills with Microsoft Office Suite (i.e. Excel, Access, PowerPoint).

Certifications &
Licenses:

Other Requirements:

Knowledge of: Microsoft Office Suite including Access, Excel, and PowerPoint.

Skill: internal and external customer service. Ability to: work quickly, efficiently and independently; multi-task; prioritize; be detail oriented; meet deadlines in a pressured situation; communicate effectively with other employees and develop good working relationships; read and understand sales and financial reports; adapt to change; problem solve; operate a computer, copier, printer; read and write. Other functions, skills and abilities may also apply.