VBA Developer

Location: London

Time Type: Full time

Job Description

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.

VBA Developer

2 month contract

£320 per day inside IR35

Location: UK - London (onsite 2/3 days per week)

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 is 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, prioritize 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, prioritization, 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!

Hiring Related Queries

India: [email protected]

Outside India: [email protected]

This inbox does not process resume submissions. All applications must be made through posted job openings

Not the right fit?  Let us know you're interested in a future opportunity by clicking Introduce Yourself in the top-right corner of the page or create an account to set up email alerts as new job postings become available that meet your interest!