Apprentice Data Engineer

United Living Group

Warrington, WA5 3LP

Closes in 14 days (Sunday 5 January)

Posted on 10 December 2024


Summary

You will join our systems development team, working alongside Project, Finance, PMO and other departments. This apprenticeship is perfect for someone looking for their first step in System Development. You will have the support of the Development team as well as experienced Telecoms and IT professionals to enable you to develop and adapt knowledge.

Annual wage
£23,000 a year

Minimum wage rates (opens in new tab)

All apprentices have an annual salary review.

Training course
Data engineer (level 5)
Hours
Monday - Friday, shifts to be confirmed

40 hours a week

Possible start date

Monday 3 February

Duration

2 years

Positions available

1

Work

As an apprentice, you’ll work at a company and get hands-on experience. You’ll gain new skills and work alongside experienced staff.

What you’ll do at work

Your main responsibilities will include, but are not limited to;

  • Data Collection and Analysis: Learn to develop your skills in gathering, analysing, and interpreting complex data from multiple sources, including Salesforce (Sitetracker), PowerBI, and SQL.
  • Software Implementation: Assist the ULC Developer in implementing new software systems, upgrades and APIs within timescales and SLAs.
  • Reporting: Develop reports on data efficiencies, helping to drive informed decision-making.
  • Data Integrity: Ensure data accuracy, completeness, and compliance with ULC and GDPR data management standards, at times working closely with the project teams to minimise dates in the past and discrepancies in data.
  • Visualisation and Insights: Use data visualisation tools (e.g., PowerBI, Sitetracker and Presentations) to present findings in a clear, impactful way for Development team.
  • Continuous Improvement: Develop skills in order to eventually recommend and implement improvements to current data processes, tools, and reporting methods to enhance efficiency and data quality.

Where you’ll work

Lingley Mere

Warrington

WA5 3LP

Training

An apprenticeship includes regular training with a college or other training organisation. At least 20% of your working hours will be spent training or studying.

College or training organisation

TECHNICAL PROFESSIONALS LIMITED

Your training course

Data engineer (level 5)

Equal to higher national diploma (HND)

Course contents
  • Collate, evaluate and refine user requirements to design the data product.
  • Collate, evaluate and refine business requirements including cost, resourcing, and accessibility to design the data product.
  • Design a data product to serve multiple needs and with scalability, efficiency, and security in mind.
  • Automate data pipelines such as batch, real-time, on demand and other processes using programming languages and data integration platforms with graphical user interfaces.
  • Produce and maintain technical documentation explaining the data product, that meets organisational, technical and non-technical user requirements, retaining critical information.
  • Systematically clean, validate, and describe data at all stages of extract, transform, load (ETL).
  • Work with different types of data stores, such as SQL, NoSQL, and distributed file system.
  • Identify and troubleshoot issues with data processing pipelines.
  • Query and manipulate data using tools and programming such as SQL and Python. Manage database access, and implement automated validation checks.
  • Communicate downtime and issues with database access to stakeholders to mitigate the operational impact of unforeseen issues.
  • Evaluate opportunities to extract value from existing data products through further development, considering costs, environmental impact and potential operational benefits.
  • Maintain a working knowledge of data use cases within organisations.
  • Use data systems securely to meet requirements and in line with organisational procedures and legislation.
  • Identify new tools and technologies and recommend potential opportunities for use in own department or organisation.
  • Optimise data ingestion processes by making use of appropriate data ingestion frameworks such as batch, streaming and on-demand.
  • Develop algorithms and processes to extract structured data from unstructured sources.
  • Apply and advocate for software development best practice when working with other data professionals throughout the business. Contribute to standards and ways of working that support software development principles.
  • Develop simple forecasts and monitoring tools to anticipate or respond immediately to outages and incidents.
  • Identify and escalate risks with suggested mitigation/resolutions as appropriate.
  • Investigate and respond to incidents, identifying the root cause and resolution with internal and external stakeholders.
  • Identify and remediate technical debt, assess for updates and obsolescence as part of continuous improvement.
  • Develop, maintain collaborative relationships using adaptive business methodology with stakeholders such as, business users, data scientists, data analysts and business intelligence teams.
  • Present, communicate, and disseminate messages about the data product, tailoring the message and medium to the needs of the audience.
  • Evaluate the strengths and weaknesses of prototype data products and how these integrate within an organisation’s overarching data infrastructure.
  • Assess and identify gaps in existing tools and technologies in respect of implementing changes required.
  • Identify data quality metrics and track them to ensure the quality, accuracy and reliability of the data product.
  • Selects and apply sustainable solutions to contribute to net zero and environmental strategies across the various stages of product and service delivery.
  • Horizon scanning to identify new technologies that offer increased performance of data products.
  • Implement personal strategies to keep up to date with new technology and ways of working.
  • Collate, evaluate and refine user requirements to design the data product.
  • Collate, evaluate and refine business requirements including cost, resourcing, and accessibility to design the data product.
  • Design a data product to serve multiple needs and with scalability, efficiency, and security in mind.
  • Automate data pipelines such as batch, real-time, on demand and other processes using programming languages and data integration platforms with graphical user interfaces.
  • Produce and maintain technical documentation explaining the data product, that meets organisational, technical and non-technical user requirements, retaining critical information.
  • Systematically clean, validate, and describe data at all stages of extract, transform, load (ETL).
  • Work with different types of data stores, such as SQL, NoSQL, and distributed file system.
  • Identify and troubleshoot issues with data processing pipelines.
  • Query and manipulate data using tools and programming such as SQL and Python. Manage database access, and implement automated validation checks.
  • Communicate downtime and issues with database access to stakeholders to mitigate the operational impact of unforeseen issues.
  • Evaluate opportunities to extract value from existing data products through further development, considering costs, environmental impact and potential operational benefits.
  • Maintain a working knowledge of data use cases within organisations.
  • Use data systems securely to meet requirements and in line with organisational procedures and legislation.
  • Identify new tools and technologies and recommend potential opportunities for use in own department or organisation.
  • Optimise data ingestion processes by making use of appropriate data ingestion frameworks such as batch, streaming and on-demand.
  • Develop algorithms and processes to extract structured data from unstructured sources.
  • Apply and advocate for software development best practice when working with other data professionals throughout the business. Contribute to standards and ways of working that support software development principles.
  • Develop simple forecasts and monitoring tools to anticipate or respond immediately to outages and incidents.
  • Identify and escalate risks with suggested mitigation/resolutions as appropriate.
  • Investigate and respond to incidents, identifying the root cause and resolution with internal and external stakeholders.
  • Identify and remediate technical debt, assess for updates and obsolescence as part of continuous improvement.
  • Develop, maintain collaborative relationships using adaptive business methodology with stakeholders such as, business users, data scientists, data analysts and business intelligence teams.
  • Present, communicate, and disseminate messages about the data product, tailoring the message and medium to the needs of the audience.
  • Evaluate the strengths and weaknesses of prototype data products and how these integrate within an organisation’s overarching data infrastructure.
  • Assess and identify gaps in existing tools and technologies in respect of implementing changes required.
  • Identify data quality metrics and track them to ensure the quality, accuracy and reliability of the data product.
  • Selects and apply sustainable solutions to contribute to net zero and environmental strategies across the various stages of product and service delivery.
  • Horizon scanning to identify new technologies that offer increased performance of data products.
  • Implement personal strategies to keep up to date with new technology and ways of working.

