Senior Data Engineer

Pacific Life Re; Greater London; Hybrid; GBP 120,000 - 150,000; Full time

Benefits offered by this job

Private insurance

25 days annual leave

Gym membership

Cycle to Work

Volunteer days

Job summary

Pacific Life Re is expanding its Divisional Data Team to build an enterprise data platform and governance. The Senior Data Engineer will define and deliver data pipelines, manage transformations, and ensure reporting outputs meet internal needs across geographies.

Role involves collaboration with the DDT, development of a data warehouse, quality improvements, and mentoring teammates while embracing innovation and best practices.

Qualifications

• Proven experience as a SQL/PLSQL developer.
• Extensive experience with Snowflake/Redshift/BigQuery/Azure SQL databases.
• Familiarity with ETL tools (Matillion, SNP Glue, Fivetran, Informatica).
• Knowledge of data modeling, data curation and orchestration.
• Experience with BI tools such as PowerBI is a plus.
• Strong scripting (shell) abilities and automation mindset.
• Experience with Azure DevOps is a plus.
• Knowledge of reinsurance/insurance concepts is beneficial.

Responsibilities

• Assist the data engineering manager with delivery of data engineering activities.
• Create and review technical design specifications.
• Implement, test, maintain and support data software per specs.
• Improve system quality by identifying issues and standardizing procedures.
• Collaborate with team to implement design and architecture reviews.
• Provide technical support to internal customers and stakeholders.
• Mentor junior developers and drive best practices.

Skills

SQL/PLSQL

Cloud SQL

ETL Tools

Data Modeling

PowerBI

Shell Scripting

Azure DevOps

Data Warehouse

Snowflake/Redshift

DWH/BI

Tools

Matillion

SNP Glue

Fivetran

Informatica

DBT

Job description

Job Title

Senior Data Engineer

Job Description

Following extensive global expansion over several years and a drive to standardise common systems and platforms globally, PL Re is undertaking a major back-office transformation programme and has established a Divisional Data Team to develop and manage an enterprise-wide data solution, reporting services and to embed best practice data governance. This team will support the business throughout its back-office transformation and will deliver significant improvement in efficiencies and the value derived from our data assets globally.

We are looking to appoint a Senior data engineer; to support the definition and delivery of an enterprise data platform with engineering best practices. Specifically, this role will help the divisional data team (DDT) to understand, manage, and prioritise data engineering and transformation activities.

The role is reporting to the Data engineering manager, who is responsible for prioritising, planning, and development of the data engineering and transformation tasks required.

This role holder will build close working relationships with the DDT team and business units across our operating geographies and will be responsible for ensuring that technical requirements are clearly understood throughout the project lifecycle, and develop a data warehouse that empowers delivering reporting outputs that meet the needs of our internal customers.

This is an exciting opportunity to join this new team. The Data transformation analyst would fill a critical role within the organisation tasked with analysis, design, implementation, testing, maintenance, and support for data-intensive pipelines. Also, would play an integral role in enhancing system quality, identifying issues, and transforming applications through innovation.

If you’re a tech-savvy individual with a strong drive for creativity, excellence, and ambition, we want to hear from you!

Duties

• Assist the data engineer manager with the delivery of data engineering activities.
• 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 through identification of issues, common patterns, and formulation of standard operating procedures.
• Identify and implement opportunities for system enhancements.
• Working to support Business Control compliance through technology and responsible for ensuring IT Controls are incorporated into Systems.
• Maintain and improve existing codebases and conduct peer code review changes.
• Liaise with team members to implement technical designs.
• Investigate and utilize new technologies as relevant.
• Review functional requirements, analysis, and design documents to provide pertinent feedback.
• Provide technical support to customers, solving problems and answering queries.
• Mentor other development staff members 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 a SQL and PLSQL developer.
• Extensive experience with any SQL cloud databases like Snowflake/Redshift/ BigQuery/Azure SQL database. Experience with any on-premise SQL database like MS SQL Server, Teradata etc.
• Clear understanding of one ETL tool (For eg: Matillion, SNP Glue, Fivetran, Informatica).
• Azure DevOps experience is a plus.
• 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

• DWH (On-premise or cloud – Snowflake preferable)
• ETL
• DBT

Nice to haves

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

Key Skills & Behaviours

• Demonstrates an appropriate level of technical skills for the role and an appreciation of current issues affecting their profession and the life reinsurance industry.
• Takes responsibility for the quality, completeness, and accuracy of own work and reporting issues in a timely manner to the manager.
• Able to prioritise competing requests and deadlines.
• Provides accurate and timely updates on status of work and escalates issues appropriately.
• Committed to being an open and fair team member who shares information, knowledge, and experience openly.
• Communicates in a clear and practical manner both verbally and in writing, without over-reliance on technical language.
• Challenges status quo and is not limited by historical thinking or embedded practices, critically evaluates and challenges current work practices.
• Embraces change and can work in a fluid environment with challenging deadlines: able to be flexible and resourceful.
• Team player: ability to work with people with a diverse range of skills and experiences and get the best out of every individual.
• Agile approach to projects; able to demonstrate the ability to think ahead and always focus on the end goal.

Working For Pacific Life Re

Every person in our global team is valued for the unique qualities they bring to our business and we seek to build their expertise and support their individual ambitions at every step. Of course, we take our work seriously and we know our team can operate under great pressure. We work hard and thrive on achievement, but we also know how to have fun and relax too. We regularly host a range of team building days to strengthen our team’s connection with each other and reflect on their successes.

Providing employees with a healthy work-life balance is very important to our culture. We have a wide range of employee benefits and we host regular social activities and well being initiatives. We are also committed to supporting our employee’s involvement in their communities, by actively fundraising, hosting charity events and overseeing volunteering opportunities.

Benefits (Only 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 coverage of 9x basic annual salary and Group Income Protection up to 75% of basic annual 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

You Can Be Who You Are

We are committed to a culture of diversity and inclusion that embraces the authenticity of all employees, partners and communities. We support all employees to thrive and achieve their fullest potential.

As part of our commitment to diversity and inclusion, we will 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 these with you to make sure that suitable adjustments are made, where possible.

Pacific Life Re Values

Please click here to view our company values