Mindshare | Data Analytics Intern

at  Mindshare

OVERVIEW OF JOB

GroupM is the world’s largest media investment company and are a part of WPP. In fact, we are responsible for one in every three ads you see globally.
We will be offering media internship in the various media aspect covering search, social, out-of- home, offline, programmatic working with the industry leading clients under Mindshare, EssenceMediacom, Wavemaker, Xaxis and mPlatform.
In which students onboard this internship experience with us would be expose to leading media innovation, learning from established media professional and working with the best available tools in each different area of media. At GroupM APAC, our people are our strength, which is why fostering a culture of diversity and inclusion is important to us.

REQUIRED SKILLS & TRAITS:

• Bachelor’s degree in a related quantitative field or currently studying (e.g. Statistics, Business Analytics, Economics, Computer Science, etc.)
• Strong analytical & coding skills (SQL & Python is a must)
• A strong understanding of data visualization tools and ability to work with large data set’s.
• Familiarity with Adverity, Azure DB, and Power BI would be a plus (but not mandatory)

• Be accountable for the development and delivery of Media Reporting
• Use API tools such as Adverity to establish and configure data ingestion pipelines
• Integrate other data from publisher platforms such as TikTok
• Develop and configure RPA scripts, and optimise RPA processes
• Prepare SQL scripts using Power Query to ETL reporting databases
• Create SQL scripts to harmonise media publisher platform data
• Explore and validate data from third party data sources, such as AdClarity
• Test and validating the data in reporting databases, ready with visualisation
• Develop and configure visualizations in tools such as PowerBI, Datorama and Looker
• Liaise with clients to gather, understand and scope requirements
• Support ad-hoc development work for clients, as requested.