ETL Developer
Role details
Job location
Tech stack
Job description
We operate a Hybrid working policy so you will be able to flex between working in the office and your home location to carry out this role, during your initial training period there will likely be increased working in the office alongside colleagues. Our Delivery Services Team Vision is for our customers to feel that they are in safe hands and have experienced a smooth delivery, with value for money, and for our business to feel that we deliver change in a controlled, well communicated, and collaborative manner.
Our mission is to have a Delivery Services Team where: Everyone is equally valued and understands their contribution, We all feel we're driving forward the best versions of ourselves, We feel equipped to do our jobs and understand why it's important, We feel empowered to do our best, We utilise best practices with our tools and our processes, We put the customer at the heart of what we do, We understand the value of continuous improvement and are always questioning 'could we do better?' The ETL Developer is responsible for the execution of migration loads for client Dry Runs, Dress Rehearsals & Go Lives as part of system implementation or transformation projects. ESG projects vary in size and complexity according to the solution being implemented, ranging from small projects and work requests to multi-year industry change programmes. While the role operates within core working hours, as this is client-facing, there will be requirements to provide support during evenings or weekends for specific delivery projects or events. POSITION RESPONSIBILITIES
The ETL Developer is responsible for: Executing data loads for Client migration Dry Runs, Dress Rehearsals & System Go Lives. Creation, conversion and maintenance of scripts of migration complexity Input into maintain documentation for ETL processes and data mappings Supporting multiple inflight client migration projects Supporting the Monitoring & troubleshooting of migration failures Implementing data quality checks & validation rules Collaborating with internal colleagues (Product & Migration) Infrequently supporting ad hoc client migration discussions (where required)
Requirements
Do you have experience in SQL?, Minimum 2 Years' experience in ETL Developer / Migrations roles Previous experience in the Energy Industry is highly desirable About You We welcome diverse people from all abilities, gender identities, ethnicities, ages, sexual orientations, life experiences and backgrounds to join us.
You must have: Strong SQL skills (MySQL, MS SQL or equivalent) Proven experience in ETL data migration projects, preferably in enterprise environments. Strong understanding of data structures, relational databases, and ETL concepts. Excellent analytical skills and attention to detail
Desirable: Knowledge and experience of the UK Retail Energy sector (Elec & Gas) Experience of continuous improvement in migration projects, An experienced ETL Developer used to support migration projects at different sizes and scales Hard working and dedicated Tenacious & self-motivated Well organized & thorough Committed to a professional attitude at all times Knowledgeable in SQL server Hands on
Able to demonstrate ESGs key values of: Excellence: be accountable to deliver our best Passion: show how much we care each day Integrity: do the right thing when no one is looking Collaboration: work together to succeed together ISO AWARENESS Follow IMS Policies Reporting of Incidents