Data Analyst (Migration)

SmartestEnergy Business Limited; Greater London; On-site; GBP 45,000 - 60,000; Full time

Job summary

A UK-based energy company is seeking a data analyst to support a key Salesforce migration project. Responsibilities include data migration analysis, ensuring accurate data mapping, resolving data quality issues, and maintaining compliance with regulatory requirements. The successful candidate will have strong experience in data analytics and migration projects, particularly with Salesforce. Competitive perks include flexible remote working options and a commitment to diversity and inclusion.

Benefits

Flexible working options

Commitment to diversity and inclusion

Qualifications

• Experience in data analytics or design role.
• Experience working on migration projects.
• Familiarity with Salesforce.

Responsibilities

• Deliver data migration analysis and design.
• Ensure data mapping is accurate and cleansed.
• Support reconciliation and post-migration testing.

Skills

Data analytics experience

Migration project experience

Familiarity with Salesforce

Data mapping creation

SQL coding skills

Experience with Microsoft databases

Analytical tools experience

Job description

This role plays a key part in delivering robust data design across projects, aligned to the organisation’s data strategy, with a strong focus on supporting a major Salesforce migration as part of a wider transformation programme. You will provide hands‑on data migration analysis and design, ensuring data is accurately mapped, cleansed, documented, and fit for purpose to enable successful implementation and long‑term value from new platforms.

Working closely with the Data Architect, Data Migration Lead, Business Analysts, and technical and business SMEs, you will analyse how data is used across systems, assess the impact of change, and support data integration and migration design. The role also involves profiling data, identifying and resolving data quality issues, maintaining data catalogue content, and supporting reconciliation and post‑migration testing. Throughout, you will ensure compliance with regulatory requirements such as GDPR, while maintaining the confidentiality and integrity of sensitive information.

Please note this is fixed term until 31/07/26.

What skills/experience do I need to be successful?

• Experience in data analytics or data design role
• Experience in working on a migration project
• Familiarity with Salesforce
• Creation of data mappings and interpretation of business rules to apply transformational logic to the data
• Skilled in writing code in SQL to analyse data and prepare code for testing
• Experience with Microsoft databases and analytical tools, including Fabric or Synapse Analytic

What sets us apart?

Global Impact: With offices in the UK, US, and Australia, and plans for further expansion, you'll be part of a dynamic, globally‑minded team, with opportunities to explore new markets and make a difference on a global scale.

Flexible Working: Embrace the freedom to work from anywhere in the world for up to 30 days a year. We prioritize work‑life balance, recognizing that your well‑being matters. Find out more here.

Commitment to Diversity and Inclusion: We celebrate our diverse culture and value individuals irrespective of background, disability, religion, gender identity, sexuality, or ethnicity. Join a team where diversity is not just welcomed but celebrated as a key driver of growth and innovation.

What happens next?

Once we receive your application, it will be reviewed by a human – no bots here! The average process typically takes around 2-3 weeks, with 2 stages of video interviews using Teams. However, this can vary depending on the role. We may invite you for a face‑to‑face meeting or require only 1 video interview. If you have any questions or need support, our Recruitment Team is here to assist you.

Ready to join us on our journey to digitise, decarbonise, and localise the future of energy? Apply now.

We're committed to making the application process easy and comfortable. Let us know how we can help you with any reasonable adjustments that can be tailored to your needs. At the bottom of each of our adverts you can find one of our recruitment teams' contact details. Please reach out so we can discuss with you further.

Please use the button below to start our application process.

If you're a small‑medium business, you're in the right place.

Am I a small‑medium business?

• Less than 300,000 kWh annual volume
• Less than £50k annual spend

If you're a generator or a commercial and industrial (C&I) business you should visit our SmartestEnergy Limited website.