Excel/VBA Developer — 3-Month Contract (Hybrid)

HRB; Toronto; Hybrid; CAD 60,000 - 80,000; Full time

Job summary

A professional services firm in Toronto is seeking an experienced Excel/VBA Developer for a 3-month contract. This hybrid role requires building advanced Excel solutions and integrating external data sources to support business operations. Key responsibilities include developing VBA code, applying advanced Excel formulas, and managing ActiveX controls. Candidates should have a strong background in Excel development and automation, with excellent problem-solving skills.

Qualifications

• Proven expertise in Excel VBA development and automation.
• Strong proficiency with advanced Excel functions and formulas.
• Hands-on experience integrating Excel with SharePoint and SQL databases.

Responsibilities

• Design and develop modular VBA code using procedures and functions.
• Apply advanced Excel formulas, including dynamic arrays and LAMBDA functions.
• Integrate Excel solutions with external data sources (SharePoint lists, SQL databases).
• Implement version control within macro‑enabled workbooks.
• Utilize Power Query for data transformation and automation.
• Leverage the Excel Object Model with deep knowledge of Application, Workbooks, Worksheets, Range, and related objects.

Skills

Excel VBA development

Advanced Excel functions

Integration with SharePoint

Integration with SQL databases

Power Query skills

Event handling

ActiveX/Form controls

COM object interaction

Problem-solving skills

Job description

A professional services firm in Toronto is seeking an experienced Excel/VBA Developer for a 3-month contract. This hybrid role requires building advanced Excel solutions and integrating external data sources to support business operations. Key responsibilities include developing VBA code, applying advanced Excel formulas, and managing ActiveX controls. Candidates should have a strong background in Excel development and automation, with excellent problem-solving skills.