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
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Manage the full sales cycle for SMB merchants: convert inbound leads, prospect to build pipeline, forecast in Salesforce, collaborate cross-functionally, provide consultative solutions, and consistently meet or exceed monthly and quarterly revenue targets. Bilingual (French/English) role with high activity volume and short sales cycles.
Top Skills:
CRMSalesforce
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Lead architecture and technical strategy for AI-driven product quality systems using LLMs and agents. Build scalable evaluation frameworks, detect regressions, generate insights, and drive cross-functional adoption while mentoring engineers and defining standards for trustworthy AI.
Top Skills:
AgentsAi InfrastructureEvaluation SystemsLlmsRetrieval Architectures
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Responsible for full-cycle B2B sales to mid-market merchants: build and manage pipeline, prospect, demo multi-product Square solutions, negotiate complex contracts, collaborate cross-functionally, maintain accurate Salesforce forecasts, and consistently hit monthly and quarterly revenue targets.
Top Skills:
Salesforce
What you need to know about the Calgary Tech Scene
Employees can spend up to one-third of their life at work, so choosing the right company is crucial, not just for the job itself but for the company culture as well. While startups often offer dynamic culture and growth opportunities, large corporations provide benefits like career development and networking, especially appealing to recent graduates. Fortunately, Calgary stands out as a hub for both, recognized as one of Startup Genome's Top 100 Emerging Ecosystems, while also playing host to a number of multinational enterprises. In Calgary, job seekers can find a wide range of opportunities.

