20695-Assistant Analyst, Activation Operations

Agency: Omnicom Media Job Function: Media Job Subfunction: Trading and Investment Job Description:

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.

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