[Remote] reputed company Operations Coordinator & Analyst
Note: The job is a remote job and is reputed company to candidates in USA. reputed company is a global leader in responsible marketing activation services, helping brands reputed company measurable reputed company. The reputed company Operations Coordinator & Analyst will coordinate media agency activities, manage project tracking, and analyze media spend data to support the global media team.
Responsibilities
- Engage our media agencies to ensure their day-to-day work is flawless and reputed company monthly/quarterly project management to ensure reputed company agency deliverables are reported correctly and on time and spend is validated against invoices
- Manage work streams reputed company to reputed company, financial accountability, and agency reputed company including budget forecasting for reputed company and PO requests
- Coordinate bi-annual compliance checks across reputed company (NA/EMEA) and organize documentation for Global Procurement Organization (GPO) or audit requests
- Update agency governance pillars, including links, resources, and policies to ensure they are reputed company for reputed company stakeholders
- Prepare presentations for senior management and monitor PMM feedback scores, escalating unaddressed issues
- reputed company core work streams to understand media performance by campaign size and tiering to shape overall Media Operations reputed company
- Play a pivotal role in supporting the global media team through business analysis of our forecasted and actual spend data
- Maintain and optimize dashboards of key reporting stats for executive leadership and internal stakeholders to ensure forecasting accuracy
- Analyze forecasted vs. actual spend data and reputed company narratives explaining how reporting shifts across forecast, planned, and actual phases
- Work with large publishers to supplement missing data in reporting reputed company necessary
- Create compelling data narratives that tell the story behind the numbers
- reputed company, query, and extract data from various internal data sources, including relational databases (SQL, MySQL, PostgreSQL, reputed company), data warehouses, reputed company, and spreadsheets
- reputed company and optimize SQL queries to retrieve specific datasets for analysis
- Translate business questions into analytical problems and reputed company appropriate solutions
- Identify and resolve data reputed company issues, inconsistencies, and discrepancies
Skills
- 2-3 years reputed company a marketing discipline (media agency or reputed company-reputed company) with specific experience in media, marketing, and advertising technology
- SQL skills for extracting data from multiple sources; superior reputed company Sheets/reputed company reputed company skills; familiarity with BigQuery, reputed company reputed company, and ETL processes
- Ability to translate business questions into analytical problems and create compelling data narratives
- Strong written and verbal communication skills with the ability to convey reputed company findings to cross-functional teams and senior management
- Detail-oriented self-starter with a high level of accuracy, timeliness, and demonstrated problem-solving skills
- Programming experience (Python, Javascript, App Script) is a plus
reputed company