Apprentice Data Engineer

ESG; Chorley; Hybrid; GBP 14,000 - 21,000; Full time

Job summary

ESG's Chorley office is seeking an Apprentice Data Engineer to join the Database Administrators team. You will develop and maintain data pipelines, assist with database monitoring, and support data quality initiatives while working on modern cloud technologies as part of a structured apprenticeship.

This full-time role offers a hybrid working pattern between the office and home, with initial in-office training.

Qualifications

• Genuine interest in data, technology, software engineering and database administration.
• Strong analytical and problem-solving skills.
• Excellent attention to detail and commitment to quality.
• Good written and verbal communication skills.
• The ability to work effectively both independently and as part of a team.
• Strong organisational and time management skills.
• A willingness to learn new technologies and technical concepts.
• GCSE Maths and English (or equivalent) in line with apprenticeship requirements.

Responsibilities

• Assist with the development, maintenance and monitoring of data pipelines and data integration processes.
• Support the extraction, transformation and loading (ETL) of data across systems and applications.
• Assist with maintaining and improving data quality, integrity and consistency.
• Support the monitoring and administration of MSSQL database and MySQL environments on premise and in cloud (AWS).
• Assist with database backups, restores, maintenance plans and routine health checks.
• Help investigate database performance issues and support optimisation activities.
• Support the management of database security, permissions and access controls.
• Monitor automated jobs, scheduled processes and data workflows, escalating issues where appropriate.
• Assist in troubleshooting data-related incidents and support the implementation of corrective actions.
• Create and maintain technical documentation relating to databases, data processes and system configurations.
• Work collaboratively with developers, engineers and business stakeholders to understand data requirements.
• Participate in testing activities to ensure data accuracy and system reliability.
• Support continuous improvement initiatives across data engineering and database administration functions.
• Complete apprenticeship coursework, training and development objectives within agreed timeframes.
• Develop knowledge of cloud technologies, software development practices and data management principles.

Skills

Analytical thinking

Problem solving

Attention to detail

Communication skills

Team player

Time management

Willingness to learn

Education

GCSE Maths

GCSE English

Tools

SQL basics

MySQL

MS SQL Server

Excel

Job description

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 Hybrid Cloud infrastructure, servicing both traditional and modern real-time, smart energy clients.

Job Description

Department: Development
Reports To: Lead Database Administrator
Work Location: Chorley - Hybrid
Hours of Work: 37.5
Position Type: Full-Time
Rate Type: Salary
Grade: 1

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, however during your initial training period the need to be in the office with other team members will be essential. Our UK office is based in Chorley, which is where you will be based.

While this position is full-time, we are open to discussing flexible working patterns that accommodate individual needs. If you require flexibility in your work schedule, please let us know during the application process, and we will do our best to accommodate your needs.

The Apprentice Data Engineer will join the Database Administrators team and work closely with the Lead Database Administrator to support ESG's data platforms, database environments and business-critical applications. This role provides an excellent opportunity to develop practical experience across data engineering and database administration while undertaking a structured apprenticeship programme.

The successful candidate will support the development and maintenance of data pipelines, assist with database monitoring and administration activities, contribute to data quality initiatives and gain exposure to modern cloud and software technologies. This role is ideal for someone passionate about technology, data and continuous learning who is looking to build a long-term career in software engineering and data management.

Position Responsibilities

• Assist with the development, maintenance and monitoring of data pipelines and data integration processes.
• Support the extraction, transformation and loading (ETL) of data across systems and applications.
• Assist with maintaining and improving data quality, integrity and consistency.
• Support the monitoring and administration of MSSQL database and MySQL environments on premise and in cloud (AWS).
• Assist with database backups, restores, maintenance plans and routine health checks.
• Help investigate database performance issues and support optimisation activities.
• Support the management of database security, permissions and access controls.
• Monitor automated jobs, scheduled processes and data workflows, escalating issues where appropriate.
• Assist in troubleshooting data-related incidents and support the implementation of corrective actions.
• Create and maintain technical documentation relating to databases, data processes and system configurations.
• Work collaboratively with developers, engineers and business stakeholders to understand data requirements.
• Participate in testing activities to ensure data accuracy and system reliability.
• Support continuous improvement initiatives across data engineering and database administration functions.
• Complete apprenticeship coursework, training and development objectives within agreed timeframes.
• Develop knowledge of cloud technologies, software development practices and data management principles.

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

• A genuine interest in data, technology, software engineering and database administration.
• Strong analytical and problem-solving skills.
• Excellent attention to detail and commitment to quality.
• Good written and verbal communication skills.
• The ability to work effectively both independently and as part of a team.
• Strong organisational and time management skills.
• A willingness to learn new technologies and technical concepts.
• GCSE Maths and English (or equivalent) in line with apprenticeship requirements.

Desirable

• Basic knowledge of SQL and relational databases.
• Exposure to programming or scripting languages through study, personal projects or work experience.
• Understanding data analysis, reporting, or business intelligence concepts.
• Familiarity with MSSQL Server / MySQL and cloud platforms such as AWS, Azure.
• Experience using Excel or other tools for data manipulation and analysis.
• Awareness of information security and data protection principles.

You Will Be

• Curious and enthusiastic about technology and data.
• Proactive in seeking learning and development opportunities.
• Able to take ownership of tasks and see them through to completion.
• Detail-oriented and committed to delivering high-quality work.
• Adaptable and comfortable working in a fast-paced environment.
• Collaborative and supportive when working with colleagues across the business.

ESGs Key Values

• 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

We welcome diverse people from all abilities, gender identities, ethnicities, ages, sexual orientations, life experiences and backgrounds to join us. ISO AWARENESS

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/ *