L5 Data Engineer Apprentice - Lancashire Fire & Rescue - Preston PR2 3LH - £23.5k

Lancashire Combined Fire Authority

Lancashire, PR2 3LH

Closes in 7 days (Thursday 26 September at 11:59pm)

Posted on 28 August 2024

Print

Contents

Summary

The Apprentice Data Engineer will provide support for the organisation’s data, data transformation & data engineering needs. This includes development, maintenance and support of Extract, Transform & Load solutions and pipelines across multiple technology stacks, including traditional database, cloud architecture and business intelligence platforms.

Annual wage
£23,500 a year

Minimum wage rates (opens in new tab)

Training course
Data engineer (level 5)
Hours
Monday - Friday, 9am - 5pm

36 hours a week

Possible start date

Monday 14 October

Duration

1 Year 11 Months

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

In collaboration with the department’s Developer Database Administrator, the role will also provide development, administration, support and health monitoring of the organisation’s database and data asset estate, responding to incidents and Service Desk tickets where appropriate. Liaising with key stakeholders to analyse requirements, research scope and options and present recommendations for solutions is also a key requirement.

Key responsibilities:

  • Build and optimise automated data systems and pipelines considering data quality, description, cataloguing, data cleaning, validation, technical documentation and requirements
  • Integrate, support and manage data using standalone, distributed and cloud-based platforms to ensure efficient, sustainable and effective provision of data storage solutions
  • Support the identification and evaluation of opportunities for data acquisition and data enrichment
  • Select and use appropriate tools to process data in any format, such as structured and unstructured data and in any mode of delivery, such as streaming or batching. Adapt to legacy systems as required
  • Ensure resilience is built into data products against business continuity and disaster recovery plans, and document change management to limit service outages. Support and respond to incidents through the application of technology and service management best practice including configuration, change and incident management
  • Analyse requirements, research scope and options and present recommendations for solutions to stakeholders
  • Support the implementation of prototype or proof-of-concept data products within a production environment
  • Maintain data solutions as continually evolving products, to service the organisation, user or client requirements. Collaborate with technical support teams and stakeholders from implementation to management
  • Work within compliance and contribute towards data governance, organisational policies, standards, and guidelines for data engineering
  • Monitor the data system to meet service requirements to enable solutions such as data analysis, dashboards, data products, pipelines, and storage solutions
  • Keep up to date with engineering developments to advance own skills and knowledge
  • Demonstrate a commitment to personal development and actively participate in the appraisal process
  • To be aware of the LFRS Safeguarding Procedures and to make referrals as appropriate to the role
  • Promote a positive image of the Service in dealing with all other organisations and members of the public
  • To promote the principles of equality and diversity and comply with Lancashire Fire and Rescue Service Equality, Diversity, and Inclusion Policy at all times
  • To observe all rules governing health and safety and use safety equipment where it is provided
  • To support LFRS in its commitment to prevent pollution and minimise its impact on the environment
  • The post holder may be requested to undertake the duties of higher graded staff subject to consultation. In addition, other duties at the same responsibility level may be interchanged with/added to this list at any time

Special Requirements of the Post:

  • The post holder will be required to complete any college associated activity to support the completion of the apprenticeship
  • The ability to attend project meetings around the County of Lancashire
  • The postholder will study towards the achievement of the Level 5 Data Engineer apprenticeship

Experience:

  • Some experience in producing written content e.g. report
  • Experience of working within a data/digital environment

Where you’ll work

Fire Station

Garstang Road

Preston

Lancashire

PR2 3LH

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.

    • Your training plan

    During this apprenticeship, you will follow a fully supported training programme with LearnTech, delivered through combined weekly remote classroom-based training, workplace assessment/training and online learning working towards completing the Level 5 Data Engineer standard.

    The training covers the following core occupational duties:  https://www.instituteforapprenticeships.org/apprenticeship-standards/data-engineer-v1-0

    Requirements

    Essential qualifications

    GCSE in:

    • English (grade C/4)
    • Maths (grade C/4)

    Desirable qualifications

    A Level in:

    • IT/Computer Science (grade C)
    • Maths (grade C)

    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
    • Organisation skills
    • Problem solving skills
    • Analytical skills
    • Logical
    • Team working
    • Initiative
    • Microsoft Office Skills
    • Methodical approach
    • Self-motivated
    • Exceptional numerical skills

    Other requirements

    You must meet the following eligibility criteria to apply for the role: - Have been a UK/EEA resident for the last 3 years - Hold valid residency status - Have the right to work in the UK

    About this company

    The intended result of all our efforts is to make Lancashire safer. This is what we are here to achieve. We seek to do this by delivering prevention, protection, and emergency response services; using our trusted position in the community to influence the wider safety of people and working in partnership with other organisations where we have shared objectives. The Service values are underpinned by the national Core Code of Ethics for Fire and Rescue Services in England. The Core Code sets out five ethical principles, which provide a basis for promoting good behaviour and challenging inappropriate behaviour: Putting our communities first: we put the interest of the public, the community and service users first. Integrity: we act with integrity including being open, honest and consistent in everything we do. Dignity and respect: making decisions objectively based on evidence, without discrimination or bias. Leadership: we are all positive role models, always demonstrating flexibility and resilient leadership. We are all accountable for everything we do and challenge all behaviour that falls short of the highest standards. Equality, diversity, and inclusion: We continually recognise and promote the value of equality, diversity, and inclusion both within the Fire and Rescue Service’s and the wider communities in which we serve. We stand against all forms of discrimination, create equal opportunities, promote equality, foster good relations, and celebrate difference.

    https://www.lancsfirerescue.org.uk/ (opens in new tab)

    Company benefits

    Free Car Parking Facilities are available at Service Headquarters. Local Government Pension Scheme. Lancashire Fire and Rescue Service operates a flexi-time scheme.

    After this apprenticeship

    There may the opportunity to apply for full-time positions after the completion of the apprenticeship.

    Ask a question

    The contact for this apprenticeship is:

    TECHNICAL PROFESSIONALS LIMITED

    Georgia Dunn

    g.dunn@learn-tech.com

    The reference code for this apprenticeship is VAC1000273266.

    Apply now

    Closes in 7 days (Thursday 26 September at 11:59pm)

    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.