At a Glance
- Tasks: Join a dynamic Data Engineering team to deliver impactful insights and solutions.
- Company: Aviva Zero, a forward-thinking personal lines insurer with a start-up vibe.
- Benefits: Competitive salary, bonus opportunities, generous holiday, and flexible working options.
- Other info: Inclusive culture with excellent career growth and wellbeing support.
- Why this job: Make a real difference in a greenfield environment using cutting-edge tech.
- Qualifications: Strong SQL, AWS, and Python skills; experience with cloud-based data projects.
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 bank holidays, with option to buy or sell up to 5 days
- Aviva-funded Private Medical Benefit to provide access to expert support when needed
- Up to 40% discount on Aviva products and other retailer discounts
- Up to £1,200 of free Aviva shares per year through the Matching Share Plan and Save As You Earn scheme
- Supportive policies including parental and carer's leave
- Flexible benefits to suit you, including sustainability options such as cycle to work
- Opportunity to participate in Aviva Communities and use paid volunteering days
- Wellbeing support and tools
We're inclusive and welcome applicants from all backgrounds and experiences. We encourage you to apply even if you don't tick every box. We consider all forms of flexible working, including part-time and job shares. We flex locations, hours and working patterns to suit our customers, business, and you. Most of our people are smart working – spending at least 50% of their time in our offices each week.
To find out more about working at Aviva, please consider applying online. If you require an alternative method of applying or have questions about the vacancy, please contact the recruiter.
Senior Data Engineer in Belsize Park employer: Aviva
Contact Detail:
Aviva Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Data Engineer in Belsize Park
✨Tip Number 1
Network like a pro! Reach out to current employees at Aviva Zero on LinkedIn or other platforms. Ask them about their experiences and any tips they might have for the interview process. It’s all about making connections!
✨Tip Number 2
Prepare for technical tests by brushing up on your SQL and Python skills. Use online resources or practice platforms to simulate the kind of challenges you might face. We want you to feel confident when it comes to showcasing your abilities!
✨Tip Number 3
Showcase your projects! If you've worked on relevant data engineering projects, be ready to discuss them in detail. Highlight your role, the technologies used, and the impact of your work. This is your chance to shine!
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you’re serious about joining the team at Aviva Zero. Let’s get you that job!
We think you need these skills to ace Senior Data Engineer in Belsize Park
Some tips for your application 🫡
Show Off Your SQL Skills: Make sure to highlight your SQL expertise in your application. We want to see how you handle complex data and write clean, easy-to-read queries. If you can demonstrate this in a technical test, even better!
Talk About Your Cloud Experience: When writing your application, don’t forget to mention your experience with AWS and cloud-based data warehouses like Snowflake. Describe a project where you managed the full development lifecycle – we love hearing about real-world examples!
Demonstrate Your Python Knowledge: We’re keen on your Python skills, so be sure to include any relevant experience with libraries like Pandas or PySpark. If you've worked with Airflow DAGs, let us know – it’ll make your application stand out!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you don’t miss out on any important updates. Plus, we love seeing applications come through our platform!
How to prepare for a job interview at Aviva
✨Master Your SQL Skills
Make sure you're comfortable with complex SQL queries, as you'll likely face a technical test during the interview. Brush up on writing clean, easy-to-read SQL and be ready to explain your thought process behind your solutions.
✨Show Off Your Cloud Knowledge
Familiarise yourself with AWS and Snowflake, as these are crucial for the role. Be prepared to discuss your experience with deploying and monitoring workloads in the cloud, and share specific examples of projects you've worked on that involved the full development lifecycle.
✨Demonstrate Your Python Proficiency
Since Python is a key part of the tech stack, ensure you can showcase your skills with libraries like Pandas and PySpark. You might be asked to solve a problem using Python, so practice coding challenges that involve data manipulation and workflow automation.
✨Understand the Company Culture
Aviva Zero values agility and autonomy, so research their tech culture and be ready to discuss how you thrive in such environments. Share examples of how you've contributed to team success in previous roles, highlighting your ability to work collaboratively and take ownership of projects.