BI Analyst

Job Description

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 requisitionid:42313 Show more Show less