Introduction At RSA, we believe insurance is about people, not things. We provide our inspiring colleagues the support and opportunity to grow together, shape the future, and win as a team. We are going through a transformation journey, providing our people with opportunity to be integral to improving our service and delivering better products to brokers and customers. We are a proud member of the Intact family, we feel part of something bigger, with a presence in North America, the UK and Europe. We have a bold ambition to become the best Commercial Lines business in the UK, demonstrated by our recent acquisition of NIG and Farmweb, allowing us to scale by leveraging our combined financial strength and importantly ensure our people feel the benefits of our joint capabilities. We are currently recruiting for a Lead Database Engineer to join our established and experienced CIO team here at RSA on a hybrid basis. Your Role The Lead Database Engineer is responsible for leading the design, implementation, and optimization of large-scale ETL systems, with a strong focus on IBM Infosphere DataStage technologies. The role involves guiding a team of engineers, overseeing critical operations, and ensuring the integrity, performance, and security of ETL systems. This role involves both hands-on technical work and leadership responsibilities. The Lead Database Engineer collaborates closely with other platform teams and architects to gather requirements, define goals, and allocate resources effectively. The Lead Database Engineer also actively participates in technical discussions, code reviews, and decision-making processes to drive technical excellence and innovation within the platform team. About You We are looking for candidates that have: Minimum 7 years of experience in IBM Infosphere DataStage, with at least 2 years in a leadership or senior engineering role. Strong hands-on experience with T-SQL, and PowerShell/Bash scripting in SQL Server environments. Extensive experience with DataStage for ETL processes, including package design, deployment, and troubleshooting. Strong proficiency in PowerShell/Bash scripting for automating database tasks, maintenance, and deployments. Deep understanding of relevant regulatory requirements (e.g., GDPR) and how to ensure compliance through database architecture and management Analytical skills to assess and optimize ETL performance and lead strategic decisions for scalability We are looking for accountabilities such as: ETL Design & Architecture Lead the design and management of highly scalable data platform systems, ensuring adherence to industry standards Database/ETL Design, Performance Tuning & Optimization Work with Database Engineers to manage performance tuning strategies, optimizing queries, stored procedures, and databases using T-SQL. Team Leadership & Mentorship Conduct Performance review, goal setting and provide constructive feedback to enhance individual and team performance. Collaboration & Stakeholder Engagement Work with platform teams and architects to ensure that database systems support business objectives Incident & Problem Management Lead incident resolution for critical database issues, ensuring minimal downtime and impact on business operations. Establish root cause analysis practices and ensure that solutions are implemented to prevent recurring issues. Document and maintain knowledge of troubleshooting methods, contributing to a knowledge base for future problem resolution. What we offer you At RSA we put our people first. We have adopted hybrid working as standard, to give you a better work/life balance and an excellent flexible working mindset. That is on top of a comprehensive range of benefits, including pension contributions of up to 11% looking after you now, and in the future. We will give you countless opportunities to continuously develop, alongside a diverse and passionate community of experts, the best the industry has to offer. You will be empowered to be your best self, do your best work, and make a meaningful impact. Our employee promise allows you to shape the future, win as a team, and grow with us. About Us We celebrate individuality and it is important to us that we have a culture where our people feel respected and valued for who they are. We pride ourselves on being accessible and encourage inclusive environments where our people can always give and show the very best of themselves. We understand that home life is a priority and are happy to consider reduced hours or job shares. If you think you would be a great fit for us, but do not meet all the requirements of the role, please contact us as we would love to discuss how RSA could be the next step in your career journey. As a Disability Confident employer, we will ensure that a fair and proportionate number of disabled applicants that meet the minimum criteria for this position will be offered an interview. If you wish to be considered under the scheme then please answer yes to the question Do you wish to be considered under the Disability Confident Scheme? in RSAs application form Please let us know if there are any changes we could make to the application process to make it easier and more comfortable for you. Contact our recruitment team so we can work with you to support you throughout your application.