Asia Pacific - Finance Analyst
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
Job Segment:
Financial Analyst, Financial, Finance