Senior Data Engineer

Senior Data Engineer

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.

A bit about the job:
You will be joining a Data Engineering team that is responsible for ensuring our data consumers have access to the insights they need to ensure we are delivering the best service to our customers, and continuing to grow the Aviva Zero business.

Our downstream consumers don't want simple dashboards. They are highly skilled analysts, actuaries, and data scientists that are using this data to directly impact the business and our customers. You will play a key role in this process, and immediately be able to see the impact of your work.

We work projects all the way through from initial discovery to completion. You won't be handing work off to large teams of architects, analysts, testers, infrastructure, etc. You will take ownership for the full development lifecycle (with specialist support/pairing etc where required).

You will be working closing with our application teams to ingest data from our modern AWS stack into Snowflake. Being a greenfield platform there's little to no digging into horrible legacy systems. From there, we use dbt to transform raw data into our Data Vault model. We then build data products on top of this to serve our diverse array of internal and external data consumers.

Everything we do is with good engineering principles first and foremost, so you will be deploying all infrastructure as code (Terraform for Snowflake, CDK for AWS), writing tests with dbt and Python, updating CI/CD pipelines on GitHub Actions, building out observability and monitoring with AWS CloudWatch etc.

Skills and experience we’re looking for

• Excellent SQL skills - you are comfortable handling complex data with clean, easy to read SQL and are able to demonstrate this in a technical test.
• Great cloud skills - you know how to deploy, run, and monitor workloads with a major cloud platforms (we use AWS), and are skilled in one of the major cloud based data warehouses (we use Snowflake). You should be able to tell us about the full development lifecycle of a cloud based project you've delivered.  
• Good Python skills - you're familiar with at least some of Pandas, PySpark, writing Airflow DAGs etc. You're able to demonstrate a basic understanding of Python in a technical test.

Our Tech Stack:
The following is a list of the tools we use day to day. We don't expect you to have experience with them all, if you have the essential skills above, you'll be able to pick them up! But if you're skilled in these, we want to hear about it.

• Snowflake
• AWS (mostly Lambda, SNS, S3, ECS, CloudWatch, Kinesis, CDK)
• dbt
• Airflow (we use MWAA)
• Terraform
• CDK
• Scripting languages (mostly 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.  And one of the ways we live up to that promise is by investing in you.  We have so much to offer when it comes to being an Aviva colleague.  

• Starting salary circa £70,000 (depending on location, skills, experience, and qualifications) 
• Bonus opportunity – 10% of annual salary Actual amount depends on your performance and Aviva’s. 
• Generous pension scheme - Aviva will contribute up to 14%, depending on what you put in. 
• 29 days holiday plus bank holidays, and you can choose to buy or sell up to 5 days 
• Aviva-funded Private Medical Benefit to help you get expert support when you need it 
• Make your money go further - Up to 40% discount on Aviva products, and other retailer discounts 
• Up to £1,200 of free Aviva shares per year through our Matching Share Plan and share in the success of Aviva with our Save As You Earn scheme 
• Brilliantly supportive policies including parental and carer’s leave  
• Flexible benefits to suit you, including sustainability options such as cycle to work  
• Make a difference, be part of our Aviva Communities and use your 3 paid volunteering days to help others 
• We take your wellbeing seriously with lots of support and tools 

Take a look to learn more.  Put a salary into this calculator to see what your total Aviva Reward could be. 

Aviva is for everyone: 

We’re inclusive and welcome everyone – we want applications from all backgrounds and experiences. Excited but not sure you tick every box? Even if you don’t, we would still encourage you to apply. We also 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 every week - combining the benefits of flexibility, with time together with colleagues. 

To find out more about working at Aviva take a look here 

We'd love it if you could submit your application online. If you require an alternative method of applying, or if you have any queries in relation to the vacancy, please give Chloe Nettley a call on 07795207964 or send an email to chloe.nettley@aviva.com