Remote - US Open Location

VBA Consultant-Contract Project

North America

Reports to: Product Manager

Position summary

Looking for a Contractor or Freelancer who will design, develop and test Excel macros for Financial Accounting use cases with Winshuttle’s Studio product.  It is perfect for someone between projects or wanting to pick up freelance work. This role requires an individual to build high-quality, easy to understand, and fully functional Excel macros in software templates in compliance with coding standards and technical design for our default template library. This role requires professional level skills and a full understanding of Visual Basic for Applications (VBA) for Microsoft Excel 2016 and 2019.


About Winshuttle

Are you interested in working in a fun, collaborative environment, for an award winning workplace? Winshuttle is dedicated to fostering a culture of respect and innovation to support and empower employees' ambitions. We're constantly looking for entrepreneurs who aren't afraid to think outside the box, and don't take themselves too seriously. We embrace and support our employees who seek opportunities for continued learning, inspire others, and live and breathe our core PACT values. We have a work hard, play hard mentality; we're constantly evolving lean solutions for ERP business processes by day, and dominating on the frisbee golf course by night. Our strength and competitive advantage stems from our awesome employees, and we strive to create a balanced work life that is as inspiring and rewarding as life at home. Think you might be a great fit?

Essential functions and responsibilities

  • Works with product owner to review prototype macros and requirements to understand desired macro functionality.
  • Provides macro design, coding, macro unit testing, and debugging for Financial Accounting macros in Microsoft Excel templates to be used with Winshuttle’s Studio product.
  • Writes programs according to Agile stories and associated requirements specifications from the product owner, also ensuring high standard of product quality.
  • Makes solution demos for problem solutions to use for knowledge transfer to Sales Solutions Engineering, Engineering, and Customer Support teams.
  • Participates in performing code reviews of their software.
  • Requires good understanding of Visual Basic for Application domain knowledge and co-relation with Microsoft Excel.
  • To co-ordinate and communicate with global product management, program management, QA, technical support, and sales teams at various stages of product development.
  • Should have Experience of working on JIRA User Story/Task
  • 3+ years of development experience in Visual Basic for Applications (VBA) – Should be able to write excel macros and unit test cases
  • Experience of localization of software into German, French and Spanish is desirable
  • Proficiency in Excel 2013, 2016
  • Knowledge of Object Oriented programming and SQL
  • Knowledge of Software Development Life Cycle and Agile Software Development
  • Basic understanding of .Net Programming

Desired behaviors

  • Receptive to change – is flexible. Seeks and adopts improved approaches and processes.
  • Initiates action – is results oriented, takes responsibility for actions and outcomes. Meets commitments and strives for high performance.
  • Manages the workload – makes timely decisions, prioritizes effectively, solves problems, monitors results and takes remedial action where necessary.
  • Technically proficient – knows role and has a solid familiarity with tasks and responsibilities.
  • Takes responsibility for own learning – knows personal strengths and recognizes development needs. Is open to feedback and always seek to learn.
  • Communicates ideas – strong facilitation and written communication, proposes a way forward. Listens to views of colleagues and takes in diverse perspectives.
  • Works collaboratively – shares information, fosters teamwork and contributes to positive work environment where people want to come to work.
  • Display ethical character and competence – acts with integrity and intent, is accountable for own actions, behaves according to the PACT values. Act as a good citizen of Winshuttle.


  • Proven ability to effectively work with product owner, QA, technical writer, and customer support for software development projects
  • Proven ability to understand the impact of technology on business challenges, processes, & efficiency
  • Demonstrated ability to explain benefits of a technical product / solution to a client in relation to the client’s business needs
  • Demonstrated ability to work interdependently and to manage multiple projects concurrently
  • Ability to translate technical information into easy to understand language for customers
  • Demonstrated ability to read and interpret technical information
  • Demonstrated ability to compose clear and concise technical written communication


  • BE/BTech/MCA/Equivalent degree in Computer Science or a related technical field from an accredited university or college with 2+ years demonstrated experience and successful track record in architecting, designing and developing desktop / Web based applications and Add-in applications using Microsoft VBA and Office technologies

At Winshuttle, we celebrate and support our differences. We know employing a team rich in diverse thoughts, experiences, and opinions allows our employees, our products, and our community to flourish. Winshuttle is honored to be an equal opportunity workplace. We are dedicated to equal employment opportunities regardless of race, color, ancestry, religion, sex, national orientation, age, citizenship, marital status, disability, gender identity, sexual orientation, or Veteran status.

This job posting does not imply that these are the only duties to be performed. Employees occupying this position will be required to follow any other-related instructions and to perform any other job related duties requested by their supervisor. To perform this job successfully, an individual must be able to perform each essential duty and meet the physical requirements satisfactorily. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential functions.

Privacy notice for European applicants