Advanced Analytics Executive, GOC

Jefferson County, CO (Remote)

Salary Not AvailableSenior Level1+ years expFull time

Posted 4 months ago

Top 1% of applicants do these two things.

The other 99% submit and hope. You're about to do something different.

Job Summary

Drive MMM-based data science for media optimization at WPP Media, focusing on data processing, econometric modeling, and client-facing insights.

  • Process and model large client data sets using SQL/BigQuery and R to deliver MMM outputs.
  • Must-have: Advanced R modeling skills and SQL proficiency.
  • Standout: Experience with marketing mix modeling and dashboards in Tableau/BigQuery.

Job Description

Responsibilities

  • Data Processing and Management: Process, clean, and structure large volumes of client data using SQL Standard on the Google BigQuery platform, ensuring data quality and availability for analysis.
  • Advanced Econometric Modeling: Conduct monthly estimations of the contribution of Paid Media variables and other factors (economic, external) to client KPIs, utilizing R as the primary tool for model development.
  • Media Optimization (Marketing Mix Modeling - MMM): Develop and apply MMM models using R and internal company platforms to optimize clients' media portfolios.
  • Insights Analysis and Added Value: Provide in-depth analysis of the "Fast MMM" process each month, identifying key business decisions and delivering added value through actionable insights for media strategy.
  • Strategic Results Presentation: Create and present clear and concise modeling results to clients and agencies, leveraging data visualization tools to highlight key findings, insights, and recommendations.
  • Dashboard Input Generation: Deliver model outputs and files for use in the creation and updating of data visualization dashboards on platforms such as BigQuery and Tableau.

Requirements

  • Educational Background: University degree in Economics, Statistics, Mathematics, Engineering, or related fields with a strong quantitative component.
  • Professional Experience: 0 to 1 year of demonstrable experience in applying econometric models.
  • Advanced proficiency in R for statistical analysis and modeling.
  • Knowledge and experience in Python.
  • Mastery of SQL for database manipulation and querying.
  • Familiarity with data visualization tools such as Power BI, Tableau, or similar.
  • Languages: Advanced English proficiency (B2/C1 level or higher), as you will work directly with U.S. teams.

    Benefits

    • Life insurance
    • Wellness programs
    • Significant paid time off
    • Preferential partner discounts
    • Employee mental health awareness day
    • Access to internal learning platforms, certifications, and training sessions
    WPP Media logo

    WPP Media

    Media is changing. So are we. We are WPP's global media collective, built for the AI era.We bring the best platform, people, and partners together to create innovative solutions that deliver unparalleled growth for brands - in every market, every day.

    30K employees (6,827 in marketing)

    Traffic Signals

    Monthly Visitors
    159.3K
    Monthly Google Ads Budget
    $9.9K
    Traffic Source Mix
    Search
    34.3%
    Direct
    46.3%
    Referral
    10.7%
    Social
    5.7%
    Paid
    2.7%

    Headcount Trend

    Current headcount: ~30.1K

    Marketing Team

    Marketing Team Size
    6,288 (21% of company)
    Median Career Experience
    10 years
    Median Tenure
    4.2 years
    Marketing Roles Posted (Last 30 Days)
    21