Senior Data Engineer
Pacific Life Re3 months ago
London, United KingdomSenior
Responsibilities
- Assist the data engineering manager with delivery of data engineering and transformation activities.
- Prepare technical design specifications from functional requirements and analysis documents.
- Implement, test, maintain, and support software and data-intensive pipelines.
- Develop and support an enterprise data warehouse and reporting outputs for internal customers.
- Improve system quality by identifying issues, patterns, enhancements, and standard operating procedures.
- Maintain existing codebases, conduct peer code reviews, and participate in architecture and code reviews.
- Support business control compliance by incorporating IT controls into systems.
- Provide technical support to customers and resolve problems and queries.
- Mentor development staff and provide technical assistance.
- Support testing and validation activities for data-related projects and initiatives.
- Collaborate with data team members, business units, and stakeholders across operating geographies.
- Investigate and use relevant new technologies.
Requirements
- Proven experience as a SQL and PL/SQL developer.
- Extensive experience with a cloud SQL database such as Snowflake, Amazon Redshift, BigQuery, or Azure SQL Database.
- Experience with an on-premise SQL database such as Microsoft SQL Server or Teradata.
- Clear understanding of at least one ETL tool, such as Matillion, SNP Glue, Fivetran, or Informatica.
- Understanding of data modeling, data curation, and orchestration.
- Knowledge of at least one shell scripting language.
- Understanding of unit testing, test-driven development, functional testing, and performance considerations.
- Ability to network with key contacts outside the candidate’s area of expertise.
- Strong interpersonal, organizational, presentation, facilitation, verbal communication, and written communication skills.
- Ability to prioritize competing requests and deadlines, provide timely work updates, and escalate issues appropriately.
- Customer-focused, results-oriented, collaborative, flexible, and resourceful approach.
- Experience with Azure DevOps is advantageous.
- Experience with Power BI or other business intelligence tools is advantageous.
- Experience with Tableau, SNP Glue, Matillion, Fivetran, SAP, or insurance and reinsurance concepts is advantageous.
Benefits
- 25 days of annual leave with an option to buy or sell additional days.
- Adoption and fertility leave and enhanced parental leave.
- Private healthcare insurance for employees and dependents, optical benefits, group life insurance, and group income protection.
- 15% combined employee and employer savings and retirement contributions.
- Subsidized gym membership, an Employee Assistance Program, Cycle to Work, and an Electric Car Salary Sacrifice Scheme.
- Time off for volunteering and charitable matching of employee donations.
- Team-building days, social activities, wellbeing initiatives, and support for community involvement.
- Benefits apply to permanent and fixed-term employees.
Tech Stack
Categories
Data Engineering
About Pacific Life Re
Pacific Life Re provides life and health reinsurance to insurers, covering protection, critical illness, income protection, longevity risk transfer, and retrocession. It earns through risk premiums and related services such as underwriting support, pricing, and analytics. The company operates globally from a headquarters in Bermuda with offices across Europe, Asia, North America, and Australia, and is backed by parent Pacific Life, a U.S. insurer with a 150-year heritage.