The SAPAC CMI team belongs to the Digital and Ecommerce department, and reports to the VP of the department. The SAPAC CMI Executive will be in Singapore, and is expected to report to the SAPAC CMI Manager, who is reporting to the SAPAC CMI Director.
Key Responsibilities
Overall, the role is expected to be a connecting role that partners with the regional brand teams, regional digital and e-commerce team as well as the local teams. At the same time, the role is expected to connect and manage key business partners. Key responsibilities will delivery of specific projects within the insights work plans for all categories and all brands within SAPAC.
Specifically, the deliverables and scope of work encompasses the following key areas:
ASSISTING ON REGIONAL DATA MANAGEMENT
- DASHBOARD BUILDING AND MANAGEMENT
- Responsible for leading management of tool and partnership with partner agency for the dashboard --- includes cleaning data, checking on output in dashboard, managing access and delivery of data from Shiseido to agency
- Collect and cleanse raw data from various reports/ data portals and from regional digital team, local brand teams, and local/ regional finance teams insights such as Share of voice vs. competitors.
- Ensure that additions to the dashboard are implemented given that the dashboard is an evolving tool and is expected to continuously develop.
- Coordination with partner agency/tool developer on day-to-day tasks
- Reporting and analysis with business relevant recommendations:
- Analyzing data sets, identifying user needs, and performing data interpretation and visualization
- Writing and delivering reports, tracking and reporting key performance indicators (KPIs), and updating dashboards
- Collecting data, defining data collected in transactional systems, and designing methods for data collection
- Database maintenance: Maintaining databases
- Data quality: Investigating data discrepancies and working to improve the quality, accessibility, and value of data
- Quarterly reporting: performance of brands on market KPIs and e-commerce reporting
- Assist SAPAC CMI Director in the quarterly reporting of company performance using data and information from retail and panel data.
- Assist in putting together the data and information for key quarterly reports. Produce key reports such as quarterly EC reporting and analysis on market movements covering market share by channel, product vs. competitors, media.
- Will also expected to produce the analysis, supporting the SAPAC CMI Manager
- On ad-hoc requests
- Responsible for sourcing data from all CMI tools and information and putting together analysis.
- Regular scanning of market, consumer and competitive activities which will act as inputs to our key reports or internal communications.
- Conduct desk research on key consumer insights trends, perform competitors benchmarking on key commercial activities and consolidate it into a monthly internal newsletter or for quarterly EC reporting.
- Assist to draft/review questionnaire, programming and testing of the survey links as well as data cleaning, analysis and reporting for ad-hoc requests.
LEAD DATA MANAGEMENT AND ANALYTICS: FUTURE-FIT FACING EXPANDED SCOPE
Support data-related projects by collecting/organizing data, perform data analysis & interpretation and visualization of all relevant data from CMI (i.e. performance KPIs from Beaute Research, Nielsen and other similar data), and from CRM, E-Commerce and Digital Media data. Report insights and help users to make decisions and find improvement opportunities.
Scope will include the following key responsibilities to support/assist CMI Director in this key role:
- Engaging cross-functional stakeholders (regional and country) to understand user requirements (voice of customer) and ensure data accuracy and availability.
- Extract data from data platforms (i.e. CMI Dashboard, Social Listening, other database in CRM, Digital Media), track, analyse and report Key Performance index (KPIs)
- Perform data cleaning and data analysis and analytics modelling.
- Contribute to the formulation of modelling solutions across key functions of Digital Media, CRM and E-commerce data
- Integration of diverse big data sources --- i.e. Beaute Research, Nielsen, Kantar, Euromonitor, Mintel, Statista
- Researching new modeling techniques as appropriate for a specific solution relevant to the business issue and the vision of automation and digitization
- Support implementation of dashboard through data automation and analysis solutions.
- Liaise with external suppliers or vendors to resolve issue when needed.
- ASSISTING SAPAC CMI MANAGER IN DEVELOPMENT AND IMPLEMENTATION OF OTHER AD-HOC KEY PROJECTS (I.E. CX PROGRAM FOR THE REGION)
Specifically- Assist in the day-to-day coordination with partner agency on key projects
- Assist in the development and implementation of the CX program (to include set-up and the planning of analysis and cascade)
- Assist in Setting-up and coordination of necessary training programs like Research 101
- Assist in building with external vendor, and internally establishing AI driven Newsletter
- LEAD IN MANAGEMENT OF SOCIAL LISTENING FOR THE REGION
- Will manage the day-to-day coordination with key partner Meltwater. Is also expected to support in the set-up and trainings with the countries.
- To be able to produce ad-hoc analysis when required, specifically for key regional request (i.e. crisis monitoring) as well as responsible in flagging key issues that may be gaining traction in digital space conversation
- COUNTRY SUPPORT DELIVERABLES
- Support studies/ad-hoc requests/initiatives from countries in APAC: will include coordination with agencies and all related project task.
SCOPE AND KEY INTERFACES (Environment) and TEAMWORK
The position is required to business partner with regional and local brand teams, and digital and e-commerce teams. This calls for high level of integration with the team as mentioned below.
Key Interfaces
- Regional Brand Directors
- Regional Brand Managers
- CMI and CMI practitioners in countries
- Market Research Agencies
- Innovation Center
- Corporate Strategy team
- Digital and Ecommerce team
Requirements
- At least 1-2 years of experience in market research: working in insights role in a company or in research agency
- Working knowledge of key measurement tools: retail data, household panel data
- Strong numerical and analytics skills with the ability to slice and dice data in different dimensions and connect the dots between data points/sets
- Experience with social listening tools for research a plus
- Self-starter with good communication skills (verbal and written)
- Can work and manage researches independently
- A strong plus will be familiar or working knowledge on Google Analytics, R Language, Python, SPSS and Tableau/Power BI
- Proficient level with Microsoft Office (Microsoft Excel, Microsoft Word, Microsoft PowerPoint).
