Sql analyst Jobs in Cambridge, ON

Job Description

MAJOR DUTIES:

The Senior Financial Analyst will be a key contributor to the Reporting and Compliance team within Cambridge life sciences systems business (>$500 Mn in Revenue). This role combines strong technical expertise with business acumen, focusing on financial reporting, planning, forecasting, and business partnering. The SFA will play a key role in month end close/reporting, reconciliations, cash forecasting, foreign exchange analysis, audits, and preparation of accurate and timely financial reports. The role will report to the Finance Manager (Reporting and compliance).

SPECIFIC RESPONSIBILITIES:

FINANCIAL REPORTING AND ACCOUNTING

• Supporting the Monthly reconciliation of any B/S accounts associated with the business unit.
• Developing and implementing continuous improvement initiatives with respect to the finance processes within the ATS Code of Business Conduct.
• Responsible for ensuring that the Cambridge Systems Division financial reporting is in accordance with IFRS.
• Responsible for preparing audit working papers on a quarterly basis, ensuring that all accounts are reconciled.
• Intercompany reconciliations and reporting & assisting with other monthly corporate reporting
• Assisting with cash forecasting & Forecast foreign cash flows for determination of hedge settlement

INTERNAL CONTROL, POLICIES AND PROCEDURES

• Ensure adherence to IFRS and SOX
• Working with internal and external teams to put in place strong financial controls and processes.
• Providing early warning of business and financial risks along with opportunities to allow accurate, timely information for business decisions.
• Reviewing and assessing areas of business risk within the division, and, working with the Manager Financial Reporting & Compliance to develop policies to minimize or eliminate that risk where possible

Operational SUPPORT

• Supporting the bid approval process, working closely with account managers & the Director, Applications
• Ensuring any financial risks are mitigated (credit/FX/transfer pricing/taxes) & building in cost of financing & EDC costs to any bids
• Supporting Financial planning and budgeting processes

Qualifications

Education:

• Degree in Finance or Accounting. Ideally have CPA designation or enrolled in CPA program.

Experience & Requirements:

• Ability to communicate effectively with people at all levels of the organization, both verbally and in writing.
• A minimum of 5+ years of accounting experience is preferred
• Advanced knowledge of ERP systems (JD Edwards preferred) and Microsoft Outlook
• Superior Excel skills: Pivot tables, lookups, complex formulas, modelling, etc.
• Ability to determine relevant information for the target audience to provide informational requirements in a meaningful manner.
• Must be hands-on, detail-oriented, able to consistently meet deadlines, and can conduct in-depth financial analysis and present it in a clear and concise manner
• Strong organizational, planning, time management and problem-solving skills. Critical thinker.
• Highly motivated, dependable, and customer-focused team player
• Enjoys working in an exciting, fast-paced, results-driven environment with a big focus on streamlining
• Must have a willingness to get their hands dirty and to resolve complex issues.
• Has a flair for identifying and resolving issues promptly.
• Can work quickly and accurately.
• Independent and able to work with minimal supervision and guidance in a team-oriented work environment

Additional Experience:

• 4 - 7 years experience
• Has CPA designation or close to completion
• Strong in Excel
• Manufacturing Experience
• Standard Costing Exposure
• POC (percentage of completion) accounting experience
• Intercompany reconciliations experience
• Some complex accounting experience
• Some copmlex reconciliation experience
• Experience with ERP systems (Ideal)
• Continuous improvement mindset
• Has implemented or followed internal controls
• Can explain the business reason for variances
• Can get to the root cause of an issue, and remove the problem
• General accounting, financial reporting experience
• Managerial/Cost Accounting experience

Traits:

• Very organized
• Attention to detail/analytical
• Curious mind
• Ability to troubleshoot, even when experience is lacking (ability to figure things out, supplemented by asking questions of team members)

Health, Safety & Environmental

All employees have the responsibility to work in a safe manner and report any health, safety or environmental concern to their manager or supervisor in a timely manner.

Health, Safety and Environment include:

• Work in compliance with divisional health, safety and environmental procedures
• Refrain from removing or altering safety devices or guarding unless hazardous energies are controlled through lockout-tagout methods
• Report any unsafe conditions or unsafe acts
• Report defect in any equipment or protective device
• Ensure that the required protective equipment is used for the assigned tasks
• Attend all required health, safety and environmental training
• Report any accidents/incidents to supervisor
• Assist in investigating accidents/incidents
• Refrain from engaging in any prank, contest, feat of strength, unnecessary running or rough and boisterous conduct

If you're excited about this role, but do not meet all the qualifications listed above, you are still encouraged to apply Why YOU should join our ATS Life Sciences Systems team:

We value our PEOPLE - The foundation of a great company is having the best team which is why we continuously work to develop, engage, empower and energize our people. The best people want to work with the best team - the best teams are diverse and inclusive teams. What we do MATTERS - our Life Sciences projects contribute to improving the lives of people around the world! ATS has made a commitment to be carbon neutral by 2030!

INNOVATION and PROBLEM SOLVING is at our core - Our pursuit of continuous improvement in everything we do. Our focus is on building diverse teams, stimulating innovation by challenging conventional thinking, encouraging fresh ideas and promoting creative problem-solving

We prioritize internal GROWTH & DEVELOPMENT - ATS offers endless opportunities for professional growth and development – with a tuition reimbursement program, individual development programs and a commitment to promoting from within - there is space for you to grow your career at ATS!

We offer COMPETITIVE Total Rewards - Competitive starting salaries, overtime pay eligibility, paid vacation, Employee Incentive Bonus program, comprehensive health and dental benefits including Lifestyle Spending Account, 5% RRSP matching program and optional Employee Share Purchase Program

A place to BELONG: We celebrate our differences and ensure that all employees have equal opportunities for growth and development. We believe that diversity of thought, background, and experiences is essential for our success and innovation.
ATS is in compliance with the Accessibility for Ontarians with Disability Act (AODA), 2005 and will, upon request, assist those who may require specific accommodations due to a personal disability. We would ask that those who require assistance to notify our offices as soon as possible if accommodation is necessary