Summary:

Celestica is in search of a Decision Support Advisor (FP&A Manager) with a strong cost accounting background with the desire to learn Financial Planning & Analysis

Detailed Description:

Works on problems of diverse scope where analysis of data requires evaluation of identifiable factors. 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 site’s / major function's operations, schedules, and/or performance goals. Receives guidance primarily on unique, unusual, or controversial problems or questions. Seeks out new avenues for building internal and external relationships as appropriate; maintains contacts with existing relationships. Implements process improvements. Can negotiate and persuade. Makes decisions based on analysis. Anticipates and initiates changes and make recommendations. Is Able to handle difficult situations in a tactful and diplomatic manner.

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

• 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 and labor costs, profit maximization, expense targets both within finance or as member of a cross functional or customer team.
• Provides product cost analysis and pricing support for all products in production for the site – including material standard cost analysis and updates to the Material Master in SAP.
• Creates and posts journal entries to close the books
• Completes balance sheet account reconciliations with variance explanations that highlight the purpose of the balance and key drivers of change.

Knowledge/Skills/Competencies:

• Previous experience in a manufacturing environment would be an asset.
• Strong knowledge of basic computer applications and the ability to learn and use multiple applications specific to this department including SAP 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 manage the 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.
• Ability to consolidate, manipulate and analyze large quantities of data.
• Advanced Excel user (LOOKUPS, SUMIFS, Power BI tools). Knowledge of Blackline and Longview systems.
• 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.

Physical Demands:

• 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.)
• Occasional overnight travel may be required

Experience:

• Six to eight years of relevant experience

Education:

• Bachelor’s degree, or consideration of an equivalent combination of education and experience. Education experience may vary by geography.

Job Type: Full-time

Pay: $90,000.00 - $115,000.00 per year

Benefits:

• 401(k)
• Dental insurance
• Health insurance
• Paid time off
• Tuition reimbursement
• Vision insurance

Physical setting:

• Office

Schedule:

• Monday to Friday

Supplemental pay types:

• Bonus pay

Ability to commute/relocate:

• Tucson, AZ 85737: Reliably commute or planning to relocate before starting work (Required)

Work Location: One location