Financial Analyst (Reporting)

Responsibilities: Financial consultant to assure Sales and Operating Income Percentage Targets are achieved
1. Lead financial budget for the Company
2. Oversee Budget and forecast: One and/or Five Year Forecasts
a. Sales forecast
b. Gross Profit
c. Operating expenses
d. Capital expenditures
e. Headcount

Detail Responsibilities
1. Partner and provide support to internal client-facing Finance Analysts to effectively manage the business and maximize profitability.
2. Download large data and through Excel pivot table, v/x-lookup and power query functions, compile, and create reports for financial analysis
3. Partner with Shared Services Center in Malaysia to assure accuracy of data
4. Partner with Center of Excellence throughout the world to analyze data
5. Communicate with HQ reporting regarding deadlines and requirements for budget, trimester reporting and year-end review
6. Communicate/update applicable regulatory and Amway financial policies on Intranet

Required Knowledge, Skills and Abilities:
Analysis
1. Interpret Data: Read, interpret, and draw accurate conclusions from financial data
2. Communicate Financial Information: Effectively communicate and present complex financial data (both verbally and written) to influence all levels and global audiences; helps others understand financial data and translate it into actionable business insights.
3. Report creation (data preparation & digesting to synthesize it to action points and recommendations, design for adequate presentation to executives)
a. Excel: ability to create pivot table, use x/v-lookup, power query/pivot and intermediate macro (preferred), if and else formula, create graphs/charts/waterfall
b. Database programming (TM1, EBS, Hyperion)
c. PowerPoint presentation
4. Retail Sales experience: Understanding of retail/wholesale industry with 500+SKUs
5. Financial Knowledge: Understanding of general financial principles, accounting and working knowledge of GAAP, and how to apply these principles.

Reporting:
1. Manage the preparation of the monthly, quarterly and yearly reporting that includes financial executive deck working with the finance partners, Excess & Obsolete report, capital expenditures, sales forecast, COGS and distributor bonus
2. Lead the preparation of the Annual Budget, and related monthly and trimester forecasts for Japan Exec team and HQ management
3. Maintain the financial risks and opportunities and reconcile to the Budget vs Forecast

Innovation:
1. Identify, develop, and facilitate financial processes and improvements in a growing international matrix environment.
2. Identify internal and external trends and developments which add value to improve Amway’s profitability, including evaluation of KPIs and management dashboards

Accounting:
1. Manage all processes of ABOs and vendors’ payment record and my number
2. Ensure adherence of President Seal
3. Coordination with Japanese banks
4. Support Government survey
5. Administrative work ie. manage letters received and distribute to respective parties
6. Maintain Finance document lists
7. Manage tax treaty application

Soft skills:
1. Team player: Ability to develop and maintain effective and productive relationships, including ability to influence, negotiate and manage conflicts across an international matrix organization
2. Strategic Thinking: Ability to think strategically and understand the broader view. Demonstrates an understanding of the long-term, "big picture" and Materiality
3. Critical Thinking: Ability to formulate conclusions and recommendations using Limited facts and data
4. Prioritization: Understand what would impact the business and prioritize workload accordingly
5. Managing Multiple Priorities: Ability to manage multiple objectives and work under pressure within deadline
6. Project Management skills: Strong planning, organizational and leadership skills
7. Communication: Written and Verbal communication and interpersonal skills in a fast-paced international matrix environment
8. Effective presentation skills: Creating and presenting concise messages to business partners and company employees
9. Language: Business level in both English