Asia Pacific

**Asia Pacific - Regional Consumer & Market Intelligence Executive**:

- Date: 21 Nov 2024- Location: Singapore- Company: Shiseido

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.

a. **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
-