Associate, Data Analytics & BI, GOC
Core
Analyst supporting measurement and reporting of B2B advertising campaigns for a global professional services client.
Role type
Associate, Data Analytics & BI
Builds
Campaign performance and spend pacing reports, dashboards, and recurring reports.
Domain
Digital Media Analytics / Advertising
Deliverable
dashboards & analysis
Required skills
T-SQL, Power BI, Excel, data extraction, data organization, data analysis, data validation, QA checks
Preferred skills
Databricks
Responsibilities
Extract, organize, and format campaign data from advertising management platforms; Use T-SQL and Excel to retrieve, prepare, and analyze data; Maintain, update, and perform quality assurance checks on dashboards and recurring reports in Power BI and Tableau; Produce campaign performance and spend pacing reports; Perform recurring tracking tag QA checks; Help translate media metrics into clear visualizations and presentations; Review campaign objectives and performance data to identify optimization opportunities; Collaborate with Investment and Planning teams to gather campaign information; Identify and help resolve data gaps, discrepancies, and reporting issues.
Seniority
Associate (1–2 years experience)
