Senior Data Engineer — Enterprise Data Platform

Pacific Asset Management, LLC; Greater London; On-site; GBP 90,000 - 130,000; Full time

Benefits offered by this job

25 days annual leave

Private health insurance

Parental leave

Pension plan

Gym membership

Employee assistance program

Cycle to work

Volunteer opportunities

Job summary

Pacific Life Re is seeking a Senior Data Engineer to define and deliver an enterprise data platform and governance. You will work with the divisional data team to prioritise data engineering tasks and build a data warehouse delivering reporting outputs for internal customers.

The role focuses on data integration, modelling, testing, and project delivery across geographies, reporting to the Data Engineering Manager. A strong background in SQL, ETL, and BI tooling is essential.

Qualifications

• Proven experience in the market as a SQL and PLSQL developer.
• Extensive experience with SQL cloud databases such as Snowflake, Redshift, BigQuery or Azure SQL.
• Experience with ETL tools like Matillion, SNP Glue, Fivetran or Informatica.
• Azure DevOps experience is a plus.
• Knowledge of data modeling, data curation, and orchestration.
• Experience with BI tools like PowerBI is a plus.
• Understanding of testing approaches and performance considerations.
• Knowledge of at least one shell scripting language.
• Excellent communication and stakeholder collaboration skills.
• Knowledge of reinsurance or insurance concepts is a plus.

Responsibilities

• 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 and standard operating procedures.
• Identify and implement opportunities for system enhancements.
• Support Business Control compliance through technology and IT Controls.
• 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 requirements and provide pertinent feedback.
• Provide technical support to customers and resolve queries.
• Mentor other developers and provide technical assistance as needed.
• Participate in architecture and code reviews.
• Support testing and validation activities in data projects.

Skills

SQL

PL/SQL

Data modeling

Data orchestration

Shell scripting

Communication

Tools

Snowflake

Redshift

BigQuery

Azure SQL

Matillion

SNP Glue

Fivetran

Informatica

Azure DevOps

PowerBI

Job description

Pacific Life Re is seeking a Senior Data Engineer to define and deliver an enterprise data platform and governance. You will work with the divisional data team to prioritise data engineering tasks and build a data warehouse delivering reporting outputs for internal customers.

The role focuses on data integration, modelling, testing, and project delivery across geographies, reporting to the Data Engineering Manager. A strong background in SQL, ETL, and BI tooling is essential.