Business Process Optimizer （VBA reporting development）（Data & Analytical Services） – Mindshare, China

Overview of job
Utilize VBA to conduct the secondary script development on Office platform to realize data cleaning and data integration so as to reduce the costs media agency spends on data integration during business process optimization.

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

3 best things about the job:

• Develop VBA scripts to enhance the capability and efficiency of data reporting for business teams. Helps users solve the perplexities on periodically producing business reports.
• Develop data reporting to enable clients to better generate insights from advertising data and aid clients to adjust their strategies. Discover the beauty of data to better support business analytics.
• Guide users to comprehend the value of these tools and promote the generalized solutions. Cooperate closely with business teams in order to look for ways of analysing advertising data.

Measures of success –

In three months:

• Familiarize yourself with our existing reporting templates and understand how to compile concise and efficient VBA scripts.
• Realize partial auto reporting functions for at least 2 clients. Be familiar with the objective, structure, and framework of excel programming.
• Enhance the visualization and interactivity for clients’ KPI reporting.

In six months:

• Provide at least 2 optimization suggestions on current KPI reporting visualization techniques. Based on existing practices, evaluate whether there are any improvement or alternative plans for current business optimization process.
• Accomplish the revisions for the customizations of at least 2 standard data reporting automation. Build comprehensions on business analytic scenarios and conclusions for data reporting.
• Complete at least one ad hoc data reporting automation project requested by business teams and participate in the development of project documents.

In 12 months:

• Possess the full suite of capabilities to independently develop the visualization for KPI reporting including all key search and display metrics. Make yourself master of the key methods to use VBA script programming to produce reports.
• Introduce report visualization in at least 3 new client pitches and promote KPI reporting visualization process to other clients.
• Complete at least 3 ad hoc reporting 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. Through tailor-made data mining methods, expend the standard reporting to meet the needs on analysing the data for daily advertising campaigns for campaign managers. Leverage VBA scripts to help business teams develop the tools which can be used for data cleaning and report integration in the long term.

What you will need:

• A minimum of two years’ experiences actively using SQL to extract / transform / load data.
• A minimum of two years’ experience automating key Excel functions and objectives using VBA.
• A passion for data visualization, and quick learning ability to new knowledge.
• 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 in complex environments, great data sense, and business acumen.

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.