Your training plan

As an Apprentice with Connected, you’ll be given a real job from day one where you will gain hands-on industry experience, and the knowledge required to achieve a nationally recognised qualification. You’ll be inspired and stretched professionally, but fully supported by an expert network of colleagues, as you work to build the foundations for a career within United Living, and the construction industry.

To help you settle into your role, we’ll provide you with a buddy from our apprentice population. They will have some great advice as they were in exactly the same situation as you not so long ago, and you’ll also receive a dedicated mentor who will help guide you throughout your apprenticeship programme to help you achieve professional success.

As part of your Apprenticeship, you will be enrolled onto the Data Engineer Level 5 qualification with one of our training partners. You will be fully supported through a variety of methods such as virtual workshops, learning materials, and one-to-one support from your tutor or coach. They will also meet regularly with you and your line manager to ensure you are progressing through your programme.

More training information

This apprenticeship is delivered by Learn Tech and is a blend of weekly live virtual classrooms and regular one-to-one mentoring sessions. 

The duration of the programme is expected to take approximately 20 months plus 4 months for end point assessment.

Requirements

Essential qualifications

GCSE in:

  • incl English and Maths (grade 5 x grade 9-4/A*-C)

Other in:

  • Computer Science, Maths or Physics (grade minimum pass)

Let the company know about other relevant qualifications and industry experience you have. They can adjust the apprenticeship to reflect what you already know.

Skills

  • Communication skills
  • IT skills
  • Attention to detail
  • Number skills
  • Analytical skills
  • Logical
  • Initiative
  • data
  • programming languages

About this company

United Living is a leading infrastructure, construction, and property services company in the UK, comprised of four complementary businesses. We help our customers and the communities they serve benefit from resilient infrastructure, affordable homes, and improved living spaces that are fit for the future. We invest in our people and firmly believe that our workforce is our most valuable asset. A driving force for success and the core to achieving our vision of creating a connected and sustainable future, our team is the heart of our organisation. Building a diverse, inclusive, and equal working environment in which everyone is welcomed and encouraged to be themselves, is a commitment we are dedicated to. We believe that having a diverse workforce not only sets us up for success, but it allows for greater opportunities for innovation, adaptability, and wide-ranging capabilities. We empower our people, and our communities, to champion diversity and change every day. We are a fast-paced, diverse, and hugely ambitious business. We welcome challengers, innovators and people who embrace change to establish yourself in a creative environment that champions freedom of expression and supports you in your personal and professional development – because together, we achieve more.

https://unitedliving.co.uk/ (opens in new tab)

Company benefits

We offer a range of benefits such as: Leisure & shopping discounts, Virtual GP & Dentist, mental health support & counselling, fitness and nutrition, & financial & legal advice. Health Cash Plan, Holiday Purchase Scheme, Payroll Giving, Pension

Disability Confident

Disability Confident

A fair proportion of interviews for this apprenticeship will be offered to applicants with a disability or long-term health condition. This includes non-visible disabilities and conditions.

You can choose to be considered for an interview under the Disability Confident scheme. You’ll need to meet the essential requirements to be considered for an interview.

After this apprenticeship

Upon successful completion of this programmme, you can continue your development and progression with United Living.

Ask a question

The contact for this apprenticeship is:

United Living Group

Rebecca Harrison

earlycareers@unitedliving.co.uk

The reference code for this apprenticeship is VAC1000291285.

Apply now

Closes in 14 days (Sunday 5 January)

When you apply, you’ll be asked to sign in with a GOV.UK One Login. You can create one at the same time as applying for this apprenticeship.

After signing in, you’ll apply for this apprenticeship on the company's website.

Company’s application instructions

If you are ready to be part of our expanding team and contribute to our success, please visit our website and click the I’m interested button and submit an application.