This Analyst is responsible for uploading and facilitating all digital campaigns.  They are responsible for sending out IO's to vendors and pushing campaigns to the Ad Tech team so that they can traffic effectively. 

The role requires strong project management capabilities with someone who can be flexible managing multiple projects and strong excel skills.  This is a Digital Investment Operations desk.  This Associate is responsible for uploading and facilitating all digital campaigns.  They are responsible for sending out IO's to vendors and pushing campaigns to the Ad Tech team so that they can traffic effectively.  The associate can also be asked for help on ad hoc requests as well as monthly billing checks.

You could be working in a mix of Digital, National Video, and Print:

Digital:

• Campaign upload prep: supplier and T&Cs checks, vendor/ad server mapping
• Campaign upload: check/troubleshoot upload doc, upload buy into Prisma
• Issue IOs to vendors: attach correct T&Cs and IO notes, send IOs to vendors, confirm vendor acceptance
• Push to traffic: confirm correct server/site location, work with Ad Tech to troubleshoot
• Campaign stewardship/revisions: work with Investment to make changes as needed, issue revised IOs to vendors for approval
• Billing verification: weekly and monthly checks, troubleshoot any variances
• Invoice reconciliation: complete AMPDs, work with Reconciliation team to resolve discrepancies, work with Investment and vendors to clear accurately
• Reporting: pull ad hoc reports, as needed

National Video:

• Set up inventory in MBox: load estimates/packages/units manually and via Deal Exchange (cable); make changes as needed; ensure system is up-to-date
• Stewardship: monitor delivery; secure makegoods/ADUs for buys under-delivering
• Trafficking: ensure inventory is branded and confirm allocations to Traffic dept.
• Screen Program Content (if applicable for client): review screener reports and flag any concerns
• Post Buys: assemble performance/delivery data for a given quarter; compile into client deliverable
• Plan analysis: analyze vendor plans during negotiation/planning phase
• Billing verification: weekly and monthly checks, troubleshoot any variances
• Invoice reconciliation: assist Reconciliation team in resolving discrepancies
• Reporting: pull ad hoc reports, as needed

Print:

• Buy loading (from Action memos): use excel file to create text file, and upload it to OX for new buys and any buy revisions. Troubleshooting any errors with the Investment team.
• Issue IOs to vendors (Activity Report): send IOs from OX, confirm vendor acceptance
• Maintain vendor contact info: update the vendor contact info in OX (changes come from either the reps or Investment team)
• Create new estimate numbers in OX: manually input data from excel file into OX to create the estimate
• Invoice reconciliation: work with Reconciliation team to clear invoices/resolve discrepancies, make any necessary revisions in OX to clear discrepant invoices system

• Advanced English (B2+)
• Advanced Excel (conditional formatting, formulas (if, vlookups), pivot tables, other).
• 1-3 year of work experience Data Reporting or Finance
• Data-focused, exposed to and/or familiar with pulling and organizing data (does not require analyst-level skills)
• Detail oriented and well organized
• Ability to use web-based applications for tracking and reporting
• General comfort with accounting and bill/pay procedures
• SQL Server Management Studio, Prisma/MediaOcean, DataPlex/MDM (proprietary systems)
• Strong communication, analytics and problem-solving skills

Benefits

• Access to Prepaid Medical Plan
• Employee engagement activities and events
• Days of Work from Home
• Flexible Schedule
• Prodigious Academy
• Technical trainings, soft skills development, technical certifications, access to online libraries and e-learning platforms
• Find your path Program
• You will have a coach that will support and help you grow
• Level up Program

All your information will be kept confidential.