Data Engineer II

Pacific Life • Full-time • Newport Beach, California, United States • $100.53k - $122.87k / year • 1d ago

Job Description:
Providing for loved ones, planning rewarding retirements, saving enough for whatever lies ahead – our policyholders count on us to be there when it matters most. It’s a big ask, but it’s one that we have the power to deliver when we work together. We collaborate and innovate – pushing one another to transform not just Pacific Life, but the entire industry for the better. Why? Because it’s the right thing to do. Pacific Life is more than a job, it’s a career with purpose. It’s a career where you have the support, balance, and resources to make a positive impact on the future – including your own.

Pacific Life is investing in bright, agile, and diverse talent to contribute to our mission of innovating our business and creating a superior customer experience. We’re actively seeking a technically capable and motivated Data Integration Developer to join our growing Investment Risk Technology team. This role focuses on building and maintaining scalable ETL/ELT pipelines that support analytics and reporting across asset management and investment risk domains. You’ll work with modern tools like Snowflake, Matillion, and DBT, and collaborate with cross-functional teams to deliver impactful data solutions.

This role is on-site. You’ll work at our state-of-the-art Newport Beach headquarters.

How you’ll help move us forward:
Assist in developing and optimizing data pipelines using SQL, Matillion, and Snowflake to support financial modeling and risk analytics.

Support the integration and transformation of data related to Scenarios, Asset Cashflows, and Investment Risk Metrics.

Collaborate with senior developers, analysts, and business stakeholders to ensure data accuracy and usability.

Participate in the software development lifecycle, including CI/CD practices and infrastructure automation using Azure Pipelines and Terraform.

Contribute to the development and maintenance of APIs and UI components for data access and visualization.

Support data architecture and governance efforts in a cloud-first environment leveraging AWS and Snowflake.

The experience you bring:
2+ years of experience

BS Degree: IT, CS, Data Science or Statistics or equivalent experience

Proficiency in SQL and hands-on experience with ETL/ELT tools (Matillion preferred).

Working knowledge of Snowflake for data warehousing and transformation.

Familiarity with cloud platforms, especially AWS.

Exposure to version control and DevOps tools such as Git, Azure Pipelines, and Terraform.

Ability to work collaboratively in an agile, team-oriented environment.

Strong communication skills and a willingness to learn and grow.

What makes you stand out:
Experience with DBT or similar transformation frameworks.

Exposure to enterprise job schedulers like Control-M.

Interest or background in financial services, particularly asset management or investment risk.

Understanding of risk concepts such as stress testing and scenario modeling.

Experience or interest in UI/API development for data access.

A proactive mindset and enthusiasm for continuous learning.

You can be who you are.

People come first here. We’re committed to a diverse, equitable and inclusive workforce. Learn more about how we create a welcoming work environment through Diversity, Equity, and Inclusion at www.pacificlife.com. What’s life like at Pacific Life? Visit Instagram.com/lifeatpacificlife.

Benefits start Day 1.

Your wellbeing is important. We’re committed to providing flexible benefits that you can tailor to meet your needs. Whether you are focusing on your physical, financial, emotional, or social wellbeing, we’ve got you covered.

Prioritization of your health and well-being including Medical, Dental, Vision, and a Wellbeing Reimbursement Account that can be used on yourself or your eligible dependents

Generous paid time off options including Paid Time Off, Holiday Schedules, and Financial Planning Time Off

Paid Parental Leave as well as an Adoption Assistance Program

Competitive 401k savings plan with company match and an additional contribution regardless of participation.

Base Pay Range:
The base pay range noted represents the company’s good faith minimum and maximum range for this role at the time of posting. The actual compensation offered to a candidate will be dependent upon several factors, including but not limited to experience, qualifications and geographic location. Also, most employees are eligible for additional incentive pay.
$100,530.00 - $122,870.00

Your Benefits Start Day 1

Your wellbeing is important to Pacific Life, and we’re committed to providing you with flexible benefits that you can tailor to meet your needs. Whether you are focusing on your physical, financial, emotional, or social wellbeing, we’ve got you covered.

Prioritization of your health and well-being including Medical, Dental, Vision, and Wellbeing Reimbursement Account that can be used on yourself or your eligible dependents

Generous paid time off options including: Paid Time Off, Holiday Schedules, and Financial Planning Time Off

Paid Parental Leave as well as an Adoption Assistance Program

Competitive 401k savings plan with company match and an additional contribution regardless of participation

EEO Statement:
Pacific Life Insurance Company is an Equal Opportunity /Affirmative Action Employer, M/F/D/V. If you are a qualified individual with a disability or a disabled veteran, you have the right to request an accommodation if you are unable or limited in your ability to use or access our career center as a result of your disability. To request an accommodation, contact a Human Resources Representative at Pacific Life Insurance Company.