Brand Media Coordinator

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

POSITION SUMMARY

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
• Media experience preferred

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.

Education:

Bachelor's Degree or equivalent work experience required

Experience:

Previous media experience preferred

Computer Skills:

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

Other Requirements:

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