BI Analyst

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