Mediabistro logo
job logo

Brand Media Coordinator

G&J Pepsi-Cola Bottlers, Inc. in · Columbus, OH, USA ·

Job type:
Full Time

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.

#J-18808-Ljbffr