Advanced Analytics Executive, GOC
The Advanced Analytics Executive role at WPP Media involves collaborating with the U.S. team to develop and apply advanced econometric models. The primary focus is to analyze the impact of economic, external, and media factors on key performance indicators (KPIs) for clients across various industries, including technology, retail, and services. This position is crucial for transforming complex data into actionable insights that enhance clients' media and business strategies.
Key responsibilities include processing, cleaning, and structuring large volumes of client data using SQL on the Google BigQuery platform to ensure data quality and availability. The role also involves conducting monthly estimations of the contribution of paid media variables and other factors to client KPIs using R, developing and applying Marketing Mix Modeling (MMM) models, providing in-depth analysis of the "Fast MMM" process, presenting modeling results to clients and agencies, and delivering model outputs for data visualization dashboards on platforms like BigQuery and Tableau.
Candidates should possess a university degree in Economics, Statistics, Mathematics, Engineering, or related fields with a strong quantitative component. The role requires 0 to 1 year of 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 or Tableau, and advanced English proficiency (B2/C1 level or higher) to work directly with U.S. teams.
WPP Media offers a dynamic work environment with opportunities for professional growth and development. Employees have access to internal learning platforms, certifications, and training sessions. The company provides life insurance, wellness programs, significant paid time off, preferential partner discounts, and employee mental health awareness days. The position is available in a remote or hybrid work modality within Colombian territory, requiring candidates to reside in Colombia with a valid work permit.