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 July/ August. 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.
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.