At a Glance
- Tasks: Design and build automation solutions using Excel and VBA to streamline workflows.
- Company: Join a passionate team at Fractal Analytics, driving innovation for Fortune 500 companies.
- Benefits: Competitive daily rate, onsite collaboration, and a dynamic work environment.
- Other info: Enjoy growth opportunities in a supportive, enthusiastic workplace.
- Why this job: Make a real impact by optimising data processes and enhancing decision-making.
- Qualifications: Experience in VBA, Excel, and financial services preferred; strong problem-solving skills required.
The predicted salary is between 57600 - 57600 € per year.
It's fun to work in a company where people truly BELIEVE in what they are doing! We're committed to bringing passion and customer focus to the business.
Fractal Analytics is leading Fortune 500 companies leverage Big Data, analytics, and technology to drive smarter, faster, and more accurate decisions in every aspect of their business. Fortune 500 companies recognize analytics as a competitive advantage to understand customers and make better decisions. We deliver insight, innovation, and impact to them through predictive analytics and visual storytelling.
Summary: We are looking for a VBA consultant (Excel & VBA expert) to design, build, and maintain robust automation solutions that streamline data processing, reporting, and operational workflows. The ideal candidate will own end-to-end automation—from requirements gathering and solution design to testing, deployment, documentation, and maintenance—while ensuring high accuracy, performance, and security.
Roles and Responsibilities:
- Analyse manual processes and identify automation opportunities across workflows.
- Design and develop Excel VBA macros, user forms, and add-ins to automate data ingestion, transformation, validation, and reporting.
- Build modular, reusable code libraries and templates to standardize solutions and accelerate delivery.
- Optimize large workbooks for performance (calculation tuning, formula optimization, query optimization, memory management).
- Build ETL pipelines using Excel/VBA (and Power Query where applicable), SQL to pull data from flat files, SharePoint, databases, and APIs (via ODBC/OLE DB where available).
- Develop dynamic dashboards and reports with best-practice design (structured references, named ranges, data models, PivotTables, slicers, and charts).
- Implement robust data validation, reconciliation checks, and exception handling with clear audit trails and logs.
- Establish coding standards, version control practices, error handling patterns, and documentation for maintainability.
- Conduct unit, integration, and regression testing; build automated test routines where feasible.
- Provide training, playbooks, and handover documentation for business users.
- Translate business requirements into technical specifications with measurable acceptance criteria.
- Manage a backlog of enhancements, prioritise based on impact, and deliver on committed timelines.
Mandatory technical skills:
- Prior experience in financial services or Payment’s industry is preferred (Visa, Mastercard, American Express and Discover).
- Knowledge of advanced formulas (INDEX/XMATCH, SUMPRODUCT, LET/LAMBDA, dynamic arrays), PivotTables, Power Query (Get & Transform), Data Model basics - Mandatory.
- Hands-on experience in writing clean and modular VBA code (procedures/functions), class modules, user forms, events, error handling, logging - Mandatory.
- ETL concepts, text/CSV/Excel parsing, deduping, reconciliation, and data quality checks - Mandatory.
- Understanding of relational concepts (keys, joins) and basic SQL (SELECT, JOIN, WHERE, GROUP BY) for data extraction.
Non-technical skills:
- Business Analysis: Ability to map current processes (AS‑IS), design target state (TO‑BE), and quantify ROI/time saved.
- Communication: Clear documentation, user training, and stakeholder updates; ability to explain technical topics to non-technical users.
- Project Delivery: Estimation, prioritisation, and on-time delivery with strong ownership.
- Problem Solving: Bias for simplification; balancing speed with robustness and maintainability.
- Quality Mindset: Detail‑oriented with a strong focus on accuracy, data integrity, and governance.
If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!
VBA Developer in London employer: Fractal Analytics
Fractal Analytics is an exceptional employer that fosters a vibrant work culture where passion and customer focus drive innovation. As a VBA Developer, you will have the opportunity to work on impactful projects for Fortune 500 companies, with a strong emphasis on professional growth and collaboration. The London location offers a dynamic environment, allowing you to engage with talented colleagues while enjoying the benefits of a flexible onsite schedule.
StudySmarter Expert Advice🤫
We think this is how you could land VBA Developer in London
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work with VBA or in financial services. A friendly chat can lead to insider info about job openings that aren't even advertised yet.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best VBA projects. This could be anything from automation solutions to dynamic dashboards. When you apply, link to it so potential employers can see what you're capable of.
✨Tip Number 3
Prepare for interviews by brushing up on common VBA questions and practical tests. Practice coding on the spot, as many companies will want to see how you think through problems. We can help you with resources to get ready!
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who are proactive about their job search. Let’s land that VBA Developer role together!
We think you need these skills to ace VBA Developer in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the VBA Developer role. Highlight your experience with Excel, VBA, and any relevant projects you've worked on. We want to see how your skills match what we're looking for!
Showcase Your Projects:Include specific examples of automation solutions you've designed or built. We love seeing real-world applications of your skills, so don’t hold back on sharing your successes!
Be Clear and Concise:When writing your application, keep it clear and to the point. Use bullet points where possible to make it easy for us to read through your qualifications and experiences.
Apply Through Our Website:Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. We can’t wait to hear from you!
How to prepare for a job interview at Fractal Analytics
✨Know Your VBA Inside Out
Make sure you brush up on your VBA skills before the interview. Be ready to discuss your experience with writing clean, modular code and how you've used advanced Excel functions like INDEX/XMATCH and SUMPRODUCT in real projects.
✨Showcase Your Problem-Solving Skills
Prepare examples of how you've identified automation opportunities in past roles. Think about specific challenges you faced and how you simplified processes while ensuring accuracy and data integrity.
✨Communicate Clearly
Practice explaining technical concepts in a way that non-technical stakeholders can understand. This is crucial, as you'll need to translate business requirements into technical specifications during your role.
✨Demonstrate Project Ownership
Be ready to discuss how you've managed project timelines and prioritised tasks in previous jobs. Highlight your ability to deliver on commitments and how you handle feedback and enhancements.
