Overview
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.
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.
J-18808-Ljbffr