At a Glance
- Tasks: Design and build automation solutions using Excel and VBA to streamline workflows.
- Company: Join a leading analytics company that empowers Fortune 500 clients with data-driven insights.
- Benefits: Competitive daily rate, flexible onsite work, and a vibrant team culture.
- Other info: Dynamic environment with opportunities for growth and collaboration with enthusiastic professionals.
- Why this job: Make a real impact by optimising processes and enhancing decision-making for top companies.
- Qualifications: Experience in VBA, Excel, and financial services preferred; strong problem-solving skills required.
The predicted salary is between 30000 - 40000 € 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
Fractal Analytics is an exceptional employer that fosters a vibrant work culture where passion and customer focus drive innovation. As a VBA Developer, you'll have the opportunity to work on impactful projects for Fortune 500 companies in London, with a commitment to employee growth through hands-on experience in automation and analytics. Enjoy a collaborative environment that values creativity and offers flexible onsite work arrangements, making it an ideal place for those seeking meaningful and rewarding employment.
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 and solve problems in real-time.
✨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!
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 quickly.
Apply Through Our Website:Remember to submit your application through our website! It’s the best way for us to receive your details 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
✨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 Power Query in past projects.
✨Showcase Your Problem-Solving Skills
Prepare examples of how you've identified automation opportunities and streamlined processes in previous roles. Highlight your ability to balance speed with robustness and maintainability when delivering solutions.
✨Communicate Clearly
Practice explaining technical concepts in simple terms. You might need to translate complex ideas for non-technical stakeholders, so being able to communicate effectively is key. Bring along any documentation or training materials you've created as evidence of your communication skills.
✨Demonstrate Your Project Management Abilities
Be ready to discuss how you've managed project timelines and prioritised tasks in the past. Share specific examples of how you've delivered on commitments and handled backlogs of enhancements, as this will show your strong ownership and project delivery skills.
