Data Engineer Specialist Salary: £55,000 - £65,000 Locations: Norwich/ Bristol/ Sheffield/ York Are you someone who would like to be part of our high-profileData Engineering Team?We are seekinganenthusiastic Data EngineerSpecialist to be part of our innovative team which help shape the future of the life insurance business at Aviva.You'llwork and guide the work of a team of data engineers using languages of SQL and some Python in market leading tools like Snowflake anddbt(as well as SQL Server) to transform raw data from multiple systems into business focussed information. Information that can be used for a range of purposes from Data Science, Informational Dashboards and Reporting through to Self-service queries by analysts. A bit about the job: We work across all business lines, delivering data analytics solutions forprotection, healthcare, wealth,cooand retirement. We are looking to finding candidates who can: Lead the design and delivery of scalable data products, translating complex business problems into robust data solutions and owning core data pipelines and platform reliability. Work closely with data scientists to provide high-quality, well-modelled data that enables advanced analytics and data science use cases. Communicate effectively with non-technical stakeholders, clearly explaining data solutions, progress, risks, and issues across project and BAU work. Ensure strong data governance and engineering standards, producing clear high- and low-level designs, maintaining documentation, and ensuring data is used appropriately and securely. Provide technical leadership and mentorship to data engineers through coaching, code and design reviews, and collaboration across engineering, and wider business teams to embed best practices. Skills and experience we're looking for Proven experience designing, developing, andoptimizingdata solutions in Snowflake and ability to build andmaintainmodular, testable, and well-documented transformations usingdbt. Hands-on experience creating robust data pipelines and data products for analytics. Familiarity with tools likeDataIkuor Informatica isadvantageous. Knowledge of CI/CD processes and in particular tools like ADO (Azure Dev Ops) would bevery beneficialas this will be key to our delivery and deployment processes. Understanding of data modelling techniques particularly those suited to analytical data(Data Vault andDimensional Modelling). Familiarity with healthcare or insurance data domains is a plus, asyou'llbe working on critical data products that supporthealthcareinitiatives. 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. Salary £55,000 - £65,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 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 around 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 interview every disabled applicant who meets the minimum criteria for the job. Once you've applied, please send us an email stating that you have a disclosed disability, and we'll interview you. We'd love it if you could submit your application online. If you require an alternative method of applying, please give Harjot Kaur a call on 07353138456 or send an email to harjot.kaur@aviva.com