Enable job alerts via email!

Energy Migration Senior Data Analyst

Utility Warehouse

London

On-site

GBP 45,000 - 65,000

Full time

Yesterday
Be an early applicant

Boost your interview chances

Create a job specific, tailored resume for higher success rate.

Job summary

Utility Warehouse is seeking an Energy Migration Senior Data Analyst to support a major data migration project. This role involves working with Gentrack Junifer and Google BigQuery to enhance data processes and support regulatory reporting. Candidates should have strong SQL skills and experience in data migration, particularly in the energy sector.

Benefits

Discount on services
Family-friendly policies
Discounted private health insurance
Access to Employee Assistance line
Free Virtual GP
Commitment to development and growth

Qualifications

  • Experience in data migration projects, ideally in energy.
  • Proficient in SQL for data extraction and loading.
  • Experience working with Google BigQuery and Dataform.

Responsibilities

  • Analyze Gentrack Junifer data models and write SQL queries.
  • Collaborate with teams to populate data warehouse models.
  • Validate and clean data for accuracy.

Skills

Data migration
SQL
Collaboration
Data validation

Tools

Google BigQuery
Gentrack Junifer
Dataform

Job description

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:

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 Junifer data models, build ETL scripts, and populate energy data models in our UW BigQuery environment.

We deliver progress. 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 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. We’ll share it during your first conversation.

  • 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.

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.

Get your free, confidential resume review.
or drag and drop a PDF, DOC, DOCX, ODT, or PAGES file up to 5MB.

Similar jobs

Data Analyst (Freelance)

Connect Management

Greater London

Remote

GBP 30,000 - 70,000

7 days ago
Be an early applicant

Lead Data Scientist

Adamas Knight

Greater London

Remote

GBP 35,000 - 46,000

6 days ago
Be an early applicant

Data Scientist - London

Descartes Underwriting

London

Remote

GBP 50,000 - 80,000

4 days ago
Be an early applicant

Senior Data Analyst (Operations) - Enterprise Product

Wise

London

Remote

GBP 60,000 - 75,000

7 days ago
Be an early applicant

Freelance Material Science Expert - AI Tutor (Talent pool)

Mindrift

London

Remote

GBP 40,000 - 60,000

6 days ago
Be an early applicant

Senior Data Analyst

Bionic

London

On-site

GBP 50,000 - 75,000

6 days ago
Be an early applicant

Senior Data Analyst

National Grid

London

On-site

GBP 64,000 - 80,000

6 days ago
Be an early applicant

Data Engineer - Leading Energy Company - London

TN United Kingdom

London

Remote

GBP 45,000 - 75,000

27 days ago

Senior Data Governance Analyst

Ofgem

London

Hybrid

GBP 45,000 - 65,000

Today
Be an early applicant