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
Cloud • Security • Software • Cybersecurity • Automation
Lead cross-functional Developer Experience initiatives across six teams, contributing hands-on backend code in Ruby and Go. Improve testing reliability, test coverage, CI/CD pipelines, logging standards, and development environments. Partner with engineering, platform, product, and infrastructure teams to identify friction, remove systemic bottlenecks, shape the Developer Experience Platform strategy, and foster continuous engineering improvement.
Top Skills:
Ci/CdDevOpsGoLogging LibrariesRubyTest Coverage ReportingTesting Frameworks
.png){kind=logo}
Software
Manage a team building and maintaining New Relic’s GTM revenue automation engine. Integrate Salesforce, Clay, Rox, Boomi, Salesloft, and related systems; build AI-enabled workflows for lead scoring, routing, alerts, and outreach; maintain data pipelines, data quality, dashboards, and forecasting; and lead technical projects from requirements through adoption. The role requires hands-on integration engineering, Python/API expertise, GTM systems knowledge, cross-functional collaboration, and experience translating revenue data into business insights.
Top Skills:
Ai/MlAPIsBoomiClayETLLlmsPythonRoxSalesforce Sales CloudSalesloftWebhooks
Big Data • Information Technology • Software • Analytics • Energy
Extract, transform, validate, and load client PDFs and structured data into the MineralSoft platform using AI-driven extraction and ETL tools. Configure datasets, run queries and reports, troubleshoot integrations with EnergyLink, and ensure data quality and consistency while collaborating with cross-functional teams.
Top Skills:
Ai-Based Document Extraction ToolsAi-Enabled ToolsCsvEnergylinkETLExcelJSONMineralsoft
What you need to know about the Vancouver Tech Scene
Raincouver, Vancity, The Big Smoke — Vancouver is known by many names, and in recent years, it has gained a reputation as a growing hub for both tech and sustainability. Renowned for its natural beauty, the city has become a magnet for professionals eager to create environmental solutions, and with an emphasis on clean technology, renewable energy and environmental innovation, it's attracted companies across various industries, all working toward a shared goal: advancing clean technology.
