Senior Associate, Data Analytics & Business Intelligence (BI), GOC

Barranquilla, Colombia; Bogota, Colombia; Medellin, Colombia; Mexico City, Mexico. Posted a month ago

The role

This person will design, build and maintain cloud-based data solutions for business intelligence and media performance reporting. They will work with data engineers, developers and business intelligence teams, and report to the US-based Associate Director.

What you will do

Design, build and maintain cloud-based data solutions.
Develop data pipelines and workflows for client reporting projects.
Define and document reporting and visualization requirements with BI and Data Operations teams.
Ensure data quality and support existing workspaces.
Onboard new client teams to cloud data solutions.
Define QA guidelines and automate quality assurance processes.
Act as subject matter expert in data quality, BI tools and business rules.
Coordinate status meetings and track tasks and deliverables across projects.
Identify, escalate and resolve project roadblocks and delivery issues.
Report project status, progress and risks to the Associate Director.

Required qualifications

At least 2–3 years of experience in data governance within data warehousing, ETL and business intelligence.
Experience with the full development lifecycle of a reporting solution, from design through deployment.
Advanced knowledge of SQL, relational databases and data warehouses such as MySQL, PostgreSQL, Redshift or Snowflake.
Advanced proficiency in at least one programming language, such as Python.
Knowledge of a cloud platform such as Microsoft Azure, Google Cloud Platform or AWS.
Knowledge of a data engineering platform such as Databricks.
Familiarity with a BI tool such as Tableau or Power BI.
Familiarity with project tools such as Jira, Confluence, Smartsheet or Azure DevOps.
Understanding of digital, search, social and offline media processes, including paid and owned media data.
Strong attention to detail and commitment to data accuracy.
Excellent verbal and written communication skills.
Strong organizational and prioritization skills.

Nice to have

3–4 years of relevant professional experience.
Experience in media, digital investment, analytics or ad operations.
A bachelor's or advanced degree in Statistics, Economics, Business, Mathematics, Computer Science or another scientific discipline.
Experience with advertising campaign and analytics platforms such as Google Ads, Google Analytics or Adobe Analytics.

Benefits

Competitive medical, vision and dental insurance.
Group retirement plans.
Significant paid time off.
Preferential partner discounts.
Employee mental health awareness days.
Employee resource groups and in-office events.
Access to the global WPP Media and WPP networks and learning opportunities.

Before you apply

Only candidates living in Mexico or Colombia who are legally authorized to work there may apply.
Remote work from outside Mexico or Colombia, including relocation abroad, is not permitted.

About the company

WPP Media is WPP's AI-driven media operating unit, bringing together media, data and partnerships. It is an equal opportunity employer.