Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the design and optimisation of large-scale ETL systems using IBM Infosphere DataStage.
- Company: Join RSA, a people-focused insurance company with a strong presence in North America, the UK, and Europe.
- Benefits: Enjoy hybrid working, pension contributions up to 11%, and continuous development opportunities.
- Why this job: Be part of a transformative journey, making a meaningful impact while collaborating with passionate experts.
- Qualifications: 7+ years in IBM Infosphere DataStage, with strong T-SQL and scripting skills required.
- Other info: We celebrate individuality and support diverse working arrangements, including reduced hours or job shares.
The predicted salary is between 43200 - 72000 £ per year.
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.
#J-18808-Ljbffr
Lead Database Engineer employer: RSA
Contact Detail:
RSA Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Lead Database Engineer
✨Tip Number 1
Familiarise yourself with IBM Infosphere DataStage and its latest features. Being well-versed in the technology will not only boost your confidence during interviews but also allow you to engage in meaningful discussions about how you can contribute to the team.
✨Tip Number 2
Showcase your leadership skills by preparing examples of how you've successfully led teams or projects in the past. Highlighting your experience in mentoring others will resonate well with RSA's emphasis on team leadership and collaboration.
✨Tip Number 3
Research RSA's recent acquisitions and their impact on the business. Understanding the company's strategic direction will help you articulate how your skills can support their goals, especially in optimising ETL systems for their expanding operations.
✨Tip Number 4
Prepare to discuss regulatory requirements like GDPR and how they relate to database management. Demonstrating your knowledge in this area will show that you are not only technically proficient but also aware of the compliance landscape that affects the role.
We think you need these skills to ace Lead Database Engineer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with IBM Infosphere DataStage and T-SQL. Emphasise any leadership roles you've held and specific projects where you've optimised ETL systems.
Craft a Compelling Cover Letter: In your cover letter, express your passion for database engineering and how your skills align with RSA's goals. Mention your experience in team leadership and your approach to problem-solving in critical database issues.
Showcase Relevant Skills: Clearly outline your hands-on experience with PowerShell/Bash scripting and your understanding of regulatory requirements like GDPR. Use specific examples to demonstrate your analytical skills and performance tuning strategies.
Prepare for Technical Questions: Anticipate technical questions related to ETL design, database performance tuning, and incident management. Be ready to discuss your previous experiences and how you’ve led teams to achieve successful outcomes.
How to prepare for a job interview at RSA
✨Showcase Your Technical Expertise
As a Lead Database Engineer, it's crucial to demonstrate your extensive experience with IBM Infosphere DataStage and T-SQL. Be prepared to discuss specific projects where you've successfully implemented ETL processes, highlighting your problem-solving skills and technical knowledge.
✨Emphasise Leadership Skills
Since the role involves guiding a team, share examples of how you've led teams in the past. Discuss your approach to mentorship, performance reviews, and how you foster collaboration within your team to achieve common goals.
✨Understand Regulatory Requirements
Familiarise yourself with relevant regulations like GDPR and be ready to explain how you've ensured compliance in previous roles. This shows that you not only have technical skills but also understand the importance of regulatory frameworks in database management.
✨Prepare for Scenario-Based Questions
Expect questions that assess your analytical skills and decision-making abilities. Prepare to discuss how you would handle critical incidents or optimise ETL performance, as this will demonstrate your strategic thinking and ability to manage high-pressure situations.