ETL Developer

ETL Developer

Job Description

Department: Delivery Services

Reports To: Migration Lead

Work Location: Chorley - Hybrid           

Hours of Work: 37.5

Position Type: Full-Time, Fixed-Term Contract (until end of 2026)                         

Rate Type: Salary

Grade: 3

SUMMARY

We are an innovative and market leading software & services company based in Chorley serving clients in the utility sector ranging from new entrants to large existing suppliers.  We deliver sophisticated software solutions and managed services in a Private Cloud infrastructure, servicing both traditional and modern real-time, smart energy clients.

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)

EXPERIENCE

• 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

You will be:

• 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 
  • ISO Responsibilities  
  • ISO Staff Awareness

  *For more information on how we process your information please see our privacy notice which can be found on our website https://esgglobal.com/privacy-policy/  *