Description

Overview of job
Improve the company’s capacity to provide high-quality advice to our clients, by automating key data analysis and report generation work, with a focus on visualization of key results.

Reporting of the role:
This role reports to the General Manager, Data Analytics & Services.

3 best things about the job:

1. Liberate your colleagues from the drudgery of cutting and pasting
2. Empower our managers to spend more time generating value for our clients by providing them with the answers to critical analysis questions on a periodic basis
3. Teach your colleagues how to communicate through simple visualizations of key business results

Measures of success –

In three months:

• Familiarized yourself with our key reporting templates
• Automated at least two client reporting functions
• Improved at least one KPI reporting visualization

In six months:

• Improved (or created) at least two more KPI visualization techniques
• Automated the customisation of at least two more standard reports
• Completed at least one more ad-hoc automation project

In 12 months:

• Completed the full suite of KPI reporting visualizations for all key search and display metrics
• Introduced new reporting visualizations to at least 3 new client pitches
• Completed at least 3 more ad-hoc automation projects

Responsibilities of the role:

All standard Reports generated at the group level have been customized according to our individual agency (and client) needs.  And, beyond standard reporting, campaign managers receive weekly updates on the health of their campaigns, based on tailor-made data mining operations. 

What you will need:

• A minimum of two years’ experience actively using SQL to extract / transform / load data
• A minimum of two years’ experience automating key Excel functions using VBA
• A passion for data visualization and communication
• A desire to expand your skill set beyond coding and develop your own communication skills
• A patient, methodical and detailed personality, with the ability to maintain your focus and see ideas through to results.

About Mindshare

Mindshare, the global media agency network, and part of WPP, the largest marketing communications network in the world, has more than 7,000 employees, in 116 offices across 86 countries. Mindshare APAC has won over 300 awards in 2014/2015 and was the most awarded agency at the 2015 Campaign Asia Awards Festival. Mindshare was also recognised as the SMARTIES™ APAC ‘Agency Network of the Year 2015’ for the third consecutive year. Mindshare is also home to The 2015 Festival of Media Asia Pacific Rising Star – Jason Maggs.

To learn more about Mindshare and our philosophy of Original Thinking, visit us at www.mindshareworld.com

About China

China is now the second largest media market, and the world’s most vibrant digital market, growing at double the rate of the US. In 2013, China surpassed the US in e-commerce, and China leads the world in mobile with over 600m smartphone connections. The pace of change and the scale of China’s emerging consumer market are unparalleled in any other market. Global CEOs are looking to China to drive growth, and brands are rushing to keep pace.

If you want a future in media and communications, there is clearly no place more vibrant, challenging and exciting than China, where opportunities for you to innovate and grow are unparalleled.

GroupM APAC is committed to fostering a culture of diversity and inclusion. Our people are our strength so we respect and nurture their individual talent and potential.