Develop, maintain, and troubleshoot Excel VBA macros to automate reporting, data analysis, inventory tracking, and financial workflows. Manage large datasets, optimize processes to reduce manual work, collaborate with Operations/Finance/Sales to gather requirements, document code and workflows, and provide ongoing maintenance and support.
This is a remote position.
We are seeking a skilled and detail-oriented Excel VBA Developer to automate and optimize Excel-based workflows and data processes. The ideal candidate will have strong expertise in VBA programming and a proven ability to streamline business operations, reduce errors, and improve efficiency.
This role will contribute to building scalable and efficient internal workflows, supporting the company’s mission to deliver quality products to customers through innovative and sustainable practices.
Requirements
Key Responsibilities
- Excel VBA Automation: Develop, enhance, and maintain VBA-based macros to automate processes such as reporting, data analysis, inventory tracking, and financial workflows.
- Data Management & Reporting: Automate report generation, manage large datasets, and ensure accurate data entry and analysis.
- Process Optimization: Identify opportunities for automation and streamline existing workflows to minimize manual tasks.
- Team Collaboration: Work with internal teams (e.g., Operations, Finance, Sales) to understand requirements and deliver tailored solutions.
- Maintenance & Troubleshooting: Monitor and troubleshoot existing VBA scripts, resolving issues promptly to ensure smooth operations.
- Documentation: Create detailed documentation for VBA code and workflows to facilitate clarity and future reference.
Required Qualifications
- Proven experience in developing and maintaining Excel VBA macros.
- Strong knowledge of Excel functions, formulas, and data analysis tools.
- Expertise in handling and manipulating large datasets in Excel.
- Strong problem-solving skills and a proactive approach to resolving issues.
- Attention to detail and a commitment to delivering high-quality results.
- Ability to work independently and manage tasks to meet deadlines.
- Effective communication skills to collaborate with cross-functional teams.
Preferred Qualifications
- Experience with additional programming or automation tools (e.g., SQL, Python) is a plus.
- Familiarity with supply chain management or similar industries is an advantage.
Similar Jobs
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Lead regulatory trade compliance initiatives, develop and maintain compliance programs, guide teams through audits and risk assessments, provide strategic regulatory advice, and coach staff. Apply systems thinking to identify risks, craft clear communications, validate outcomes with stakeholders, and reinforce professional standards and the firm’s code of conduct.
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Lead SAP finance application implementations, analyze client requirements, design solutions, manage project delivery and budgets, provide training and support, mentor team members, ensure compliance and quality, and identify process improvement opportunities to optimize financial reporting and forecasting.
Top Skills:
Sap Central FinanceSap Core ErpSap Fico
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Lead implementation and integration of SAP finance applications, analyze client requirements, develop tailored solutions, manage large-scale projects, coach teams, provide training and support, and drive finance transformation and improved financial reporting.
Top Skills:
Sap Central FinanceSap ErpSap Fico
What you need to know about the Toronto Tech Scene
Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.
