Senior Data Engineer

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

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

At Pacific Life Re, our vision is to bring an innovative and dynamic approach to the marketplace. Our global team is not afraid to disrupt and challenge industry thinking to provide the best life and health reinsurance services possible. Working in some of the most complex and fast-moving markets has taught us that knowledge and innovation go hand in hand. Today, we are continuing our rapid growth internationally with offices across Europe, Asia, North America, Australia, and Bermuda. With over 1000 employees across the globe, we take pride in our inclusive culture, underpinned by our values and behaviours, providing an environment where everyone can grow and develop.