Data Engineer

Data Engineer

Department: Technology

Employment Type: Permanent - Full Time

Location: Belfast

Description

We are looking for an enthusiastic and experienced Data Engineer with 3-5 years of experience to join our team. You will play a key role in designing, developing, and maintaining data pipelines, reporting solutions, and scalable data architectures in a cloud environment.

Working closely with business stakeholders, Data Engineers, and the Product Owner, you will be responsible for migrating ETL processes and data warehouses to the cloud. This includes developing pipelines for reporting, data monetisation, and large-scale data processing solutions.

If you are passionate about data engineering, SQL, Python, and cloud-based data solutions, we'd love to hear from you!

Key Responsibilities

1. Develop, optimise, and maintain ETL processes and reporting data sources.
2. Design and implement data warehouses and data lakes on AWS, ensuring scalability and efficiency.
3. Work with stakeholders to translate business needs into technical solutions.
4. Write efficient SQL queries and ensure performance optimisation.
5. Collaborate with the team to ensure quality assurance, peer reviews, and best coding practices.
6. Automate data workflows to improve efficiency and reduce costs.
7. Conduct data cleansing and enhancement exercises.
8. Provide clear documentation for data pipelines and processes.

Skills Knowledge and Expertise

1. Minimum 2 years of experience working with large-scale relational databases (500,000+ customers).
2. Strong understanding of relational database concepts (joins, sub-queries, indexing, normalisation).
3. Proficiency in SQL (query writing, performance tuning, optimisation).
4. Experience with Microsoft SQL Server technologies (SSRS, SSIS, SSAS).
5. Hands-on experience with AWS services (EC2, Glue, Lambda, S3, Jupyter Notebooks).
6. Ability to translate non-technical business requirements into technical specifications.
7. Proven ability to produce clear, structured process documentation.

Benefits

1. Annual Leave: 25 days + bank holidays
2. Ability to buy and sell holiday days as well as the ability to bank days (tenure dependent)
3. Flexible working options: we are operating a hybrid working model with 3 days a week from the office
4. Pension: Hargreaves Lansdown - 6% matched contribution
5. Employee share scheme
6. Generous family friendly cover
7. Private healthcare - Bupa
8. Income protection
9. Critical illness cover
10. Life insurance cover
11. Dental cover
12. Optical cover
13. Yulife app for access to employee wellbeing and discounts
14. Perks at Work, cashback/discount shopping site
15. Employee referral scheme
16. Salary sacrifice program which includes cycle to work scheme, electric car scheme and season ticket loans
17. Volunteering program
18. Company events i.e. Christmas party, all-company event and other social/hosted events during the year (we have an active social committee!)
19. Team socials