Brand Media 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

The Brand Media Coordinator is 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.