Job Description

DescriptionPosition at MindshareOverview of jobGroupM 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.3 best things about this job:

• Exposure to media and marketing analytics working on a global account
• Develop and deliver end to end business intelligence and data analytics workflows (data collection, data cleaning, analysis and validation), while contributing to innovative data science projects to value-add media performance projects
• Hands on exposure to enterprise analytics and data science tools e.g. SQL, Python, Azure, BigQuery etc.

Key responsibilities:

• 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.

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)

About Mindshare:GroupM is responsible for more than $60 billion in annual media investment, as measured by the independent research bureau COMvergence. Through its global agencies Mindshare, Wavemaker, EssenceMediacom, and mSix&Partners, and cross-channel performance (GroupM Nexus), data (Choreograph), entertainment (GroupM Motion Entertainment) and investment solutions, GroupM leverages a unique combination of global scale, expertise, and innovation to generate sustained value for clients wherever they do business.Discover more about GroupM at
Follow @GroupMAPAC on Twitter
Follow GroupM on LinkedIn -About GroupM Singapore:GroupM Singapore operates in one of the most dynamic and exciting environments in the world. Although it is a small domestic market, there is a vibrant media industry which is undergoing rapid evolution as digital technology reshapes the way marketing supports advertisers\' needs. Being at the crossroads of Asia means, that aside from the local clients and media owners, we also have a high proportion of multi-national clients, renowned brands and media owners. Making GroupM Singapore the Number One organisation to join and develop your career in media investment.GroupM is an equal opportunity employer. We view everyone as an individual and we understand that inclusion is more than just diversity - it\'s about belonging. We celebrate the fact that everyone is unique and that\'s what makes us so good at what we do. We pride ourselves on being a company that embraces difference and truly represents the global clients we work with.

Mindshare