ExcelVBA Developer

Toronto - Canada

Monthly Salary: Not Disclosed

Posted on: 13 hours ago

Vacancies: 1 Vacancy

Job Summary

Excel/VBA Developer (3Month Contract)

Location: Downtown Toronto (Hybrid 12 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 shortterm contract. This role is ideal for someone who thrives on building advanced Excel solutions integrating external data sources and optimizing workflows. Youll 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 macroenabled 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 worksheetlevel events effectively.
Develop VBA solutions that interact with COM objects.
Create and distribute addins (XLA/XLAM) for broader team use.

Qualifications

Proven expertise in Excel VBA development and automation.
Strong proficiency with advanced Excel functions and formulas.
Handson 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 addins.
Strong problemsolving skills and attention to detail.

Excel/VBA Developer (3Month Contract)Location: Downtown Toronto (Hybrid 12 days per week in office)Contract Length: 3 months with possible extensionStart Date: ImmediateOur client is a global leader in professional services. They are seeking an experienced Excel/VBA Developer to join the team on a ...