Decision Support Advisor

About the role

Acts as project leader and coordinator for the development of the financial plans / forecasts for a business group or customer account.

Develops timelines, plan guidance and plan assumptions.

Gathers and analyzes information on which to base plan assumptions.

Oversees the development and preparation of alternative plan models.

Prepares and presents summaries to management.

Prepares monthly financial reporting packages including forecasts, results and financial and operational metrics.

Completes special projects involving the analysis of financial information related to inventory, costs, headcount, profit maximization, expense targets both within finance or as member of a cross functional or customer team.

As required, plays a leadership role with junior members of the decision support team, coordinating and guiding activities, providing direction or leading group projects.

Responsibilities

• Acts as project leader for the development of financial plans for a business group or customer account.
• Develops timelines, plan guidance and plan assumptions.
• Gathers and analyzes information on which to base plan assumptions.
• Oversees the development and preparation of alternative plan models.
• Prepares and presents summaries to management.
• Prepares monthly financial reporting packages including forecasts, results and financial and operational metrics.
• Completes special projects involving the analysis of financial information related to inventory, costs, headcount, profit maximization, expense targets both within finance or as member of a cross functional or customer team.
• As required, plays a leadership role with junior members of the decision support team, coordinating and guiding activities, providing direction or leading group projects.

Requirements

Working knowledge of Celestica’s finance organization including strategic policies and objectives.

Strong knowledge of basic computer applications and the ability to learn and use multiple applications specific to this department including ERP and office systems.

Strong communication, negotiation and presentation skills.

Ability to evaluate, prioritize and problem solve a variety of tasks to ensure their timely and accurate completion.

Ability to recommend accounting process changes based on intimate knowledge of accounting processes, policies and procedures.

Ability to direct others on accounting practices.

Ability to recommend creative accounting solutions that is in accordance with U.S. GAAP or GAAP of the relevant country.

Ability to manage large-scale budgeting/forecasting process.

Ability to analyze and summarize key highlights and makes recommendations to management for plan/forecast savings.

Perform financial sensitivity analysis against all key factors (pricing, operating and costing) and provide management with recommendations/solutions.

Makes recommendations based on interpretation of results.

Understands MRP configurations/processes.

Creates basic spreadsheet macros.

Understands how to use the political structure in the organization and how to get things done using that structure.

Qualifications

• Bachelor’s degree in Finance, Accounting, Economics, or related field.

Skills

• Strong knowledge of basic computer applications and the ability to learn and use multiple applications specific to this department including ERP and office systems.
• Strong communication, negotiation and presentation skills.
• Ability to evaluate, prioritize and problem solve a variety of tasks to ensure their timely and accurate completion.
• Ability to recommend accounting process changes based on intimate knowledge of accounting processes, policies and procedures.
• Ability to direct others on accounting practices.
• Ability to recommend creative accounting solutions that is in accordance with U.S. GAAP or GAAP of the relevant country.
• Ability to manage large-scale budgeting/forecasting process.
• Ability to analyze and summarize key highlights and makes recommendations to management for plan/forecast savings.
• Perform financial sensitivity analysis against all key factors (pricing, operating and costing) and provide management with recommendations/solutions.
• Makes recommendations based on interpretation of results.
• Understands MRP configurations/processes.
• Creates basic spreadsheet macros.
• Understands how to use the political structure in the organization and how to get things done using that structure.