Job Title - Data Engineer Welcome to Hastings Direct We're a digital insurance provider with ambitious plans to become The Best and Biggest in the UK market. Over the past few years, we've made significant investments in our data and tech capabilities, particularly within our CIO function. Our CIO team is at the forefront of driving innovation and ensuring our technology infrastructure supports our ambitious goals. We've nurtured our 4Cs culture, fostering collaboration, creativity, and continuous improvement. We're proud of the journey we're on as a company and know that our continued success will rely on the contribution of our talented colleagues. The CIO team plays a crucial role in this journey, working on cutting-edge projects that enhance our digital presence and improve customer engagement. We provide insurance to nearly four million customers, but we know there's even bigger opportunity out there. The fact you're now reading this job advert means we've tempted you to find out more about lifeatHD - we really hope you like what you see, and you'll join us to share in the success of the exciting chapter that lies ahead. We understand some people may not apply for jobs unless they feel they tick every box. If you are excited about joining us and think you have some of what we are looking for, even if you're not 100% sure, we would love to hear from you. Our CIO team is always looking for passionate individuals who are eager to make a difference and contribute to our success. Job Details As part of the Data Engineering team, provides a 'build' capability that delivers new and improved insight and information flows to the rest of the business. Supervises the delivery of significant data developments, often with some complexity, and ensures team members collaborate effectively to meet agreed requirements and timescales. Works with business users, data scientists and data architects to understand and clarify requirements for new or changed data structures, data flows or automated processes Uses own detailed knowledge (and relationships with other experts) to facilitate business users, data scientists and data architects in identifying appropriate data sources within data environments for specified analysis and reporting purposes Builds complex, large data structures, data flows and processes from supplied specifications, using agreed standards and tools, to achieve a well-engineered result; resolves challenging data design briefs with innovative solutions Models data and creates appropriate database schemas designed with organisation-wide architectural and design guidelines in mind; maximises flexibility of data designs to simplify future development Conducts tests of processes and resulting data sets, corrects errors, and re-tests to achieve error-free results. Skills we would love you to have Experience with Snowflake (SQL scripting DDL and DML, task orchestration, integration management) Experience with Azure Data Factory and Azure Dev Ops (ETL orchestration, Git integration, CI/CD) Experience working in an Agile environment, utilising methodologies such as Scrum/Kanban/BDD/TDD. Enthusiasm for accuracy with a proven track record of solving complex data problems Unfortunately we are unable to progress with candidates that require sponsorship at this time. What we offer Join us and you'll find a different way of doing things. We call it the 4Cs. We focus on getting it right for our colleagues, customers, company, and community. As one of our colleagues, you'll be helping to drive our growth, so in return, we'll give you all the support, training and development you need. Not to mention plenty of recognition and rewards, and the scope to voice your ideas and put them into practice. Reward Salary - Attractive salary based on experience (pay reviews also completed each year) Flexible Working - We champion a flexible and hybrid working approach so please speak to your recruiter to discuss in more detail, including days in the office and at home. Competitive Bonus Scheme - All colleagues are eligible for our annual 4Cs performance bonus, which is usually paid in March. The scheme is based on Hastings' performance against our business goals and your own personal performance. Physical Wellbeing - We like to help our colleagues take a proactive approach in keeping themselves well, that's why we fund our colleagues to be able to claim against everyday health care through our healthcare cash plan. Financial Wellbeing - As well as providing you with 4x your salary with our life assurance cover and income protection at no extra cost, pension contribution match up to 10%, we are proud to provide you with an AWARD WINNING package which includes - discounts and cashback at everyday retailers and on our own products, fee free independent mortgage advice, and free access to financial wellbeing support. Mental Wellbeing Programme - At Hastings Direct we understand that mental health cannot not be scheduled, that's why we have a range of support to help you keep yourself well. We have the thrive mental health app, our colleague assistance programme available 24/7, our own in-house mental health first aiders, support groups and a dedicated team to make sure we are covering your needs There's more - 25 days annual leave bank holidays, with the option to buy or sell one of your contracted weeks, access to private healthcare, dental plans, discounted health assessments, cycle to work and tech schemes, discounted and free onsite facilities, social events throughout the year and much more. Most of our benefits and wellbeing resources are available to colleagues from their first day whilst some optional benefits, which involve committing to a 12-month payment schedule, are available as soon as you have completed your probationary period. Our 4Cs principles are simple: we believe by creating the right culture for our colleagues and giving them the right tools to do their job, we'll deliver good outcomes for every customer, helping us to grow the company profitably and sustainably and allowing us to invest in the communities we serve. We deliver good outcomes for our customers every time by providing great products at the right price with our simple and straightforward service. We treat customers like we want to be treated - fairly, respectfully and with their best interests at heart. Hastings Group is an equal opportunities employer which means we treat people fairly. We welcome applications from all suitably skilled persons regardless of their gender, age, race, disability, ethnic background, religion/belief, sexual orientation, gender reassignment or marital/family status. Please also note that we have a thorough referencing process, which includes credit and criminal record checks.