Data Engineering Specialist

TN United Kingdom; Bristol; On-site; GBP 55,000 - 65,000; Full time

Job summary

An established industry player is seeking a Lead Data Engineer to oversee the development of high-quality ETL solutions while mentoring a dynamic team. This role requires a proven track record in ETL/ELT projects and the ability to lead complex initiatives. You'll collaborate with stakeholders, manage project requirements, and ensure the delivery of robust data solutions. The company values diversity and offers flexible working arrangements, competitive compensation, and a supportive environment for professional growth. If you're passionate about data engineering and ready to make an impact, this opportunity is for you.

Benefits

Generous pension scheme with up to 14% contribution

29 days holiday plus bank holidays

Discounts on Aviva products

Up to £1,200 in free Aviva shares

Flexible benefits including sustainability options

Paid volunteering days

Wellbeing support

Qualifications

• Proven track record in ETL/ELT/Data Warehouse projects with leadership experience.
• Experience mentoring Data Engineering teams in offshore/onshore environments.

Responsibilities

• Develop performant ETL solutions aligned with governance standards.
• Mentor developers and foster a collaborative team environment.

Skills

ETL/ELT/Data Warehouse projects

Mentoring Data Engineering teams

Informatica (PowerCenter, BDM, IDMC)

AWS (e.g., AWS Glue)

Database technologies (Postgres, Redshift, Oracle, Snowflake)

Scripting languages (Python, PySpark)

Tools

Informatica

AWS Glue

Postgres

Redshift

Oracle

Snowflake

Python

PySpark

Job description

Job Description: Lead Data Engineer

The Lead Data Engineer will play a critical role in maintaining development standards while delivering solutions within time and budget constraints. This position is suited for a highly organized and effective communicator who can engage with stakeholders at all levels. Responsibilities include understanding detailed technical requirements across multiple projects, providing informed technical input into solution designs, and proactively managing involvement within projects while supporting and guiding the development team.

Key Responsibilities:

1. Develop performant, secure ETL solutions on a project-by-project basis, aligned with governance standards.
2. Mentor developers of varying experience levels, fostering a collaborative team environment.
3. Lead solutions for complex problems, ensuring high standards through detailed code reviews.
4. Collaborate with team members at all levels to offer technical expertise and mentorship.
5. Support the development team in requirement clarification, solution design, sprint planning, code deployment, and resolving blockers.
6. Provide support for production applications, including defect analysis and fixes, serving as a technical mentor within the team.

Skills and Experience:

• Proven track record in ETL/ELT/Data Warehouse projects, with hands-on delivery and leadership experience.
• Experience mentoring Data Engineering teams and leading projects in offshore/onshore environments.
• Proficiency with ETL tools, especially Informatica (PowerCenter, BDM, IDMC), and cloud technologies like AWS (e.g., AWS Glue).
• Experience with database technologies (Postgres, Redshift, Oracle, Snowflake) and scripting languages such as Python and PySpark.
• Ability to translate technical and business information into practical solutions and challenge existing proposals constructively.

What You’ll Get:

We invest in our colleagues, offering competitive compensation and benefits, including:

• Salary up to £65,000, depending on skills and experience.
• Bonus opportunity of 10% based on performance.
• Generous pension scheme with up to 14% contribution from Aviva.
• 29 days holiday plus bank holidays, with options to buy or sell days.
• Discounts on Aviva products and retailer offers.
• Up to £1,200 in free Aviva shares annually and participation in share schemes.
• Supportive policies including parental and carer’s leave.
• Flexible benefits including sustainability options like cycle to work.
• Paid volunteering days and wellbeing support.

Inclusivity:

We are committed to diversity and inclusion, welcoming applications from all backgrounds. Flexible working arrangements are available, including part-time and job shares. We adapt locations, hours, and working patterns to meet the needs of our employees and customers.