Data Analyst (Migration)

SmartestEnergy; Greater London; On-site; GBP 40,000 - 60,000; Full time

Job summary

A leading energy organization in Greater London is looking for a data analyst to play a key role in a Salesforce migration project. You'll be involved in data design, migration analysis, and ensuring compliance with regulatory requirements like GDPR. Essential skills include experience in data analytics, SQL coding, and familiarity with Microsoft analytical tools. The organization promotes flexible working and values diversity in its workforce.

Benefits

Global work opportunities

Flexible working

Commitment to diversity and inclusion

Qualifications

• Experience in a data analytics or data design role.
• Experience in working on a migration project.
• Capability to create data mappings and interpret business rules.

Responsibilities

• Deliver robust data design for projects aligned with the data strategy.
• Ensure accurate data mapping, cleansing, and documentation.
• Profile data and resolve data quality issues.

Skills

Data analytics experience

Migration project experience

Familiarity with Salesforce

SQL coding skills

Experience with Microsoft databases

Analytical tools knowledge

Tools

SQL

Fabric

Synapse Analytics

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.

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 prioritise work‑life balance, recognising that your well‑being matters.
• 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.

Herge