At a Glance
- Tasks: Design and build automation solutions using Excel and VBA to streamline workflows.
- Company: Join a leading analytics company that values passion and innovation.
- Benefits: Competitive pay, flexible work environment, and opportunities for professional growth.
- Other info: Dynamic team culture with a focus on creativity and collaboration.
- Why this job: Make a real impact by optimising data processes for Fortune 500 companies.
- Qualifications: Experience in VBA, Excel, and a strong understanding of data management.
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 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'll have the opportunity to work on impactful projects for Fortune 500 companies in London, with a strong emphasis on professional growth and collaboration. Enjoy competitive compensation, a supportive environment, and the chance to contribute to cutting-edge analytics solutions while working alongside enthusiastic over-achievers.
StudySmarter Expert Advice🤫
We think this is how you could land VBA Developer
✨Tip Number 1
Get your networking game on! Reach out to folks in the industry, especially those who work at Fractal Analytics or similar companies. A friendly chat can sometimes lead to opportunities that aren’t even advertised!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your VBA projects and automation solutions. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for the interview like it’s a big exam! Brush up on your technical skills, especially around Excel and VBA. Be ready to discuss your past projects and how you tackled challenges in automation.
✨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
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 the details that show off your expertise!
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 see what you bring to the table!
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 Power Query in past projects.
✨Showcase Your Problem-Solving Skills
Prepare examples of how you've identified automation opportunities and streamlined workflows. Highlight specific instances where your solutions improved efficiency or accuracy, as this will resonate well with the company's focus on delivering impactful analytics.
✨Communicate Clearly
Practice explaining technical concepts in simple terms. You might need to translate complex VBA processes into layman's terms for non-technical stakeholders, so being able to communicate effectively is key.
✨Demonstrate Your Project Management Skills
Be ready to discuss how you manage project timelines and prioritise tasks. Share examples of how you've delivered on commitments and handled backlogs, as this aligns with their emphasis on ownership and timely delivery.
