Senior Financial Analyst - VBA Reporting and Analysis

at  Mevotech

JOIN OUR TEAM AT MEVOTECH!

Are you ready to elevate your career with a leading North American aftermarket auto parts company? Mevotech is seeking a Senior Financial Analyst - VBA Reporting and Analysis to join our dynamic team.

ABOUT US

Mevotech is a trusted leader in the aftermarket auto parts industry, specializing in driveline, steering, and suspension parts. With over 40 years of experience, we’re dedicated to engineering excellence, innovation, and delivering exceptional customer experiences. Our commitment to employee wellness and engagement has earned us recognition as one of Canada’s Best Managed Companies.

POSITION OVERVIEW

Reporting to the Manager, Financial Reporting, the Senior Financial Analyst - VBA Reporting and Analysis will work within the financial reporting team to perform day-to-day general ledger accounting and analysis. The focus of the role is to lead the preparation of monthly, quarterly, and annual management accounts for Mevotech subsidiaries, ensuring accuracy and timely completion, as well as performing monthly account reconciliations, assisting external auditors in the year-end close process, and driving financial reporting process improvements for the business. The ideal candidate will utilize advanced reporting and VBA programming to automate and streamline financial processes, enhance data analysis capabilities, and support decision-making across the organization.

Key Responsibilities

• Responsible for performing the day-to-day general ledger accounting, financial reporting, and analysis for assigned functional areas.
• Responsible for month-end, quarter-end and year-end close for assigned functional areas, working closely with other finance and business departments to ensure accurate and timely completion.
• Perform Balance Sheet account reconciliations, working capital analysis, accrual calculations, and other related activities.
• Preparing internal and external reporting over key performance metrics (KPIs) and month-end results.
• Act as a business partner by providing financial results to operational divisions along with analysis support. Develop and maintain VBA macros, scripts, and applications to automate repetitive financial tasks, enhance data manipulation, and improve reporting efficiency.
• Assist in the development and implementation of financial policies, procedures, and controls to ensure compliance with regulatory requirements and industry best practices.
• Design, build, and optimize financial models using Excel and other tools to support budgeting, forecasting, and decision-making processes.
• Conduct in-depth financial analysis, including variance analysis, trend analysis, and scenario modeling, to provide insights into business performance and drive strategic decision-making.
• Prepare and present comprehensive financial reports, dashboards, and presentations for senior management, highlighting key performance indicators, risks, and opportunities.

Ideal Qualifications

• University degree in Accounting or Finance with current CPA/CA certification
• Minimum of 3 years of experience in financial analysis, with a demonstrated track record of using VBA to automate financial processes and enhance data analysis capabilities.
• Advanced proficiency in Microsoft Excel, including VBA programming, macros, pivot tables, and data analysis functions.
• Experience assisting in internal and year-end audits.
• Strong working knowledge of ERP systems (Pronto experience is an asset)
• Exposure to inventory and multiple currency reporting an asset
• Excellent communication and interpersonal skills, with the ability to effectively collaborate with stakeholders at all levels of the organization.
• Proven ability to manage multiple priorities and meet deadlines in a fast-paced, dynamic environment.

• Responsible for performing the day-to-day general ledger accounting, financial reporting, and analysis for assigned functional areas.
• Responsible for month-end, quarter-end and year-end close for assigned functional areas, working closely with other finance and business departments to ensure accurate and timely completion.
• Perform Balance Sheet account reconciliations, working capital analysis, accrual calculations, and other related activities.
• Preparing internal and external reporting over key performance metrics (KPIs) and month-end results.
• Act as a business partner by providing financial results to operational divisions along with analysis support. Develop and maintain VBA macros, scripts, and applications to automate repetitive financial tasks, enhance data manipulation, and improve reporting efficiency.
• Assist in the development and implementation of financial policies, procedures, and controls to ensure compliance with regulatory requirements and industry best practices.
• Design, build, and optimize financial models using Excel and other tools to support budgeting, forecasting, and decision-making processes.
• Conduct in-depth financial analysis, including variance analysis, trend analysis, and scenario modeling, to provide insights into business performance and drive strategic decision-making.
• Prepare and present comprehensive financial reports, dashboards, and presentations for senior management, highlighting key performance indicators, risks, and opportunities