Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Transform HR data using MS Excel and support digital data strategies.
- Company: Join a renowned financial organisation with a strong reputation in the industry.
- Benefits: Enjoy flexible working options and a dynamic work environment.
- Why this job: Be part of a crucial data transformation project that impacts the entire organisation.
- Qualifications: Expertise in MS Excel and data mapping is essential; HR software experience is a plus.
- Other info: Ideal for adaptable team players with excellent communication skills.
The predicted salary is between 28800 - 43200 £ per year.
Your new company: Working for a renowned financial organisation.
Your new role: Working as a data transformation analyst/consultant within the HR department of this renowned financial organisation. You will be working on a regional HR data mapping transformation program for SAP SuccessFactors. Transforming legacy data from a variety of sources in MS Excel and accurately populating data load templates for SAP SuccessFactors. You will also interface with business partners to understand data and transformation requirements, supporting in defining the digital data transformation strategy for the business within SuccessFactors.
What you'll need to succeed:
- Technical background with a strong focus on data analytics.
- Expertise in MS Excel - ability to write formulas, macros, and VLookUps.
- Great expertise with data mapping from multiple different sources.
- Experience working on Data Transformation projects.
- Experience with data within HR software (desirable).
- Knowledge of SAP/SuccessFactors (desirable).
- Adaptable and able to work within a fast-paced environment.
- Team player with fantastic communication skills, both verbally and written.
- Personable and confident - ability to hold meetings as a subject expert on data with internal/external clientele.
What you'll get in return: Flexible working options available.
If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now.
Data Analyst/ Consultant (Data Mapping/ Adv - MS Excel) employer: Hays
Contact Detail:
Hays Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst/ Consultant (Data Mapping/ Adv - MS Excel)
✨Tip Number 1
Familiarise yourself with SAP SuccessFactors and its data mapping processes. Understanding how this software works will not only help you in interviews but also demonstrate your genuine interest in the role.
✨Tip Number 2
Brush up on your MS Excel skills, especially in writing complex formulas, macros, and VLookUps. Consider creating a portfolio of examples showcasing your expertise in data transformation projects to share during discussions.
✨Tip Number 3
Network with professionals in the HR and data analytics fields. Attend relevant webinars or local meetups to connect with potential colleagues or mentors who can provide insights into the company culture and expectations.
✨Tip Number 4
Prepare for behavioural interview questions by reflecting on your past experiences in data transformation projects. Be ready to discuss specific challenges you faced and how you successfully navigated them, highlighting your adaptability and teamwork.
We think you need these skills to ace Data Analyst/ Consultant (Data Mapping/ Adv - MS Excel)
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with data analytics, particularly your expertise in MS Excel. Include specific examples of how you've used formulas, macros, and VLookUps in previous roles.
Craft a Strong Cover Letter: In your cover letter, emphasise your experience with data transformation projects and your ability to work with HR software. Mention any relevant experience with SAP SuccessFactors and how you can contribute to the company's digital data transformation strategy.
Showcase Communication Skills: Since the role requires interfacing with business partners, highlight your communication skills in both your CV and cover letter. Provide examples of how you've effectively communicated complex data concepts to non-technical stakeholders.
Proofread Your Application: Before submitting your application, carefully proofread your CV and cover letter for any spelling or grammatical errors. A polished application reflects your attention to detail, which is crucial for a data analyst role.
How to prepare for a job interview at Hays
✨Showcase Your Excel Skills
Since the role requires expert knowledge of MS Excel, be prepared to discuss your experience with formulas, macros, and VLookUps. You might even want to bring examples of your work or be ready for practical tests during the interview.
✨Understand Data Mapping
Familiarise yourself with data mapping concepts and be ready to explain how you've successfully transformed data from various sources in previous roles. Highlight any specific projects where you’ve implemented data mapping strategies.
✨Communicate Clearly
As a data consultant, you'll need to interface with business partners. Practice explaining complex data concepts in simple terms. Good communication skills are essential, so demonstrate your ability to convey information effectively during the interview.
✨Prepare for HR Software Questions
While experience with HR software is desirable, it’s important to show your understanding of how data transformation impacts HR processes. Brush up on SAP SuccessFactors and be ready to discuss how you can contribute to the digital data transformation strategy.
