Senior Data Engineer – Pacific Life Re

We are seeking a Senior Data Engineer contractor to support the definition and delivery of an enterprise data platform with engineering best practices. This role will help the divisional data team (DDT) to understand, manage, and prioritise data engineering and transformation activities. The role reports to the AVP Data Engineering, who prioritises, plans, and drives forward the data engineering and transformation tasks required.

This is an exciting opportunity to join a new team tasked with analysis, design, implementation, testing, maintenance, and support for data-intensive pipelines, and to contribute to enhancing system quality and transforming applications through innovation. You will build close working relationships with technology and business units across operating geographies and ensure that technical requirements are understood throughout the project lifecycle, delivering a data warehouse that enables reporting outputs meeting internal customer needs.

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 utilise 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 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 (e.g., DBT Cloud) and a clear understanding of at least one ETL tool (e.g., Matillion, SNP Glue).
• Experience working with AWS and/or Azure DevOps and extensive debugging experience.
• Clear understanding of data modeling, data curation, and orchestration.
• Experience with BI tools like Power BI is a plus.
• Sound understanding of unit testing, test-driven development, functional testing, and performance considerations.
• Knowledge of at least one shell scripting language.
• Ability to network with key contacts outside of own domain.
• Excellent interpersonal, organizational, presentation and facilitation skills.
• Result-oriented and customer-focused mindset.
• Strong organizational skills.
• Excellent verbal and written communication skills enabling efficient interaction and collaboration with stakeholders.
• Knowledge of reinsurance or insurance concepts is a plus.

Technologies

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

Nice to haves

• Power BI / Tableau
• SNP Glue / Matillion / FiveTran
• SAP

Key Skills & Behaviours

• Demonstrates technical skills appropriate to the role and awareness of issues affecting the reinsurance industry.
• Takes responsibility for quality, completeness, and accuracy of work.
• Ability to prioritise competing requests and deadlines.
• Provides accurate and timely updates and escalates issues appropriately.
• Open and collaborative team member who shares knowledge and experience.
• Communicates clearly in both written and verbal form.
• Challenges status quo and drives continuous improvement.
• Adapts to change and works in a dynamic environment with deadlines.
• Team player capable of working with colleagues with diverse skills.
• Agile approach; focuses on end goals and outcomes.

Working For Pacific Life Re

We value the unique qualities each person brings to the business. Our culture supports work-life balance with a range of employee benefits and well-being initiatives, team-building activities, and opportunities to contribute to the community through volunteering and charitable activities.

Benefits (Permanent and Fixed-Term Employees)

Leave: 25 days annual leave with option to buy/sell more; Adoption and fertility leave; Generous parental leave.

Healthcare: Comprehensive private insurance for employee and dependents; Group Life and Income Protection; Optical benefits.

Savings & Retirement: 15% combined employee/employer contributions.

Wellness: Subsidised gym membership; Employee Assistance Program; Cycle to Work and Electric Car Salary Sacrifice; Time off for volunteering; Charitable matching of donations.

We support diversity and inclusion, and will provide reasonable adjustments during the recruitment process to ensure equal access for applicants with disabilities. Please contact us about your needs to discuss suitable adjustments where possible.

Pacific Life Re Values

For more information about our values, please refer to our company materials.