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
* Develop, optimise, and maintain ETL processes and reporting data sources.
* Design and implement data warehouses and data lakes on AWS, ensuring scalability and efficiency.
* Work with stakeholders to translate business needs into technical solutions.
* Write efficient SQL queries and ensure performance optimisation.
* Collaborate with the team to ensure quality assurance, peer reviews, and best coding practices.
* Automate data workflows to improve efficiency and reduce costs.
* Conduct data cleansing and enhancement exercises.
* Provide clear documentation for data pipelines and processes.
Skills Knowledge and Expertise
* Minimum 2 years of experience working with large-scale relational databases (500,000+ customers).
* Strong understanding of relational database concepts (joins, sub-queries, indexing, normalisation).
* Proficiency in SQL (query writing, performance tuning, optimisation).
* Experience with Microsoft SQL Server technologies (SSRS, SSIS, SSAS).
* Hands-on experience with AWS services (EC2, Glue, Lambda, S3, Jupyter Notebooks).
* Ability to translate non-technical business requirements into technical specifications.
* Proven ability to produce clear, structured process documentation.
Benefits
* Annual Leave: 25 days + bank holidays
* Ability to buy and sell holiday days as well as the ability to bank days (tenure dependent)
* Flexible working options: we are operating a hybrid working model with 3 days a week from the office
* Pension: Hargreaves Lansdown – 6% matched contribution
* Employee share scheme
* Generous family friendly cover
* Private healthcare - Bupa
* Income protection
* Critical illness cover
* Life insurance cover
* Dental cover
* Optical cover
* Yulife app for access to employee wellbeing and discounts
* Perks at Work, cashback/discount shopping site
* Employee referral scheme
* Salary sacrifice program which includes cycle to work scheme, electric car scheme and season ticket loans
* Volunteering program
* Company events i.e. Christmas party, all-company event and other social/hosted events during the year (we have an active social committee!)
* Team socials
Our vision is to be a global leader in customer engagement, helping brands to create customers of the future. How do we achieve this? By making everyday spending more rewarding, we make every interaction count, delivering billions in rewards.