An Administrative Clerk or Coordinator performs administrative work in an office. Coordinates work to support an office team. Works in a wide variety of office settings, such as a company or business, or a government office or school. Manages paper and electronic files, uses office equipment including computers, responds to phone calls and emails. May manage office staff expenses, supplies or schedules.
Brand Media Coordinator G&J Pepsi-Cola Bottlers, Inc. - 3.0 Columbus, OH Job Details Full-time 13 hours ago Qualifications Computer operation Computer literacy Copy machines Internal employee customer service Financial report interpretation Productivity software Full 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
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).
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.
