At a Glance
- Tasks: Join a dynamic team to develop data solutions that directly impact customers and business growth.
- Company: Aviva Zero, a forward-thinking insurer with a start-up vibe and strong tech culture.
- Benefits: Competitive salary, bonus opportunities, generous pension scheme, and 29 days holiday.
- Other info: Enjoy high autonomy and excellent career growth in a collaborative setting.
- Why this job: Make a real difference in a greenfield environment using cutting-edge cloud technologies.
- Qualifications: Strong SQL, AWS, and Python skills; experience with data engineering is a plus.
The predicted salary is between 70000 - 70000 £ per year.
Overview
Location: Norwich, Bristol, Birmingham, Eastleigh, Manchester, York or Perth
Salary: Circa £70k
Aviva Zero is a personal lines insurer headquartered in London, with the ambition to be the best in the UK market. It combines the pace, focus, and test and learn mentality of a start-up with the expertise, and financial backing of Aviva. Aviva Zero has a great tech culture, with small teams weighted heavily towards senior engineers. Teams are agile, focused and have high degrees of autonomy to deliver world class solutions.
What you’ll do
You will join a Data Engineering team that ensures data consumers have access to insights to deliver the best service to customers and to grow the Aviva Zero business. Downstream consumers are highly skilled analysts, actuaries, and data scientists who use this data to directly impact the business and customers. You will play a key role in this process and immediately see the impact of your work.
Work projects from discovery to completion with ownership of the full development lifecycle, with specialist support/pairing where required. You will work closely with application teams to ingest data from our modern AWS stack into Snowflake. As a greenfield platform there is little to no digging into legacy systems. From there, we use dbt to transform raw data into our Data Vault model and build data products on top of this for internal and external data consumers.
Everything we do is guided by strong engineering principles, so you will deploy infrastructure as code (Terraform for Snowflake, CDK for AWS), write tests with dbt and Python, update CI/CD pipelines on GitHub Actions, and build out observability and monitoring with AWS CloudWatch.
Skills and experience we’re looking for
- Excellent SQL skills – comfortable handling complex data with clean, easy-to-read SQL; able to demonstrate this in a technical test.
- Great cloud skills – ability to deploy, run, and monitor workloads on AWS, and experience with a major cloud-based data warehouse (Snowflake); able to describe the full development lifecycle of a cloud-based project you’ve delivered.
- Good Python skills – familiarity with Pandas, PySpark, writing Airflow DAGs, etc.; able to demonstrate a basic understanding of Python in a technical test.
Our Tech Stack
The following tools are used day to day. You don’t need experience with all of them; the essential skills above are prioritized. If you are skilled in these, we want to hear about it.
- Snowflake
- AWS (Lambda, SNS, S3, ECS, CloudWatch, Kinesis, CDK)
- dbt
- Airflow (MWAA)
- Terraform
- CDK
- Scripting languages (primarily Python, sometimes Go)
What you’ll get for this role
Our purpose – with you today, for a better tomorrow – is a promise we make to our colleagues too. We have much to offer when it comes to being an Aviva colleague.
Starting salary circa £70,000 (depends on location, skills, experience, and qualifications)
Bonus opportunity – 10% of annual salary; actual amount depends on performance and Aviva’s.
Generous pension scheme – Aviva will contribute up to 14%, depending on what you contribute. 29 days holiday plus
Senior Data Engineer employer: Aviva
Contact Detail:
Aviva Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Data Engineer
✨Tip Number 1
Network like a pro! Reach out to current employees at Aviva Zero on LinkedIn or attend industry meetups. A friendly chat can give you insider info and might just get your foot in the door.
✨Tip Number 2
Show off your skills! Prepare for technical interviews by brushing up on SQL, AWS, and Python. Practice coding challenges and be ready to discuss your past projects in detail.
✨Tip Number 3
Tailor your approach! When you apply through our website, make sure your application highlights how your experience aligns with the job description. Use keywords from the listing to catch their eye.
✨Tip Number 4
Follow up after interviews! A quick thank-you email can leave a lasting impression. Mention something specific from your conversation to show you were engaged and interested.
We think you need these skills to ace Senior Data Engineer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Senior Data Engineer role. Highlight your SQL, AWS, and Python skills prominently, and don’t forget to mention any relevant projects you've worked on that align with our tech stack.
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to tell us why you're passionate about data engineering and how your experience can help Aviva Zero achieve its goals. Keep it concise but impactful!
Showcase Your Projects: If you’ve worked on any cool data projects, make sure to include them in your application. We love seeing real-world examples of your work, especially if they involve cloud technologies or data transformation.
Apply Through Our Website: We encourage you to apply through our website for the best chance of getting noticed. It’s super easy, and you’ll be able to keep track of your application status directly!
How to prepare for a job interview at Aviva
✨Master Your SQL Skills
Since excellent SQL skills are a must for this role, make sure you brush up on handling complex data. Practise writing clean and easy-to-read SQL queries, and be prepared to demonstrate your skills in a technical test during the interview.
✨Show Off Your Cloud Knowledge
Familiarise yourself with AWS and Snowflake, as these are key components of the job. Be ready to discuss a cloud-based project you've delivered, detailing the full development lifecycle. This will show your understanding and experience with cloud technologies.
✨Get Comfortable with Python
Brush up on your Python skills, especially with libraries like Pandas and PySpark. You might be asked to demonstrate your understanding of Python in a technical test, so practice writing scripts and working with data manipulation.
✨Understand the Tech Stack
While you don’t need to know every tool in their tech stack, having a good grasp of the essential ones is crucial. Familiarise yourself with dbt, Terraform, and Airflow, and be ready to discuss how you've used similar tools in past projects.