Energy Migration Senior Data Analyst (6-month contract)

Utility Warehouse; City Of London; On-site; GBP 50,000 - 70,000; Full time

Job summary

A leading energy provider is seeking an Energy Migration Senior Data Analyst to assist with migrating data from legacy systems to Gentrack Junifer. Responsibilities include analyzing data structures, writing SQL scripts, and collaborating with teams to ensure accurate data processes. Successful candidates will have experience in data migration and familiarity with Google BigQuery. This is a fixed-term contract role based in London.

Qualifications

• Experience in data migration projects (ideally energy platform migration).
• Experience working with Google BigQuery and Dataform environments.
• Proficient in writing complex SQL queries.

Responsibilities

• Analyse Gentrack Junifer data models to understand their data structures.
• Write complex SQL queries to extract, transform, and load large datasets.
• Validate and clean data to ensure accuracy and reliability.

Skills

Data migration projects

Gentrack Junifer application/data models

Building data warehouse data models

Proficient in SQL

Working with Google BigQuery

Collaborative teamwork

Tools

SQL

Google BigQuery

Dataform

Job description

The challenge

We are seeking an Energy Migration Senior Data Analyst to join our Home Services Energy Data Team to assist with the migration of our Energy Portfolio from UW legacy application to Gentrack Junifer. This is an exciting opportunity to contribute to a major data migration project in an award winning energy provider and UK FTSE 250 company.

Please note that this is a fixed term contract, initially for 6 months starting in October. We can consider fixed term or day rate contract - please indicate your preference in your application.

The migration work will have two parts:

a) Migration of portfolio from our UW legacy CRM system to Gentrack.

b) Build extract scripts to pull data from Gentrack Junifer database and load the data into UW BigQuery data warehouse to assist with management, regulatory, operational and other reports.

This role will be particularly focussed on (b) above and will include: interpreting Juniper data models, build ETL scripts, and populate energy data models in our UW BigQuery environment.

What you’ll do and how you will make an impact

This role would need:

• Experience in data migration projects (ideally energy platform migration).
• Experience in Gentrack Junifer application/ data models.
• Experience in building data warehouse data models.
• Proficient in SQL as both data extraction scripts and data loading scripts will be sql based.
• Experience working with Google BigQuery and Dataform environments.
• Experience in working collaboratively with a multitude of teams to meet the timelines and deliverables.

What you’ll do

• Analyse Gentrack Junifer data models to understand their data structures.
• Write complex SQL queries to extract, transform, and load large datasets using Google Dataform and other tools.
• Work collaboratively with the wider energy data team to re-model and populate data warehouse data models in UW BigQuery.
• Work closely with cross-functional teams to understand their data needs and provide relevant analyses.
• Validate and clean data to ensure accuracy and reliability for analyses.
• Maintain clear documentation for data processes, transformations, and best practices to ensure long-term maintainability and team-wide understanding.
• Support the preparation and creation of regulatory reports.
• Provide technical guidance to those less familiar with Junifer databases and Gentrack architecture, as well as sharing knowledge to empower others.

Apply here!

You’ve got this far… Hit apply - we can’t wait to hear from you! Worried you don’t hit all the criteria? We welcome applications from diverse and varied backgrounds so get your application in and let’s chat!

Martyna Zbyszewska will be your point of contact throughout the recruitment process.

Additional Information

Not sure you meet all the requirements? Let us decide! Research shows that women and members of other underrepresented groups tend not to apply for jobs if they think they may not meet every qualification, when in fact they often do.

We provide equal opportunities, a diverse and inclusive work environment, and fairness for everyone. You are welcome to apply no matter your age, disability, gender, marriage or civil partnership status, pregnancy and maternity status, race, religion or belief, or sexual orientation. Please don’t be afraid to ask about what we can do to support your needs. All requests will be carefully and fairly considered.

Please note, if you are successful and offered a role at UW, you will be subject to a background check. Where checks are unsatisfactory or incomplete and/or a failure to reveal information relating to convictions that you are required to identify as part of the background checks, could lead to withdrawal of an offer of employment.