Media Campaign Analyst (Remote/Virtual)

Analytics Los Angeles, CA San Francisco, CA


Description

WorkReduce, the largest technology-enabled services provider for the media buying industry, is looking for a Media Campaign Analyst. As a skilled communicator, the Media Campaign Analyst will partner with internal and external stakeholders and data providers to enable spending optimization by leveraging analytics and measurement.

This is a full-time, hourly, temporary role lasting approximately three months with a high possibility of extension. The Media Campaign Analyst will build an understanding of digital and media ecosystems including challenges of data tracking with OTT and streaming apps, cookies/SDK’s, website tagging options, impact of walled gardens, and basic TV and OOH measurement and attribution options.

About WorkReduce

We serve brands and agencies as a distributed team of media and technology experts operating through the WorkReduce platform. We are committed to providing employment that pays well, expands access to jobs and training, and makes a difference. We hire people who share our values of transparency, inclusivity, dedication, and fairness. 

What we’d like you to do:

  • Develop deep understanding of client’s industry, business objectives and strategy, media plans, and consumer journey to provide context for analysis and reporting needs 
  • Help develop measurement plans tying KPI’s to business objectives at a tactical level 
  • Build an understanding of digital and media ecosystems including challenges of data tracking with OTT and streaming apps, cookies/SDK’s, website tagging options, impact of walled gardens, and basic TV and OOH measurement and attribution options available 
  • Collaborate with internal/external stakeholders and manage data logistics – including data specifications, structures, rules and transfers from numerous media channels and partners 
  • Act as a project manager on analyses of limited scope/complexity, delegating select tasks such as data prep and QC  
  • Conduct in-depth analyses and reporting leveraging Excel, including ability to:  
  • Create macros to clean data from different workbooks and automate repetitive tasks 
  • Use IF, THEN, SUMPRODUCT, OFFSET, etc to create more advanced reports  
  • Pull data from external data sources using Excel’s ODBC connectors 
  • Create more advanced pivot tables using calculated fields 
  • Exhibit problem-solving capability and an ability to work more independently 
  • Demonstrate ability to interpret/synthesize analysis findings and draw insights pertinent to the client’s business; show ability to develop actionable recommendations 
  • Play a role in the development of report content (Word, Excel, PowerPoint) in support of deliverables 
  • Participate in the presentation of results to internal and external stakeholders 
  • Handle some of the day-to-day contact and interaction with internal and external stakeholders associated with project work 
  • Effectively manage time in order to meet deadlines with high-quality outputs on a larger workload; demonstrate ability to multitask 

What we’re looking for:

  • Strong business analytics skills and familiarity with digital, OTT, and linear media analytics. 
  • Bachelor’s degree typically in a quantitative discipline (e.g., Statistics, Economics, Mathematics, etc.) 
  • Minimum of 12-18 months of experience in a professional services or corporate environment 
  • Higher level of proficiency with at least two of the following tools - Excel, Tableau 
  • Facility with MS Office; including PowerPoint, Word and Excel 
  • Experience with ad-serving platforms such as Google Campaign Manager; Floodlight tagging; web analytics tools such as Google Analytics and Adobe Analytics, and tag management tools such as DTM/Launch, GTM and Tealium 
  • Excellent verbal and written communication skills 
  • Highly motivated and collaborative team player with strong interpersonal skills 
  • Familiarity with various online and offline media channels 

Nice to haves:

  • Experience with TV attribution solutions such as VideoAmp, creative/brand evaluation and tracking tools like Kantar Millward Brown (specifically their cross-channel tool);  
  • Advanced degree typically in a quantitative discipline 
  • Prior media analytics experience/knowledge 
  • Experience with DMPs such as Salesforce/Krux 
  • Familiarity with media mix modeling and other forms of regression-based ROI; A/B and multivariate test design 

What you can expect from WorkReduce:

WorkReduce provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

WorkReduce does not accept unsolicited resumes from third-party recruiters without a signed agreement on file with WorkReduce. Third-party recruiters include agencies, organizations, or individuals recruiting candidates for temporary, part-time or full-time opportunities other than for their own needs.  

WorkReduce will not pay a fee to a third-party recruiter for any resumes or CV’s submitted to any employee that does not have a signed agreement with WorkReduce. The agreement must be dated no earlier than one year previous to the date of resume submission. Candidate introductions, resumes or CV’s must only be submitted via the WorkReduce recruiting team and only if a) an agreement is already in place and b) the third-party recruiter has received formal instruction from a member of the recruiting team to submit candidates to a vacancy. 

We are not able to sponsor candidates requiring work authorization.