This is a 1 year fixed-term contract with a 1 month completion bonus upon the end of the contract.
MAIN PURPOSE
The Finance Analyst will support and assist the FP&A team to build and improve reporting and data transformation tasks as part of the project to automate and build data readiness to support decisions, create analysis & insights. The analyst will also assist in data and business validation in the Brand Planning and Sales Automation project including roll-out to markets in the Region, acting as an ambassador to promote adoption and training/knowledge transfer to the markets.
KEY RESPONSIBILITIES
1. Data Transformation
- Support work on Sales data transformation, preparation and standardisation
- Setup Power Query to prepare monthly Data files in specific formats
- Support data testing and validate accuracy and completeness of data
- Study and reconcile data with markets in the region to ensure consistency of reporting parameter
- Assist to setup and integrate use of relevant data points to support business processes
2. Maintain and modify VBA codes and PowerBI Visualisation
- Maintain and modify VBA codes in Excel according to user requirements
- Modify and monitor data integrity of PowerBI reports & visualizations
- Create and build new visualization & storyboard using PowerBI to provide added insights
- Provide training and assistance to market users to promote adoption of PowerBi in the region
3. Brand Analysis & Reporting
- Build financial reports and templates using Analysis for Office to support deep dive analysis
- Work with markets to standardize masterdata to enable reporting and analysis on profitability by Channel, Customer and product margin.
- Assist to promote use of AFO for finance community in the region
- Participate in ad-hoc assignments and projects
REQUIREMENTS
- Bachelor’s Degree in Finance or Business with specialisation in Data Analytics
- Fresh graduates are welcomed to apply
- Hands-on experience working with large volume of data, including ETL is preferred
- Advance skills in Microsoft Excel and PowerBI is a must
- Possess knowledge of at least one programming language, e.g. Python, SQL or VBA for Excel
- Fast learner, proactive and resourceful individual
PLEASE NOTE
Interested applicants, please apply directly via Shiseido's career page using the link right below for faster processing of your application. Thank you.
URL: https://careers.shiseido.com/job/Singapore-Asia-Pacific-Finance-Analyst-01/1098846601/
