Decision Support Advisor Jobs (NOW HIRING)

Functional Area:  FIN - Finance
Career Stream:  DEC - Decision Support
Role:  Advisory
SAP Short Name:  ADV
Job Title:  Decision Support Advisor
Job Code:  ADV-FIN-DEC
Job Level:  Band 09
Direct/Indirect Indicator:  Indirect

Acts as project leader and coordinator for the development of the financial plans / forecasts for a business group or customer account. First full level of specialization; applies expertise in more than one area of specialization. Work is performed within established professional standards, established policy, and/or established objectives. Works on problems of diverse scope where analysis of data requires evaluation of identifiable factors. Incumbents are accountable for quality of work delivered by external suppliers as applicable. May influence others outside of team to ensure goals are met and resolves conflicts in an effective manner. Sound decisions are required to achieve the sites / major function's operations, schedules, and/or performance goals. Receives guidance primarily on unique, unusual, or controversial problems or questions. Will lead a work group or project team consisting of one or more support staff and/or tech/professional staff with some coaching from own supervisor, or will provide advice and guidance in area of specialty as required. Seeks out new avenues for building internal and external relationships as appropriate; maintains contacts with existing relationships. Implements process improvements. Can negotiate and persuade. Conducts negotiations and manages a desired outcome. Chairs meetings with adequate presentation material. Mentors, motivates and influences others to work toward and achieve team objectives. May be responsible for planning and prioritizing work for other people. Makes a decision based on analysis. Anticipates and initiates changes and make recommendations. Is Able to handle difficult situations in a tactful and diplomatic manner. Can effectively resolve conflict.

Performs tasks such as, but not limited to, the following:

• 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.

• 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.
• Ability to design custom queries in job-related software.
• Understanding of the relationships between the various tools.
• Understands how to use the political structure in the organization and how to get things done using that structure.

• Duties of this position are performed in a normal office environment
• Duties may require extended periods of sitting and sustained visual concentration on a computer monitor or on numbers and other detailed data
• Repetitive manual movements are frequently required (e.g. data entry, using a computer mouse, using a calculator, etc)

• Education: Bachelor's degree in Finance, Accounting, Economics, or related field.

This job description is not intended to be an exhaustive list of all duties and responsibilities of the position. Employees are held accountable for all duties of the job. Job duties and the % of time identified for any function are subject to change at any time.