20695-Assistant Analyst, Activation Operations

Omnicom Media; New York (NY); In loco; USD 45.000 - 55.000; Tempo pieno

Descrizione del lavoro

Omnicom Media is seeking an Assistant Analyst, Activation Operations to track and process media inventory using internal tools and media systems. The role emphasizes data integration from multiple sources to produce reports that drive financial inputs, with strong attention to detail and team collaboration in a fast-paced environment.

The position supports multiple departments at Orion by overseeing media buys and reconciliation, requiring proactive communication and reliable delivery of reports

Competenze

• Exceptional organizational skills with a high attention to detail.
• Excellent written and verbal communication skills.
• Analytical mindset and accuracy in task execution.
• Ability to thrive in a fast-paced environment and meet deadlines.
• Team player with integrity and reliability.
• Proficient in Microsoft Excel (VLOOKUP, SUMIFS, PIVOT).
• Experience with MediaOcean products is a plus.

Mansioni

• Review and send orders to vendors using internal tools.
• Input and steward media schedule data into Prisma & MBOX.
• Prepare and distribute monthly capital billing reports for Digital media buys.
• Perform monthly invoice matching within Prisma/MediaOcean.
• Collaborate with Shared Services and Financial Operations to resolve discrepancies.
• Support process automation and cross-functional improvements.
• Maintain positive professional relationships with Orion staff.
• Assist with ad hoc operations requests.

Conoscenze

Organizational skills

Attention to detail

Written communication

Verbal communication

Analytical mindset

Team player

Prioritization

Fast-paced environment

Strumenti

MediaOcean

MBOX

Excel (VLOOKUP, SUMIFS, PIVOT)

Descrizione del lavoro

Position Summary

The Assistant Analyst, Activation Operations is responsible for tracking and processing media inventory, utilizing media systems tools. Ideal candidate must be comfortable integrating data from different sources to produce reports that will drive financial and business inputs. This position requires attention to detail, proactivity, analytical mindset, strong communication skills, alongside working well in a team environment. Candidates are expected to be curious, self‑motivated, and meet deadlines in a fast‑paced environment. This role supports various departments at Orion by overseeing media buys and reconciliation.

Agency

Omnicom Media

Job Function

Media

Job Subfunction

Trading and Investment

Job Description

Position Summary

The Assistant Analyst, Activation Operations is responsible for tracking and processing media inventory, utilizing media systems tools. Ideal candidate must be comfortable integrating data from different sources to produce reports that will drive financial and business inputs. This position requires attention to detail, proactivity, analytical mindset, strong communication skills, alongside working well in a team environment. Candidates are expected to be curious, self‑motivated, and meet deadlines in a fast‑paced environment. This role supports various departments at Orion by overseeing media buys and reconciliation.

Responsibilities

• Utilize internal tools to review and send orders to vendors and support maintenance of tracking client spends.
• Input and steward media schedule data into Prisma & MBOX
• Prepare and distribute monthly capital billing reports based on Digital media buys/orders
• Perform monthly invoice matching within Prisma
• Collaborate with our Shared Services and Financial Operations teams to reconciling billing and invoice discrepancies
• Participate with Operations to streamline and automate processes across the business
• Establish a positive and professional working relationship with all Orion staff
• Assist with ad hoc operations requests

Required Skills & Experience

• Exceptional organizational skills with a high attention to detail
• Excellent written and verbal communication skills
• Analytical Mindset
• Thrives on accomplishing tasks accurately and efficiently
• Maintain a high level of integrity and be a team player
• Ability to prioritize, shift attention when prompted, and work in a fast‑paced environment
• Proficient in Microsoft Office Suite (Excel requirements: VLOOKUP, SUMIFS, PIVOTS, etc.)
• Experience with MediaOcean products a plus

Essential Functions

• Utilize Excel templates and internal databases to create Orion specific documents (flowcharts, MSAs, Insertion Orders, etc.)
• Input and steward media schedule data into MediaOcean/MBOX (Estimate Creation, p-headers, EDIs, etc.)
• Prepare and distribute monthly capital billing reports based on media buys/orders for Linear and Digital Extensions
• Perform monthly invoice matching within MediaOcean
• Collaborate with our Shared Services and Financial Operations teams to reconciling billing and invoice discrepancies
• Participate with Operations to streamline and automate processes across the business
• Establish a positive and professional working relationship with all Orion staff
• Assist with ad hoc operations requests

Qualifications

Skills:

• Exceptional organizational skills with a high attention to detail
• Excellent written and verbal communication skills
• Analytical Mindset
• Thrives on accomplishing tasks accurately and efficiently
• Maintain a high level of integrity and be a team player
• Ability to prioritize, shift attention when prompted, and work in a fast‑paced environment
• Proficient in Microsoft Office Suite (Excel requirements: VLOOKUP, SUMIFS, PIVOTS, etc.)
• Experience with MediaOcean products a plus

Business Rationale For Assistant Analyst, Activation Operations Support

• Inability to offshore certain accounts to GCC
  • USPS, JAMRS & Navy Federal Credit Union identified as government accounts. These will need to be fully uploaded and revised by our onshore team, with potential for this list to grow.
  • Tight SLAs - Certain accounts (like the Entertainment category) will have extremely tight turnaround times. For an “emergency” workflow faster than GCC SLAs will need to be processed onshore.
• Social Principle Deals
  • New media type for Orion activating in the principle-based buying approach. Social has already been a large task for the team. There has been a huge spike in volume already, due to demand for savings on key platforms like Snapchat & TikTok.
• Prisma Maintenance
  • Dual Cost functionality not automatically selected so each line item needs maintenance prior to checking GCC work
  • Comparing IO received in Sellers and modifying monthly allocations for accuracy. Due to the two CPMs both calculating the billable & payable costs off of one impression number, an exact match on the payable can cause a rounding error on the billable, taking time for onshore teams to analyze and update.
  • Updating any discrepancies against GCC upload
• Vendor issues/correspondence
  • Since Orion is issuing the IOs, we are the contacts for any issues with terms, data, or campaign details. If anything was sent incorrectly, we now have to carve out extra time to provide feedback to the agency
• Orion communication
  • Orion to reach out to agency for plans and need alignment from Client Strategy and Investment prior to any IOs being issued
  • Maintenance of an Orion tracker for all buys to associate the Orion IO to the AOR IO and identify participating billings
  • Identifying billings in Prisma and making adjustments on the DT as buys are going through reconciliation

$50,000-$50,000

To the extent permissible by local law, Omnicom’s policy requires employees to work in the office for a minimum of three days a week, unless additional in-office days are directed by their agency or manager.

Omnicom is committed to hiring and developing exceptional talent. We agree that talent is uniquely distributed, and we’re focused on developing inclusive teams that can bring the best solutions to everything we do. We strongly believe that celebrating what makes us different makes us better together. Join us—we look forward to getting to know you. We will process your personal data in accordance with our Recruitment Privacy Notice.

Link to Recruitment Privacy Notice: https://www.omc.com/privacy-notice

For US Job Seekers

It is the policy of Omnicom and any of its affiliates to provide equal employment opportunities to all employees and applicants for employment without regard to race, religion, color, ethnic origin, gender, gender identity, age, marital status, veteran status, sexual orientation, disability, or any other basis prohibited by applicable federal, state, or local law. EOE/AA/M/D/V/F.

$50,000-$50,000