Vacancy: VBA Developer and Data Analyst

We are currently looking for a UK-based VBA Developer and Data Analyst to join our team. Please continue reading to find out more and apply below.

  • Flexible working hours – choose the times that suit you best
  • 100% remote – no in-person meetings or commute (unless you really want to!)
  • £28k-£37.5k pro-rata – depending on experience
  • Part time or Full-time hours – contracted hours negotiable from 20 to 37.5hrs/wk

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, to fairly simple tools, to complex, mobile-first management systems, often integrating with other web-connected products.

About you

We’re looking for a UK-based VBA Developer and Data Analyst to join our small development team. 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
  • write clean, readable code – including tests!
  • design with the end user in mind
  • enjoy reasoning with difficult problems and creating practical solutions
You must be able to demonstrate:
  • at least 1 year’s experience with VBA and Office Applications
  • awareness of user interface and experience design
  • comprehensive knowledge of user forms, dictionaries and arrays
  • confident with data preparation, modelling and prototyping
  • understanding of exception reporting and system testing.
 Experience with any of the following is a bonus:
  • Powerapps
  • Sharepoint
  • Power BI
  • SQL
  • HTML
In addition to developing business applications, you may be involved in client calls that explore the scope and establish a functional specification. You might also be asked to handle support queries, investigate bug reports, perform upgrades, and occasionally help out with other aspects of the business such as reporting tools.
For a part-time role you should be available for at least 20 hours per week, with flexibility for busier times when agreed in advance. The role is particularly suitable for someone who is a knowledgeable individual comfortable working on a range of projects.

How we work

We’re 100% remote with staff around the country, so we use Slack, Jira and the rest 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.
For an idea of what you’ll be working on, recent projects include:
  • SKU mapping automation
  • Warehouse optimisation tool to complement the client’s existing SAP software
  • Customs invoice automation from Sage exports
  • Proposal documentation automation
  • Word chart automation from imported Excel data
  • Parsing / compiling various files for web app migration

Salary & Benefits

Annual salary of £28,000 – £37,500 pro-rata
Extremely flexible working hours
100% remote – no commute, even after lockdown ends
Company pension scheme
Monthly wellbeing allowance (e.g. gym membership, books, a healthy food box)
30 days holiday entitlement

Application form

We gladly welcome applications from candidates of all backgrounds.

Remember you must be eligible to work in the UK. We do not accept applications from agencies, thanks.

Please complete the application form below, providing your CV, any helpful links such as code examples, and your availability. Don’t forget to tell us a little about yourself!

Apply now

Application – VBA Developer & Data Analyst
Open roles *
Available as a UK contract of employment only.
Not available as a freelance role.