Energy Migration Senior Data Analyst (6-month contract)
1. Contract
2. Employment Status: Contractor
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 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 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:
3. Experience in data migration projects (ideally energy platform migration).
4. Experience in Gentrack Junifer application/ data models.
5. Experience in building data warehouse data models.
6. Proficient in SQL as both data extraction scripts and data loading scripts will be sql based.
7. Experience working with Google BigQuery and Dataform environments.
8. Experience in working collaboratively with a multitude of teams to meet the timelines and deliverables.
What you’ll do
9. Analyse Gentrack Junifer data models to understand their data structures.
10. Write complex SQL queries to extract, transform, and load large datasets using Google Dataform and other tools.
11. Work collaboratively with the wider energy data team to re-model and populate data warehouse data models in UW BigQuery.
12. Work closely with cross-functional teams to understand their data needs and provide relevant analyses.
13. Validate and clean data to ensure accuracy and reliability for analyses.
14. Maintain clear documentation for data processes, transformations, and best practices to ensure long-term maintainability and team-wide understanding.
15. Support the preparation and creation of regulatory reports.
16. 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.