Financial Planning Analyst

TITLE: Financial Planning Analyst

REPORTS TO: FP& A Manager

GENERAL ROLE

The Financial Planning Analyst is responsible for supporting the FP& A Manager in the annual budgeting and re-forecasting processes. He/she ensures all guidelines are respected as well as keeping the good quality of data that translates the local strategic plan through budget years. He/she is also responsible for monitoring the overall financial performance with meaningful analysis to ensure financial goals and company's objectives are met. He/she is also an active contributor to the reporting process for each closing phase.

MAJOR RESPONSIBILITIES

1. Budget construction

• Proactively support the FP& A manager during the Budgeting and re-estimate construction
• Create and simulate inventory equations, margins, and depreciation by products in different scenarios
• Update and maintain various budget templates with data submitted from departments
• Prepare and report budget P& L and ensure accuracy and completeness of data through the budget periods
• Report monthly sales re-estimation into the system
• Report budget cashflow in local and original currencies
• Calculate and allocate each department's annual budget
• Perform ad-hoc analysis requested from management

2. Financial reporting

• Work closely with the accounting team to ensure accuracy of closing data
• Report the closing data for each reporting phase with analysis into the system
• Review the monthly inventory depreciation computation and analyze aging inventory trends to manage financial risks and opportunities related to the inventory
• Proactively track and assess all overhead expenses. Perform detailed variance analysis of actuals vs. budget, reforecast, and identify any risks and opportunities

3. Others

• Work closely with Merchandising and provide financial information in buying process
• Enhance and maintain reporting tools and templates
• Manage, update, and create expense users in expense system

REQUIREMENTS & CAPABILITIES

• Bachelor's degree in accounting, Finance, or related field
• 4 to 6 years of experience in FP& A
• Strong analysis skills with accuracy in details
• Excellent communication and interpersonal skills
• Proficient in MS office applications, especially in Excel
• Knowledge of Cognos, SAP, Magnitude and TM1 system is a plus
• Fluent in English