Job Description

Description
Position at GroupM Nexus
BI Analyst GroupM India Offshoring Team, India
Role: Data Analytics & Reporting Specialist Location: India
Team: Dell EMEA
List of tasks:
- MMM data aggregation & set up
- Basic ad hoc reporting

• Gather data from various media platforms, including ad servers, social media

analytics tools, and third-party measurement providers into a consistent reporting environment

• Analyze data to identify trends across different KPIs, and key performance metrics.

- Weekly Media Dashboard Data Update

• Aggregation of plans with changes (updated Package IDs, Unit Costs etc.)
• Reformatting and compiling reports from different data sources (reformatting to a standard template, checking and fixing date issues etc.)

- Modelling Partner - Media Planning & Optimiser Tool (MPO)

• Input quarterly budget into the MPO tool (data provided by planning teams) with a split by vehicle, to estimate ROAS and incremental volume driven by tool optimised channel mix

- Quarterly Valuator management - collate spend data by country and format/clean before sending to the US global clients
- Requesting and collating all PCA reports at the end of the quarter to ensure all data is available for subsequent QBR/HBRs
Key Skillsets:
- 1-3 years in a reporting or dashboard building role.
- Media experience is must
- Power BI, Advanced Excel user and/or experience building with a web-based dashboard platform.
- Logical, problem-solving mindset.
- An advantage, but not essential: Tableau experience
- Google Data Studio experience
- Experience with SQL
- Building data processing scripts in R or Python