Digital Media Analytics & BI Analyst — Remote

WPP; Perímetro Urbano Medellín; Hybrid; COP 25,000,000 - 42,000,000; Full time

Benefits offered by this job

Hybrid work model

Medical, dental and vision insurance

Retirement plans

Paid time off

Partner discounts

Mental health days

Job summary

WPP Media is seeking an Analyst, Digital Media Analytics to support measurement and reporting of B2B advertising campaigns for a global professional services client. You will use T-SQL, Power BI, and Excel to extract, organize, analyze, and visualize campaign data.

You will collaborate with Investment, Planning, and Analytics teams to ensure accurate reporting, monitor campaign performance and spend pacing, and identify data gaps.

Qualifications

• 1–2 years of relevant professional experience in data analytics.
• Hands-on experience with data extraction, organization, and analysis.
• Practical experience using T-SQL to retrieve and analyze data.
• Experience using Power BI to maintain dashboards, visualize information, and support reporting.
• Proficiency in Excel for preparing, organizing, and analyzing datasets.
• Strong attention to detail and the ability to validate data and maintain reporting accuracy.
• Good communication skills to explain findings and coordinate with stakeholders.
• Collaborative approach with Investment, Planning, and Analytics teams.
• Organizational skills to support multiple campaigns and deadlines.
• Experience with Databricks is a plus.

Responsibilities

• Extract, organize, and format campaign data from advertising platforms to support analysis and reporting.
• Use T-SQL and Excel to retrieve, prepare, and analyze data for accurate campaign reporting.
• Maintain, update, and perform quality assurance checks on dashboards and recurring reports in Power BI and Tableau.
• Produce campaign performance and spend pacing reports across multiple campaigns and client service lines.
• Perform recurring tracking tag QA checks to verify data flows.
• Translate media metrics into clear visualizations and presentations for decision‑making.
• Review campaign objectives and performance data to identify optimization opportunities and measurement solutions.
• Collaborate with Investment and Planning teams to gather campaign information and ensure reporting coverage.
• Identify and help resolve data gaps and discrepancies to improve information quality.

Skills

T-SQL

Power BI

Excel

Data visualization

Tableau

Tools

Databricks

Job description

WPP Media is seeking an Analyst, Digital Media Analytics to support measurement and reporting of B2B advertising campaigns for a global professional services client. You will use T-SQL, Power BI, and Excel to extract, organize, analyze, and visualize campaign data.

You will collaborate with Investment, Planning, and Analytics teams to ensure accurate reporting, monitor campaign performance and spend pacing, and identify data gaps.