Senior Data Engineer

Pacific Life; City Of London; On-site; GBP 65,000 - 85,000; Full time

Job summary

A leading global reinsurance firm in London is seeking a Senior Data Engineer to support the development of an enterprise data platform. The role includes preparing technical specifications, enhancing system quality, and mentoring junior staff. Ideal candidates will have extensive experience with SQL cloud databases, transformation tools, and cloud services like AWS or Azure. This contract position offers competitive benefits and a supportive work environment.

Benefits

25 days annual leave

Comprehensive healthcare coverage

15% savings contribution

Subsidized gym membership

Qualifications

• Proven experience as a Data Engineer.
• Extensive experience with SQL cloud databases like Snowflake and MS SQL Server.
• Understanding of transformation tools (DBT Cloud) and at least one ETL tool.
• Ability to network with key contacts outside of own expertise.
• Excellent verbal and written communication skills.

Responsibilities

• Prepare technical design specifications based on requirements.
• Implement, test, and maintain software as defined in specifications.
• Enhance system quality and identify opportunities for improvements.
• Provide technical support to customers and mentor junior staff.
• Participate in architecture and code reviews.

Skills

SQL

Snowflake

DBT

AWS

Azure DevOps

Business Intelligence tools

Shell scripting

Tools

PowerBI

Tableau

SNP Glue

Matillion

Job description

Overview

Senior Data Engineer contractor role within Pacific Life Re to support the definition and delivery of an enterprise data platform with engineering best practices. The role forms part of the Divisional Data Team (DDT) tasked with developing and managing an enterprise-wide data solution, reporting services, and embedding data governance to improve efficiencies and value from data assets globally. The role reports to the AVP Data Engineering and collaborates with technology and business units across operating geographies to ensure technical requirements are understood and that the data warehouse delivers reporting outputs meeting internal customer needs.

This is an exciting opportunity to join a newly formed team responsible for analysis, design, implementation, testing, maintenance, and support for data-intensive pipelines, and to contribute to enhancing system quality and innovative application transformations.

Duties

• Prepare technical design specifications based on functional requirements and analysis documents.
• Implement, test, maintain, and support software as outlined in technical design specifications.
• Enhance system quality by identifying issues, common patterns, and formulating standard operating procedures.
• Identify and implement opportunities for system enhancements.
• Support Business Control compliance through technology and ensure IT Controls are incorporated into systems.
• Maintain and improve existing codebases and conduct peer code reviews.
• Liaise with team members to implement technical designs.
• Investigate and utilize new technologies as relevant.
• Review functional requirements, analysis, and design documents to provide feedback.
• Provide technical support to customers, solving problems and answering queries.
• Mentor other development staff and provide technical assistance as needed.
• Participate in architecture and code reviews.
• Support testing and validation activities within data-related projects and initiatives.

Qualifications & Experience

• Proven experience in the market as an experienced Data Engineer.
• Extensive experience with SQL cloud databases like Snowflake and MS SQL Server.
• Solid experience with transformation tools (DBT Cloud) and understanding of at least one ETL tool (e.g., Matillion, SNP Glue).
• Experience with AWS and/or Azure DevOps and extensive debugging experience.
• Clear understanding of data modeling, data curation, and orchestration.
• Experience with Business Intelligence tools like PowerBI is a plus.
• Sound understanding of unit testing, test-driven development, functional testing, and performance aspects.
• Knowledge of at least one shell scripting language.
• Ability to network with key contacts outside of own expertise.
• Excellent interpersonal, organizational, presentation and facilitation skills.
• Must demonstrate result-orientation and customer-focused mindset.
• Strong organizational skills are required.
• Excellent verbal and written communication skills enabling efficient interaction and collaboration with all stakeholders.
• Knowledge of reinsurance or insurance industry concepts is a plus.

Technologies

• SQL
• Snowflake
• DBT
• Azure DevOps (or any other CI/CD pipeline technology)

Nice to haves

• PowerBI/Tableau
• SNP Glue/Matillion/FiveTran
• SAP

Key Skills & Behaviours

• Demonstrates technical skills appropriate for the role and awareness of current issues in reinsurance.
• Takes responsibility for the quality and accuracy of own work and the team’s work.
• Ability to prioritise competing requests and deadlines.
• Provides accurate and timely updates and escalates issues when needed.
• Open and fair team member who shares information, knowledge, and experience openly.
• Communicates clearly, in practical terms, both verbally and in writing.
• Challengers status quo and embraces change; adaptable to challenging deadlines.
• Team player who collaborates with diverse colleagues to get the best outcomes.
• Agile mindset with focus on end goals.

Working For Pacific Life Re

Every person in our global team is valued for their unique qualities. We support their ambitions, work under pressure, and balance hard work with fun. We host team-building activities and celebrate successes. We aim to provide a healthy work-life balance with a wide range of employee benefits, social activities, and wellbeing initiatives, including community involvement and volunteering opportunities.

Benefits

(For Permanent and Fixed Term Employees)

• Leave: 25 days of annual leave with option to buy/sell more days; Adoption and fertility leave; Generous enhanced parental leave
• Healthcare: Comprehensive private insurance coverage for employee and dependents; Group Life Insurance up to 9x basic salary; Group Income Protection up to 75% of basic salary; Optical benefits
• Savings & Retirement: 15% combined employee/employer contributions
• Wellness: Subsidized gym membership; Access to Employee Assistance Program; Cycle to Work and Electric Car Salary Sacrifice Scheme; Time off for volunteering; Charitable matching of employee donations

As part of our commitment to diversity and inclusion, we provide reasonable adjustments during the recruitment process to ensure equal access to applicants with disabilities. Please contact us about your needs so that we can discuss suitable adjustments where possible.

Pacific Life Re Values

Please view our company values: [values information not included in this description].