Business Data Analyst (Salesforce & Excel/VBA) in Cambridge
Business Data Analyst (Salesforce & Excel/VBA)

Business Data Analyst (Salesforce & Excel/VBA) in Cambridge

Cambridge Temporary 36000 - 60000 £ / year (est.) Home office (partial)
R

At a Glance

  • Tasks: Support data quality and systems improvement initiatives with Salesforce and Excel.
  • Company: Join a dynamic B2B SaaS organisation focused on innovation.
  • Benefits: Remote work, competitive pay, and a chance to enhance your skills.
  • Why this job: Make a real impact on data accuracy and commercial processes.
  • Qualifications: Advanced Excel skills and knowledge of Salesforce data structures required.
  • Other info: Initial 2-month contract with potential for growth in a collaborative environment.

The predicted salary is between 36000 - 60000 £ per year.

Robert Half have partnered with a B2B SaaS organisation 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 understanding of SaaS 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.

Business Data Analyst (Salesforce & Excel/VBA) in Cambridge employer: Robert Half

At Robert Half, we pride ourselves on being an excellent employer, offering a dynamic work culture that fosters collaboration and innovation. As a Business Data Analyst, you will have the opportunity to work remotely while contributing to impactful data initiatives within a leading B2B SaaS organisation, with access to professional development resources and a commitment to diversity and inclusion. Join us to enhance your skills in a supportive environment that values your contributions and encourages growth.
R

Contact Detail:

Robert Half Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Business Data Analyst (Salesforce & Excel/VBA) in Cambridge

✨Tip Number 1

Network like a pro! Reach out to your connections in the SaaS industry and let them know you're on the lookout for a Business Data Analyst role. You never know who might have the inside scoop on job openings or can refer you directly.

✨Tip Number 2

Get your hands dirty with some practical projects! If you can, create a mini-project using Excel and Salesforce data. This will not only sharpen your skills but also give you something tangible to discuss during interviews.

✨Tip Number 3

Prepare for those interviews by brushing up on common questions related to data cleansing and Salesforce. We recommend practising your answers out loud to build confidence and ensure you can articulate your experience clearly.

✨Tip Number 4

Don't forget to apply through our website! It’s super easy and ensures your application gets the attention it deserves. Plus, we love seeing candidates who are proactive about their job search!

We think you need these skills to ace Business Data Analyst (Salesforce & Excel/VBA) in Cambridge

Advanced Microsoft Excel
Data Manipulation
Data Cleansing
Salesforce Data Schema Understanding
Salesforce Data Exports/Imports
VBA
Data Validation
Data Mapping
SaaS Commercial Metrics Understanding
Pricebook Development
Stakeholder Collaboration
Data Integrity Assurance
Large-scale Data Conversion
Complex Formulas Implementation

Some tips for your application 🫡

Tailor Your CV: Make sure your CV highlights your advanced Excel skills and any experience with Salesforce. We want to see how your background aligns with the role, so don’t be shy about showcasing relevant projects or achievements!

Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you’re the perfect fit for this Business Data Analyst role. We love seeing enthusiasm and a clear understanding of SaaS metrics, so let that passion come through.

Showcase Your Data Skills: In your application, mention specific examples of data cleansing, restructuring, or validation you've done in the past. We’re looking for hands-on experience, so the more detail you provide, the better!

Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for this exciting opportunity. Don’t miss out!

How to prepare for a job interview at Robert Half

✨Know Your Data Inside Out

Before the interview, make sure you brush up on your knowledge of Salesforce data structures and commercial metrics. Be ready to discuss how you've handled data cleansing and validation in the past, as this will show your potential employer that you understand the core responsibilities of the role.

✨Excel Skills on Display

Since advanced Excel skills are a must for this position, prepare to demonstrate your proficiency. Bring examples of complex formulas or VBA scripts you've created. If possible, practice explaining your thought process behind developing Excel tools, as this will highlight your analytical skills.

✨Showcase Your Collaboration Skills

This role involves working closely with internal stakeholders, so be prepared to share examples of how you've successfully collaborated in previous roles. Discuss any challenges you faced and how you overcame them, as this will illustrate your ability to work effectively in a team environment.

✨Ask Insightful Questions

At the end of the interview, don’t forget to ask questions! Inquire about the company's approach to data quality and how they measure success in their SaaS initiatives. This shows your genuine interest in the role and helps you assess if the company is the right fit for you.

Business Data Analyst (Salesforce & Excel/VBA) in Cambridge
Robert Half
Location: Cambridge

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

R
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>