Energy Migration Senior Data Engineer

Summary

Join UW, a FTSE 250 company, as a Data Engineer for a 6-month fixed-term contract (or day rate) to contribute to a major data migration project. You will work with a team of engineers, analysts, and industry experts to migrate energy portfolio data from a legacy application to Gentrack Junifer. The role involves designing and building data pipelines, data modeling, maintaining data products, and collaborating with stakeholders. This is a remote-friendly position with opportunities for in-person collaboration at the Farringdon office. UW offers a diverse and inclusive work environment and encourages applications from all backgrounds.

Requirements

• 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

Responsibilities

• 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

Preferred Qualifications

• 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 (e.g. Terraform) and GitOps methods
• Experience working with containerised platforms e.g. Kubernetes
• Experience of working on a cloud-native data ecosystem, ideally GCP