At a Glance
- Tasks: Execute data loads for client migrations and support various ETL processes.
- Company: Innovative software & services company in the utility sector based in Chorley.
- Benefits: Hybrid working, competitive salary, and opportunities for professional growth.
- Why this job: Join a dynamic team and make a real impact on energy transformation projects.
- Qualifications: 2+ years in ETL roles, strong SQL skills, and experience in data migration.
- Other info: Diverse and inclusive workplace with a focus on collaboration and continuous improvement.
The predicted salary is between 36000 - 60000 £ per year.
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
- 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 ESG’s 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
Benefits: Grade 3 - Contractor until end of 2026 (Base to mid in min / max salary)
ETL Developer - Chorley employer: Energy Services Group, LLC.
Contact Detail:
Energy Services Group, LLC. Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land ETL Developer - Chorley
✨Tip Number 1
Network like a pro! Reach out to folks in the industry, attend meetups, or join online forums. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your ETL projects and any relevant work you've done. This gives potential employers a tangible look at what you can bring to the table.
✨Tip Number 3
Prepare for interviews by practising common questions related to ETL processes and data migration. We recommend doing mock interviews with friends or using online platforms to boost your confidence.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you're genuinely interested in joining our team and contributing to our mission.
We think you need these skills to ace ETL Developer - Chorley
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the ETL Developer role. Highlight your SQL skills and any relevant experience in data migration projects, especially in the energy sector. We want to see how your background aligns with what we do!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about this role and how you embody our values of excellence, passion, integrity, and collaboration. Let us know why you’re the perfect fit for our team.
Showcase Your Projects: If you've worked on any notable ETL or migration projects, be sure to mention them! We love seeing real examples of your work and how you've tackled challenges in the past. It gives us insight into your problem-solving skills.
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way to ensure your application gets to us quickly and efficiently. Plus, you’ll find all the details you need about the role and our company there!
How to prepare for a job interview at Energy Services Group, LLC.
✨Know Your ETL Stuff
Make sure you brush up on your ETL concepts and SQL skills before the interview. Be ready to discuss your previous migration projects in detail, especially any challenges you faced and how you overcame them. This will show that you’re not just familiar with the theory but have practical experience too.
✨Understand the Company and Its Clients
Do a bit of homework on the company and its clients in the utility sector. Knowing their services and how they operate can help you tailor your answers to show that you understand their needs and how you can contribute to their mission of delivering smooth and valuable services.
✨Prepare for Scenario Questions
Expect scenario-based questions where you might need to demonstrate your problem-solving skills. Think of examples from your past work where you had to troubleshoot migration failures or implement data quality checks. This will highlight your analytical skills and attention to detail.
✨Show Your Collaborative Spirit
Since the role involves working closely with internal colleagues and clients, be prepared to discuss how you’ve collaborated in past projects. Share examples that showcase your ability to work as part of a team and how you value communication and collaboration in achieving project goals.