Sql data analyst Jobs in Cambridge, ON

Senior Financial Analyst

WHAT'S IN IT FOR YOU

Benefits:

• Compensation: $84,000 – $115,500 CAD annually
• Annual Performance-Based Incentive Bonus
• 5% RRSP match
• Stock purchase plan
• Starting 3 weeks of vacation
• Benefits package (health and dental) + $600 health spending account
• Half-Day Fridays
• Continuous learning and career growth with global mobility opportunities.
• A chance to contribute to something bigger - advancing the future of healthcare through automation.

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 complex 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