Business Intelligence Specialist (Power BI & Data Automation)
Core
Building BI solutions to help agency teams utilize data, automate reporting, and make better decisions.
Role type
Business Intelligence Specialist (Power BI & Data Automation)
Builds
Reports, dashboards, and data automation pipelines for internal WPP Media teams.
Domain
Media & Marketing / Data Engineering
Deliverable
dashboards & analysis
Required skills
Power BI (modeling, DAX, Power Query, Service, optimization), SQL, BigQuery, Adverity, data validation, business requirement translation
Preferred skills
Marketing data knowledge, ad platform metrics (CPM, CPC, CTR, CPA, ROAS)
Technologies
Power BI, Adverity, BigQuery, SQL
Responsibilities
Create and develop Power BI reports and dashboards; Prepare, join, and analyze data from various sources using SQL and BigQuery; Learn and support Adverity for data extraction automation; Verify data accuracy, identify errors, and find solutions; Collaborate with internal agency teams to understand reporting needs; Support development and maintenance of existing BI solutions and propose improvements.