Energy Migration Senior Data Analyst (6-month contract)

Company Description

Hi! We’re UW. We’re on a mission to take the headache out of utilities by providing them all in one place. One bill for energy, broadband, mobile and insurance and a whole lot of savings! We’re aiming to double in size as we help more people to stop wasting time and money. Big ambitions, to be delivered by people like you. Got your attention? Read on...

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 June. We can consider fixed term or day rate contract - please indicate your preference in your application.

The migration work will have two parts:

• Migration of portfolio from our UW legacy CRM system to Gentrack.
• 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 the second part and will include:

• Interpreting Junifer 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:

• 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 making the most of opportunities to share knowledge and empower others.

So why pick UW? We’ve got big ambitions so there’s going to be plenty of challenges. There are also a lot of benefits:

• An industry benchmarked salary.
• Discount on our services and you get our coveted Cashback Card for free.
• Family-friendly policies, designed to help you and your family thrive.
• Discounted private health insurance, access to an Employee Assistance line and a free Virtual GP.
• Belonging groups that help UW shape an even more inclusive future.
• A commitment to helping you develop and grow in your role.

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.

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.