Data Analyst (Migration)

SmartestEnergy; Greater London; Hybrid; GBP 45,000 - 60,000; Full time

Job summary

A leading energy company is seeking a Data Migration Analyst to support a major Salesforce migration. The role focuses on providing hands-on data analysis and ensuring data quality compliance with regulations. Candidates should have experience in data design, migration projects, and familiarity with Salesforce, along with strong SQL skills. Join us and be part of a global team dedicated to transforming the energy sector through digitization and decarbonization.

Benefits

Flexibility to work remotely for 30 days annually

Commitment to diversity and inclusion

Opportunities for global impact

Qualifications

• Experience in data analytics or data design role.
• Experience in working on a migration project.
• Familiarity with Salesforce platform.
• Creating data mappings and applying transformational logic.
• Skilled in writing SQL code for data analysis.
• Experience with Microsoft databases and analytical tools.

Responsibilities

• Provide data migration analysis and design.
• Ensure data quality and compliance with GDPR.
• Maintain data catalogue and support reconciliation testing.
• Collaborate with Data Architect and SMEs on data integration.

Skills

Data analytics or data design experience

Experience in migration projects

Familiarity with Salesforce

Creation of data mappings

SQL coding skills

Experience with Microsoft databases

Tools

Fabric

Synapse Analytic

Job description

Overview

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 localize the future of energy? Apply now.

Note: We are 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 generator or a commercial and industrial (C&I) business, you're in the right place.

If you're a micro or smaller business you should visit our SmartestEnergy Business website.