At a Glance
- Tasks: Design and build automation solutions using Excel and VBA to streamline workflows.
- Company: Join a leading Fortune 500 company focused on innovation and analytics.
- Benefits: Competitive pay, flexible work environment, and opportunities for professional growth.
- Other info: Dynamic team culture with a focus on collaboration and creativity.
- Why this job: Make a real impact by optimising data processes and enhancing decision-making.
- Qualifications: Experience in VBA, Excel, and financial services preferred.
The predicted salary is between 76800 - 76800 £ 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.
2 month contract
£320 per day inside IR35
Location: UK - London (onsite 2/3 days per week)
The company 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!
VBA Developer in London employer: United States Digital Space LLC
Join a dynamic and innovative team where your expertise as a VBA Developer will be valued and nurtured. With a strong commitment to employee growth, we offer a collaborative work culture that encourages creativity and passion, all while working with leading Fortune 500 companies in the heart of London. Enjoy competitive pay, flexible onsite arrangements, and the opportunity to make a significant impact through cutting-edge analytics and technology.
Contact Details:
United States Digital Space LLC Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land VBA Developer in London
✨Tap into Online Data Science Communities
Join online communities focused on data science like Kaggle, LinkedIn groups, or Reddit threads. These are goldmines for temporary gigs, as you can network with professionals and potentially hear about opportunities at companies like United States Digital Space LLC before they're even advertised!
✨Show Off Your Skills With Projects
Got some cool data science projects? Showcase them on platforms like GitHub or create a personal portfolio website. This visibility is crucial for landing temporary roles—let recruiters see your actual skills in action, which can set you apart from the crowd.
✨Check Out Specialist Job Boards
For temp roles, hit up job boards dedicated to tech and data science, like Stack Overflow Jobs or DataJobs. These platforms often feature openings that you won’t find on general job sites, including contracts with companies like United States Digital Space LLC.
✨Leverage University Resources
If you're currently at uni or recently graduated, tap into your school's career services. They often have connections with companies looking for temporary data science interns or contract workers, and they might even host job fairs with employers like United States Digital Space LLC.
We think you need these skills to ace VBA Developer in London
Some tips for your application 🫡
Highlight Your Data Projects:When applying for a temporary data science role at United States Digital Space LLC, make sure to showcase any relevant projects you've worked on. Whether it's a personal project, an academic undertaking, or contributions to an open-source initiative, detailing these experiences can really set you apart and demonstrate your practical skills.
Emphasise Your Analytical Skills:In your CV and cover letter, focus on the specific analytical skills that are key to data science. Mention any experience with statistical tools, programming languages like Python or R, and data visualisation software. Don't forget to include any certifications that may bolster your expertise!
Show Your Flexibility:Since this is a temporary role, it's important to convey your adaptability and willingness to learn. In your cover letter to United States Digital Space LLC, emphasise how quickly you can get up to speed with new tools or projects. Highlight any previous experiences where you've had to adjust to new environments or challenges.
Craft a Unique Data-Driven Cover Letter:Instead of the usual generic cover letter, spice it up with some data! Maybe you’ve improved a process by 20% in a past role or cleaned a dataset with over a million entries. Use these stats to your advantage to grab United States Digital Space LLC’s attention and show the tangible impact of your work.
How to prepare for a job interview at United States Digital Space LLC
✨Showcase Your Analytical Skills
For a data science gig, it's crucial to demonstrate your analytical abilities. Be ready to discuss previous projects and the methodologies you used. Think about how you can quantify your impact—did your analysis improve efficiency or save costs? These are the stories that will stick with interviewers at United States Digital Space LLC.
✨Brush Up on Technical Skills
You might face technical questions on tools relevant to data science, like Python, R, or SQL. Prepare to solve a problem live—perhaps they'll ask you to write a simple query or code snippet. It’s cool to talk about them, but we need to show we can do it in practice, especially in a temporary role where quick results matter.
✨Highlight Your Adaptability
Since this is a temporary position, emphasise your ability to learn quickly and adapt to new tools or workflows. Share examples of how you've thrived in fast-paced environments before, and how you can hit the ground running at United States Digital Space LLC.
✨Prepare a Portfolio of Your Work
Bring your portfolio to the table—showcase projects where you've leveraged data science techniques to solve problems. Whether it’s a GitHub repository or a set of case studies, having tangible examples of your work will help you stand out and show what you bring to the team at United States Digital Space LLC.
