VBA Developer

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.

Do you have experience in VBA?, * 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!

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.