Energy Migration Senior Data Engineer (6-month contract)
Contract Employment Status: Contractor
Company Description
Hello, we're UW
We’re a bunch of great people working together, solving problems and having fun. Together, we strive to find solutions to help the great people around us get on with the things that really matter in life.
How? It’s simple, we take the headache out of essential home services by providing them all in one place – energy, broadband, mobile, and even insurance. That’s one provider, one account, one bill, and lots of savings.
We’re a truly unique FTSE 250 company with a business model that has real social impact at the heart of it. Being a part of the UW community you’ll join a working environment like no other - one where everyone matters - be it our customers, our partners or you, our people.
The challenge
We are seeking an experienced Data Engineer to assist with the migration of our Energy Portfolio data from a 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 August/ September. We can consider fixed term or day rate contract - please indicate your preference in your application.
Who you’ll be working with
You’ll be working with your fellow Data Engineers, Software Engineers, Data Analysts, the Data Leadership team, Energy Industry Experts, Product and Programme Managers, and our third party platform provider. Most Data Engineers are fully remote and convene in our Farringdon office when it makes sense to co-locate and have some face to face time.
We deliver progress. What you’ll do and how you will make an impact.
What you’ll be doing
Designing and building scalable, reliable and robust data pipelines to acquire, ingest, and process data from multiple sources.
Data modelling - bringing a structure to raw data that is aligned with business requirements and objectives.
Maintaining a data product mindset - what needs to be improved next?
Helping to create clarity by reducing unnecessary complexity.
Partner with stakeholders to understand their needs and build impactful analytics solutions.
Evaluating and proposing multiple approaches to a problem, identifying the wider business implications of each.
Curating existing data.
Providing support to Data Analysts.
Contributing to cross-functional problem-solving sessions.
What we are looking for
Essential
Experience of data warehousing and building ELT pipelines.
Experience working on successful, complex migration projects.
Experience writing high quality and maintainable code resulting in solid and reliable software.
Strong SQL and data modelling skills.
Strong analytical and problem solving skills.
Comfort with design, creation and management of complex datasets and data systems.
Ability to continually optimise and improve data pipelines.
Strong interpersonal skills including team working, knowledge sharing and helping to create a positive culture.
Ability to organise own workload in coordination with the team and stakeholders.
Experience of cloud data warehouses such as BigQuery or Snowflake.
Experience of cloud data warehouse transformation tools such as dbt or Dataform.
Beneficial
UK Energy industry experience
Exposure to Gentrack Junifer.
Working knowledge of Data Vault 2.0 modelling principles.
Ability to write code in Python or other languages commonly used to process data.
Infrastructure as Code (. Terraform) and GitOps methods.
Experience working with containerised platforms . Kubernetes.
Experience of working on a cloud-native data ecosystem, ideally GCP.
