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
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
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.