Ensure accuracy and alignment of data across UI and API sources, identify and resolve data issues, and maintain reports and dashboards for business strategy and investment teams.
Requirements
- Intermediate SQL skills (ability to query, validate, and troubleshoot data sets).
- Familiarity with BI tools (Tableau, Power BI, Looker, etc.) for dashboard updates.
Responsibilities
- Compare data across UI and API sources to ensure accuracy and alignment.
- Perform first-pass investigation of data issues raised by Business Strategy (BST) and Investment teams.
- Evaluate KPI and delivery trends to identify anomalies and drop-offs.
- Flag mismatches in taxonomies or naming formats.
- Track and manage outstanding taxonomy issues to ensure timely resolution by BST and Investment teams.
- Compile and distribute data for non-automated reports.
- Update and maintain existing dashboards (Tableau/Power BI or similar).
Other
- Exp: 5 year
- Media/advertising industry experience strongly preferred (should understand concepts like impressions, reach, delivery, KPIs).
- Strong attention to detail and problem-solving mindset.
- Ability to work closely with BST, Investment, and Analytics teams to resolve issues quickly.
- Clear communication skills to flag and track issues effectively.
