Senior Financial Analyst (Planning & Analysis) - Tableau And Power Bi

MAJOR DUTIES:
This is business partner position supporting the Director Finance, General Manager & VP Finance. The position is primarily responsible for the financial planning and analytic support to the Manager Planning & Analysis, measuring and controlling, budgeting, forecasting, developing key metrics & reporting tools, asset management and cash management. The position also provides subject matter expertise relating to the integration of various systems and is responsible for the administration and continuous improvement of the system.
Specific Responsibilities
OPERATIONAL SUPPORT

• Preparation of monthly consolidated forecasts (B/R/E/C/WC) for the assigned business units within the division & analysis of variances between Actual, forecasted and Plan results.
• Completion of various benchmarking analysis exercises using both internal and external sources
• Leading with the preparation & analysis of the weekly Quarterly Outlook/ Ops report & MBR
• Development of annual labor rates and identification of key reduction opportunities
• Analysis of various profit streams and identification of key opportunities
• Supporting the annual planning process at the divisional level
• Development and implementation of continuous improvement initiatives with respect to the Finance Processes with the ATS Code of Business Conduct.

FINANCIAL REPORTING AND ACCOUNTING

• Assist in the month end, quarter end, and year end reporting requirements, including preparation of required working papers
• Assist in the preparation of year-end audit files.
• Assist in the preparation of the monthly SFR according to established deadlines.
• Completion of monthly, quarterly and year-end accounting duties as assigned, which may include some or all of the following activities:
• Assistance in special projects, financial systems integration, internal audits, treasury, etc., etc., as required & working with the other members of the Finance team on special projects.

INTERNAL CONTROL, POLICIES AND PROCEDURES

• Ensure the safeguarding of company assets.
• Assist the Director of Finance in ensuring that ATS Financial Policies and Procedures are being adhered to and maintaining the internal controls documentation.
• Adhere to customer, corporate, divisional governance requirements and associated quality procedures and policies.
• Maintenance of the accounting records in a timely, accurate and complete manner.
• Adhere to all health and safety rules and procedures.

Qualifications
Additional Information
Education

• A university degree or college diploma in business and/or accounting or equivalent business experience is required.
• Completion of a professional accounting designation (CPA) is also required.

Experience

• Individual must have the ability to communicate efficiently and effectively with people at all levels of the organization both verbally and in written form.
• Ability to work with minimal supervision and guidance in a team-oriented work environment is mandatory.
• Hands-on, detail oriented and able to consistently meet deadlines.
• Advanced knowledge of an ERP system (preferably JD Edwards)
• Experience with Excel/Macros/VBA are required.
• A minimum of five years of financial planning & analysis or cost accounting experience is required; preferably in a job shop manufacturing or construction environment using the percentage of completion method of accounting.
• Strong analytical, financial reporting and accounting skills as well a continuous improvement orientation are keys.