VBA Developer

Location: London (3 days a week in-office)
Team: Special Uploads
Reports to: Chief Product Officer

About PRODA

At PRODA (www.proda.ai) we are building software to unlock the full potential of Real Estate Data no matter the asset class, language or country of origin.

Our SaaS solution leverages the latest technologies in machine learning and large language models to automatically capture, standardise and quality check Real Estate data into a single, clean source of truth. The goal is to empower real estate professionals to quickly gain actionable insights from their data and to enable the effective use of software.

Despite being the biggest asset class in the world, the commercial real estate industry relies on excel & PDF “Rent Roll” documents as the primary means of exchanging data. These files are frequently inconsistent, inaccurate, and inaccessible, posing challenges for real estate professionals. Through automated data capture, standardisation, and analysis, PRODA can:

• Build repositories of clean, standardised data
• Increase process efficiency, through faster report generation
• Improve data-driven decision making, by ensuring the accuracy of input data

Furthermore, PRODA easily integrates with existing systems, to ensure consistent dataflow through the whole organisation.

Founded in 2017 by Charles and Peter, two former Real Estate Finance Investment professionals, PRODA is now 65 people strong, and expanding rapidly following a successful fund raise in 2025.

PRODA has a strong globally recognised client base with an even better sales pipeline. We are looking for you to join us on our exciting journey delivering best-in-class software to the Commercial Real Estate market globally.

About The Role

We are seeking an experienced VBA Developer to maintain and enhance a large-scale, business-critical Excel/VBA application used daily by our Special Uploads team. The application contains 10,000+ lines of VBA code, spread across multiple modules, and performs complex data restructuring and transformation tasks with heavy optimisation for performance.
This role requires both deep technical skill and a careful, methodical approach, as stability and accuracy are essential. You will work closely with a group of Analysts based in London, gathering requirements, implementing improvements, and ensuring the system remains robust and reliable.

Responsibilities

• Maintain and further develop a complex VBA application.
• Investigate, diagnose, and fix bugs with minimal disruption.
• Collaborate with Analysts to translate requirements into technical solutions.
• Optimise code for speed, efficiency, and maintainability.
• Add clear documentation and comments to existing and new code.
• Implement structured testing to prevent regressions.
• Provide user support and guidance on new features or changes.
• Suggest and implement process improvements or automation where appropriate.

Skills & Qualifications

Essential

• 5+ years professional experience with advanced VBA development in Excel.
• Proven track record working on large, complex VBA projects (>10k lines of code).
• Excellent debugging and problem-solving ability.
• Strong understanding of performance optimisation in VBA.
• Ability to communicate clearly with non-technical colleagues.
• Careful, detail-oriented approach with strong sense of responsibility.

Desirable

• Exposure to other scripting/automation tools (Python, Power Automate, SQL).
• Experience working with data-heavy processes.
• Familiarity with structured development practices such as version control, peer review, or testing frameworks.

Who We’re Looking For

• A highly capable VBA developer who is also humble, collaborative, and dependable.
• Someone motivated by solving complex technical challenges in a disciplined way.
• Comfortable being the go-to VBA expert for a small Analyst team.
• Interested in staying with us for the longer term, building trust and continuity.

Why Join Us?

• Take ownership of a highly complex VBA system central to business operations.
• Work directly with a skilled and collaborative Analyst team.
• Be valued for both your technical expertise and team-first attitude.
• Join a supportive, people-focused environment with opportunities to grow.

Working at PRODA

As a rapidly growing SaaS business, life at PRODA is fast-paced and collaborative. Our day-to-day work is solving interesting problems using smart technologies, and we pride ourselves on an environment where we can rapidly develop new skills, learn from each other, and truly see the impact of our work.

We believe that our product is transformative, and we work hard to ensure it reaches its potential. Our team is our greatest asset: we are a close-knit group who pull together to achieve our goals, but we also have fun!

Further to a strong team environment, working at PRODA offers the following amenities:

• Flexible Hybrid working options
• Stock Options in the Business
• 25 days base holiday
• Full zero-excess Private Health Insurance
  • Includes Couple and Family plans
• Private Dental Insurance
  • Includes Couple and Family plans
• Generous Pension Schemes
• Individual Professional Development Budget
• Regular Social Activities and Events

PRODA treats people fairly. We are an equal opportunities employer and view all applications equally, regardless of gender, colour, ethnic background, religion, disability, age, sexual orientation, gender reassignment or marital/family status.