Brand Media Coordinator

G&J Pepsi-Cola Bottlers, Inc. • Columbus, OH

3d

About The Position

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

Requirements

• 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
• Personable and confident
• Bachelor's Degree or equivalent work experience required
• Strong skills with Microsoft Office Suite (i.e. Excel, Access, PowerPoint).
• 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.

Nice To Haves

• Experience in Access and Power BI a plus.
• Media experience preferred
• Previous media experience preferred

Responsibilities

• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level