VBA Developer

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 a leading partner for Fortune 500 companies, leveraging Big Data, analytics, and technology to drive smarter, faster, and more accurate decisions across every aspect of their business. Our focus is on predictive analytics and visual storytelling to deliver insight, innovation, and impact for our clients.

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 optimisation, query optimisation, 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 payments industry (e.g., Visa, Mastercard, American Express, Discover) is preferred.
• Knowledge of advanced Excel formulas (INDEX/XMATCH, SUMPRODUCT, LET/LAMBDA, dynamic arrays).
• Experience with PivotTables, Power Query (Get & Transform), and basic Data Model.
• Hands‑on experience writing clean and modular VBA code (procedures/functions, class modules, user forms, events, error handling, logging).
• Proficiency in ETL concepts: text/CSV/Excel parsing, deduplication, reconciliation, data quality checks.
• Understanding of relational concepts (keys, joins) and basic SQL (SELECT, JOIN, WHERE, GROUP BY).

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, stakeholder updates; ability to explain technical topics to non‑technical users.
• Project Delivery – estimation, prioritisation, 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!