Senior Associate, Data Analytics & Business Intelligence (BI)

About the role

WPP Media is looking for a Senior Associate, Data Analytics & Business Intelligence (BI) to join its Global Operations Centre (GOC). You will work closely with teams across the United States, Europe and Asia in a collaborative, multicultural environment, designing and maintaining cloud-based data solutions that support business intelligence, media performance reporting and data quality compliance.

Key responsibilities

• Collaborate with data engineers, developers and UX designers to build data pipelines and workflows for client reporting projects.
• Partner with BI and Data Operations teams to define and document reporting and visualization requirements.
• Ensure data quality, support and maintain existing workspaces, and onboard new client teams to cloud data solutions.
• Define QA guidelines and automate quality assurance processes, and develop tools and best practices with the Associate Director's support.
• Act as a subject matter expert in data quality, BI tools and business rules, and coordinate status meetings and working sessions.
• Identify and resolve project roadblocks, report project status and risks to the US-based Associate Director, and communicate clearly with internal teams.

Required profile

• Preferred: 3-4 years of relevant experience, including 2-3 years in data governance, data warehousing, ETL and business intelligence.
• Experience with the full application or reporting solution lifecycle, from design through testing and deployment.
• Preferred: experience in media, digital investment, analytics or ad operations, and a degree in Statistics, Economics, Business, Mathematics, Computer Science or a related field.
• Strong attention to detail, excellent communication skills, and strong organization and prioritization skills.

Required skills

• Advanced SQL, relational databases and data warehouses (MySQL, PostgreSQL, Redshift or Snowflake).
• At least one programming language, such as Python.
• Cloud platforms (Microsoft Azure, Google Cloud Platform or AWS) and data engineering platforms such as Databricks.
• Familiarity with BI tools (Tableau or Power BI) and project management tools (Jira, Confluence, Smartsheet, Azure DevOps/VSTS).
• Preferred: advertising campaign management and measurement platforms (e.g. Google Analytics, Google Ads, DV360, Kenshoo, Adobe Analytics).

What we offer

• Hybrid work, with teams in the office around four days a week.
• Medical, group retirement, vision and dental insurance, significant paid time off, partner discounts and mental health awareness days.

The position is remote or hybrid and must be performed from Mexico or Colombia; only candidates legally authorized to work in one of those countries may apply.