Business Data Analyst Salesforce & Excel/VBA

Robert Half
Cambridge
4 days ago
Create job alert

Robert Half have partnered with a B2B SaaS organisation is seeking a Business Data Analyst for an initial 2-month contract to support a critical data and systems improvement initiative.

The primary objective of this role is to support data quality, commercial data structures, and system readiness, with a particular focus on Salesforce data migration and Excel-based pricebook development.

This role will involve hands-on data cleansing, restructuring, and validation, alongside the development of robust Excel tools to support SaaS commercial processes and pricing structures.

Role:

You will play a key role in supporting commercial and operational data initiatives, working closely with internal stakeholders to ensure data accuracy, consistency, and alignment across systems. The role requires strong Excel and data-handling capability, combined with a solid understanding of SaaS commercial metrics and Salesforce data structures.

Key responsibilities include:

  • Cleansing, mapping, restructuring, and preparing large datasets ahead of Salesforce import
  • Validating data against Salesforce schema, including Accounts, Contacts, Opportunities, Products, and Price Books
  • Supporting product and pricebook data alignment to ensure consistency across systems
  • Developing and refining a structured Excel-based pricebook
  • Implementing advanced Excel logic, automation, and calculations using complex formulas and VBA
  • Supporting large-scale data manipulation, conversion, and validation activities
  • Ensuring data integrity and accuracy across commercial datasets
  • Working collaboratively with stakeholders to deliver project milestones

Experience:

Core Skills (Essential):

  • Advanced Microsoft Excel expertise, including complex formulas and data modelling
  • Proven experience in data manipulation, cleansing, and large-scale data conversion
  • Working knowledge of Salesforce, including:
    • Understanding of Salesforce data schema and objects (Accounts, Contacts, Opportunities, Products, Price Books, etc.)
    • Experience with Salesforce data exports/imports, deduplication, validation, and field mapping
  • Strong understandingofSaaS commercial metrics, including:
    • ACV / ARR
    • Contract terms and renewal structures
    • Product and pricebook structures

Nice to Have:

  • Experience with Atlassian Jira administration (custom fields, workflows, bulk updates)
  • Previous experience working within SaaS or subscription-based business models

Contract:

  • Initial 8-week contract - Inside IR35
  • Remote working, with occasional on-site visits to Cambridge
  • Full-time availability required
  • Start: ASAP

Robert Half Ltd acts as an employment business for temporary positions and an employment agency for permanent positions. Robert Half is committed to diversity, equity and inclusion. Suitable candidates with equivalent qualifications and more or less experience can apply. Rates of pay and salary ranges are dependent upon your experience, qualifications and training. If you wish to apply, please read our Privacy Notice describing how we may process, disclose and store your personal data: gb/en/privacy-notice.

Related Jobs

View all jobs

Data Analyst (Salesforce & Excel)

Data Analyst (Salesforce & Excel)

Data Analyst

Marketing Data Analyst

Data Engineer

Business Data Analyst

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

How Many Machine Learning Tools Do You Need to Know to Get a Machine Learning Job?

Machine learning is one of the most exciting and rapidly growing areas of tech. But for job seekers it can also feel like a maze of tools, frameworks and platforms. One job advert wants TensorFlow and Keras. Another mentions PyTorch, scikit-learn and Spark. A third lists Mlflow, Docker, Kubernetes and more. With so many names out there, it’s easy to fall into the trap of thinking you must learn everything just to be competitive. Here’s the honest truth most machine learning hiring managers won’t say out loud: 👉 They don’t hire you because you know every tool. They hire you because you can solve real problems with the tools you know. Tools are important — no doubt — but context, judgement and outcomes matter far more. So how many machine learning tools do you actually need to know to get a job? For most job seekers, the real number is far smaller than you think — and more logically grouped. This guide breaks down exactly what employers expect, which tools are core, which are role-specific, and how to structure your learning for real career results.

What Hiring Managers Look for First in Machine Learning Job Applications (UK Guide)

Whether you’re applying for machine learning engineer, applied scientist, research scientist, ML Ops or data scientist roles, hiring managers scan applications quickly — often making decisions before they’ve read beyond the top third of your CV. In the competitive UK market, it’s not enough to list skills. You must send clear signals of relevance, delivery, impact, reasoning and readiness for production — and do it within the first few lines of your CV or portfolio. This guide walks you through exactly what hiring managers look for first in machine learning applications, how they evaluate CVs and portfolios, and what you can do to improve your chances of getting shortlisted at every stage — from your CV and LinkedIn profile to your cover letter and project portfolio.

MLOps Jobs in the UK: The Complete Career Guide for Machine Learning Professionals

Machine learning has moved from experimentation to production at scale. As a result, MLOps jobs have become some of the most in-demand and best-paid roles in the UK tech market. For job seekers with experience in machine learning, data science, software engineering or cloud infrastructure, MLOps represents a powerful career pivot or progression. This guide is designed to help you understand what MLOps roles involve, which skills employers are hiring for, how to transition into MLOps, salary expectations in the UK, and how to land your next role using specialist platforms like MachineLearningJobs.co.uk.