Skip to content

Vacancy: VBA Developer and Spreadsheet Wizard

About you

Are you weirdly obsessed with spreadsheets? Do you want a flexible remote working arrangement that suits you?

Do you regularly build complex automation tools using VBA that save you, your colleagues or clients lots of time? Do you build whizzy userforms; lightning fast reporting tools; mini databases? Can anyone use the tools you make without long written instructions, even if they don’t know much about Excel?

You might be who we’re looking for!

Developer looking at spreadsheet

Thank you for your interest, this vacancy has now closed.

The opportunity: Part-time VBA developer and spreadsheet consultant

We are currently looking for a UK-based VBA Developer to join our team.

  • Flexible working hours – choose the times that suit you best, so long as there is some overlap throughout the week with regular working times.
  • 100% remote – no in-person meetings or commute (unless you really want to!)
  • Part time hours – contracted hours negotiable around 15-18.75hrs/wk over 4-5 days
  • £20-23/hr (£39k-£45k pro-rata) – depending on experience
  • Employee Assistance Program including 24/7 Virtual GP and Mental Health Counselling
  • Group Income Protection, Group Life Insurance
  • 6.6wks annual holiday (including public)
  • 5% employer pension contribution
  • Choice of additional benefits after successful probationary period

About us

We are a software development agency in Edinburgh, Scotland. We specialise in creating bespoke tools and applications for SMEs, with a focus on business automation, problem solving and streamlining.

Our clients come from a variety of sectors, with a common thread being a need to replace their existing, often manual, processes with MS Office or web based applications. Deliverables range from technical documentation and fairly simple business tools, to complex, mobile-first management systems, often integrating with other web-connected products.
Illustration of people using software

The role

You’ll be involved in scoping projects and understanding the client needs, creating business tools, adding functionality to existing projects and supporting our web development team’s data requirements and quality assurance processes.

 Firstly, it’s important that you:
  • can communicate clearly while working remotely
  • enjoy reasoning with difficult problems and creating practical solutions
You must be able to demonstrate:
  • competence developing applications with VBA
  • ability to design systems that are cleanly laid out and simple for an end user
  • comprehensive knowledge of:
    • userforms
    • collections, dictionaries
    • arrays
  • ability to write efficient code for speed of operation
  • confidence with data preparation, modelling and prototyping and testing your own work
  • understanding of the importance of readable naming conventions, code commentary and clean modular code
 Experience with any of the following is a bonus:
  • Classes
  • Google Sheets and related scripts
  • Sharepoint
  • Basic knowledge of SQL, HTML, PHP

What it’s like day to day

The role is particularly suitable for someone who is comfortable working on a range of projects.

  • Sometimes we’re building charts, graphs and reporting templates. 
  • Other times we’re importing huge datasets from third party systems that we don’t have control over. That data can be messy and so exception management and reporting is key.
  • Often we’re designing complex userforms to manage interlinked data tables within a user friendly interface. Think of it like a precursor to a database centric solution.
In addition to developing business applications, you may be involved in client calls that explore the project requirements, define the scope of works and establish the functional specification. You might also be asked to occasionally help out with other aspects of the business such as data migration and reporting tools.

How we work

We’re 100% remote with staff around the country, so we use Slack and Teams t to keep up-to-date with each other. We typically work Monday-Friday but we’re flexible provided there’s some guaranteed overlap for regular meetings, virtual cups of tea and a chat.

We approach our clients’ projects with an open mind, so the same thing applies internally – we’re keen on suggestions for improving our codebase and workflows.
 

Thank you for your interest, this vacancy has now closed.

Check you meet the criteria and apply now

VBA Vacancy Criteria Check
Which of these best describes your circumstances? *

Please note, this role is available as a UK contract of employment only and is not available to work on a freelance basis.

Applicants must be resident in the UK and able to demonstrate their eligibility to work in the UK. You can find eligibility information on the UK Govt website: https://www.gov.uk/prove-right-to-work

Please note that we do not currently accept applications from agencies.

Right to work *

Next steps and things that might be of interest

Once you’ve completed the eligibility check and submitted your application, you should receive an acknowledgement by email.

It may take us a few days to process your application – one way or another you’ll get an email from us letting you know the outcome.

In case you missed it, you might be interested in finding out more about us and the kind of work we do: