Financial Analyst (Reporting)

Amway; Michigan; On-site; USD 75,000 - 100,000; Full time

Job summary

A leading company in the financial sector is seeking a Financial Consultant to oversee budget management and financial reporting. The successful candidate will work closely with internal analysts and maintain financial accuracy while providing actionable insights to senior management. This role requires strong analytical abilities and proficiency in Excel, alongside excellent communication skills. Located in Ada, Michigan, the company is committed to its longstanding values and the potential of its employees.

Qualifications

• Must be proficient in Excel, including pivot tables and macros.
• Understanding of GAAP and financial principles is required.
• Experience in retail sales with 500+ SKUs preferred.

Responsibilities

• Oversee budget management and ensure accuracy in forecasts.
• Partner with finance analysts for business profitability.
• Prepare monthly, quarterly, and yearly reports.

Skills

Data Interpretation

Financial Communication

Report Creation

Strategic Thinking

Project Management

Critical Thinking

Team Collaboration

Effective Presentation

Retail Sales Understanding

Education

Degree in Finance or Accounting

Tools

Excel

PowerPoint

Database Programming (TM1, EBS, Hyperion)

Job description

Posting Start Date: 11/7/24

Requisition ID: 40692

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

Based in Ada, Michigan, U.S.A. Headquartered on the same property where it was founded. Family owned. Guided by six original values and shaped to this day by our Founders Fundamentals. The heart of Amway hasn’t changed in its six decades. We exist to help people realize their potential, even as we’ve grown to span six continents with a presence in 100+ countries and territories.

Amway complies with the General Data Protection Regulation (GDPR) – the protection of personal data and digital privacy. Each of our affiliate locations have their own visa work permit and hiring and immigration policies, which may impact the ability to consider applicants who need authorization to work in a particular country.