Overview of job
Manage media advertising metadata from different sources. Know how to organize it and build regular reports for client. Provide solution to client’s business according reliable data analysis. Help maintain data database, report tools and ETL workflows. Provide innovate ways to improve the regular report building process and data quality. With the effective methodology to guarantee planners and clients receive high quality data analysis results.

3 best things about the job:

• Maintain and improve Automatic regular report workflow. Provide regular reports covers client’s APAC business.
• Optimise analysis model in report through data analysis, make the user acquire valuable information easier. Based on understanding of client’s Luxury market and looking for better insights from data analysis to share.
• Participate in data driven analysis methodology establish process, familiar with the data analysis tools and knowledges. Play as the role who driven business through data analysis story.

Measures of success –

In three months:

• Familiar with client’s requirements about the regular reports. Familiar with the principle and background of report tools. Skilled with data clean processes.
• Understand the details of client’s requirements in reports, know how to adjust the parameters in tools to build reports for different roles within business.
• Communicate with strategy planning team and collect their needs in data analysis. Upgrade report dimensions’ details.

In six months:

• Running regular report workflow independent, includes daily communication with clients. Provide suggestion to optimise the report workflow.
• Lead associates help client work out data analysis solution and handle reports in time.
• Summarize the detail mind maps of client’s report, and sort out the documents for archive

In 12 months:

• Know how to build the data analysis database and platform, drive more new report automation project connect into data platform. Know how to build ETL tools for data cleaning.
• Lead data mining project based on data platform, client’s data, Media data to find out valuable information. Support Advertising strategy making.
• Cooperate with teammates in Data Advisory team, fulfil client’s data analysis needs.

Responsibilities of the role:

Provide newest advertising data to clients and strategy planning team regularly. Data advisory supervisor must lead associate to understand client’s report needs and arrange the details in building the reports in every steps. He/ She Must ensure the reports being delivered to client in time with high quality.

What you will need:

• Familiar with SQL query with manipulate SQL SERVER database, at least 1-2 years’ experience.
• Excellent in Excel and PPT skills, know some VBA script programming knowledge is a plus.
• Interested in data analysis, got fast learning ability with new knowledge. Have strong sensitive with data and good logic in data. Have clear thoughts and solutions when facing problems.
• Got media agency data analysis working experience, know how to solve the data analysis problems independent.
• Be patient with work, know how to arrange things in detail. Stay focus in complex environment.

上班地址：恒丰路399号达邦协作广场