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
.png)
Cloud • Insurance • Payments • Software • Business Intelligence • App development • Big Data Analytics
Lead and modernize QA strategy across cloud-native insurance connectivity platforms. Drive AI-assisted test generation, automation frameworks, performance and regression testing, release validation, quality metrics, and mentor QA leaders to improve release confidence and reliability.
Top Skills:
Ai FrameworksAPIsCloud-Native ApplicationsDevOpsDistributed Messaging SystemsEvent-Driven ArchitecturesGoogle Cloud Platform (Gcp)JavaLookerMessage QueuesPerformance TestingRegression TestingSpringTest Automation Frameworks
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Manage and optimize procurement processes, supplier relationships, and contracts to drive cost savings and operational efficiency. Perform cost analysis, use procurement systems, lead negotiations, monitor supplier performance, and provide reporting to support sourcing decisions and alignment with organizational goals.
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Lead the architectural vision for Bizplat, consolidate fragmented services into unified platform systems, design reusable capabilities (case management, workflow orchestration, AI/ML pipelines, event streaming, integration frameworks), drive cross-team technical strategy, set engineering standards, mentor engineers, and partner with business stakeholders to translate operational needs into scalable, governable solutions.
Top Skills:
AirflowGoGraphQLJavaKafkaKubernetesLlmsRubyTemporal
What you need to know about the Montreal Tech Scene
With roots dating back to 1642, Montreal is often recognized for its French-inspired architecture and cobblestone streets lined with traditional shops and cafés. But what truly sets the city apart is how it blends its rich tradition with a modern edge, reflected in its evolving skyline and fast-growing tech industry. According to economic promotion agency Montréal International, the city ranks among the top in North America to invest in artificial intelligence, making it le spot idéal for job seekers who want the best of both worlds.
Key Facts About Montreal Tech
- Number of Tech Workers: 255,000+ (2024, Tourisme Montréal)
- Major Tech Employers: SAP, Google, Microsoft, Cisco
- Key Industries: Artificial intelligence, machine learning, cybersecurity, cloud computing, web development
- Funding Landscape: $1.47 billion in venture capital funding in 2024 (BetaKit)
- Notable Investors: CIBC Innovation Banking, BDC Capital, Investissement Québec, Fonds de solidarité FTQ
- Research Centers and Universities: McGill University, Université de Montréal, Concordia University, Mila Quebec, ÉTS Montréal
