Principal Database Engineer

The Principal Database Engineer is a distinguished technical leader responsible for the architecture, evolution, and operational excellence of Intact's Finance and Performance Data platforms.

They set the technical direction for enterprise data stores, drive innovation in data architecture, SQL Server engineering, ETL, Indomulti-platform integration, and ensure the delivery of scalable, secure, and cost-effective data solutions that support financial, actuarial, and regulatory reporting.

As a Principal Database Engineer, the role influences engineering standards, mentors senior engineers, and collaborates with Finance Systems, Service & Change management, Infrastructure, Business Analysis, Testing, and strategic suppliers to shape platform strategy and adoption of best practices across the organisation

You'll make an impact by:

• Serve as the primary Subject Matter Expert for the assigned database platform(s) and supporting applications, providing authoritative technical guidance across the delivery lifecycle.
• Collaborate with Business Analysts, Finance Consultants, Service, and Change teams to define, analyse, and agree system change requirements, including assessing technical feasibility and translating business needs into effective database solutions.
• Produce, review, and consult on Key Design Decisions (KDDs), ensuring that database and data architecture designs are well-documented, technically sound, and consistent with organisational standards.
• Provide technical leadership and guidance to development teams on database design and implementation, including application data architecture, development practices, and testing activities such as test data generation and management.
• Coordinate with offshore development teams, acting as a key liaison between offshore technical resources and internal stakeholders to ensure clarity of requirements and alignment to agreed designs.
• Work closely with wider Intact teams on multi-platform initiatives to ensure database and data requirements related to the platform are fully understood and appropriately addressed.
• Support production operations by assisting in the analysis and resolution of incidents, including detailed examination of production data to identify root causes of issues raised by business users.

• Extensive hands-on experience with Microsoft SQL Server, including database development, administration, and production support in enterprise-scale environments.
• Experience working across database platforms, Unix/Linux systems, and associated reporting and ETL tools, supporting end-to-end data processing and integration requirements.
• Good understanding of database performance and optimisation techniques, including query tuning, indexing strategies, andthe development of test harnesses to support validation and regression testing.
• Demonstrable experience in the design, implementation, and delivery of large-scale data migration, data transformation, and data cleansing solutions.
• Experience acting as a technical Subject Matter Expert for large, complex systems built using multiple technologies and integrated platforms.
• Working knowledge of cloud platforms, with preference for Microsoft Azure, including familiarity with cloud-based database technologies and DevOps tooling to support automated build, deployment, and operational processes.
• Proficiency in data analysis and manipulation tools, with Excel and VBA coding skills preferred to support data validation, analysis, and bulk data upload activities.
• Considerable problem-solving and debugging skills, with the ability to analyse complex technical issues, coordinate with cross-functional teams and subject matter experts, and deliver effective, timely solutions.

Being part of our team means you'll have the support and freedom to bring your best self to work each day. As a permanent member, here's what you can look forward to

• Annual discretionary bonus
• Up to 11% pension contributions
• Hybrid working + flexible hours
• 25 days annual leave + bank holidays + buy/sell options
• Health & wellbeing + virtual GP
• Career development and mentoring
• Inclusive culture + employee networks
• Share investment options

Intact Insurance is the new name for RSA in the UK, Ireland, and across Europe. It's a new name and a new way to do business. Backed by global expertise and a commitment to service that feels different, we're focused on making insurance simpler, faster, and more responsive. Shape the future: We're leading a transformation in insurance helping people, businesses and society prosper in good times and be resilient in bad times. When you join us, you're not just taking a job, you're stepping into a career where you can make a real difference. Grow with us: We're customer-driven, community-focused, and committed to helping our people grow. Whether you're early in your journey or bringing years of experience, we'll support you with the tools, flexibility, and opportunities to thrive.