Excel/VBA Developer

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

Excel/VBA Developer (3‑Month Contract)

Location: Downtown Toronto (Hybrid — 1–2 days per week in office)
Contract Length: 3 months with possible extension
Start Date: Immediate

Our client is a global leader in professional services. They are seeking an experienced Excel/VBA Developer to join the team on a short‑term contract. This role is ideal for someone who thrives on building advanced Excel solutions, integrating external data sources, and optimizing workflows. You’ll be working closely with stakeholders to deliver robust, modular, and scalable tools that support business operations.

Key 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.

• Build and manage ActiveX and Form controls.

• Handle workbook and worksheet‑level events effectively.

• Develop VBA solutions that interact with COM objects.

• Create and distribute add‑ins (XLA/XLAM) for broader team use.

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.

• Skilled in Power Query and Excel Object Model.

• Practical experience with event handling, ActiveX/Form controls, and COM object interaction.

• Ability to design, package, and distribute Excel add‑ins.

• Strong problem‑solving skills and attention to detail.