Senior Data Engineer

Pacific Life Insurance; Newport Beach (CA); On-site; USD 138,000 - 168,000; Full time

Benefits offered by this job

Health insurance and wellbeing program

Paid time off and holidays

Parental leave and adoption assistance

Company 401k with match

Job summary

Pacific Life Insurance is seeking an experienced data engineering leader to design and implement enterprise-scale data pipelines using Snowflake, DBT, Matillion, AWS, SQL, and Python. You will build analytics-driven data products and Power BI models to support investment and business insights.

The role emphasizes data governance, CI/CD, and AI-assisted development while delivering reliable, scalable solutions.

Qualifications

• 6+ years designing, developing, and delivering enterprise-scale data solutions.
• Hands-on with Snowflake, DBT, Matillion, SQL, AWS, Python, and modern data integration tech.
• Experience building cloud data pipelines, data warehouses, and analytics solutions.
• Experience supporting Power BI semantic models, datasets, dashboards, and reporting.
• Strong data architecture, modeling, governance, security, and SDLC practices.
• Experience in Agile delivery with business/tech stakeholders.
• Self-starter, ownership, and multi-hat capabilities in a dynamic environment.

Responsibilities

• Design, build, and maintain scalable data pipelines and integration solutions.
• Develop and support data products enabling analytics, reporting, AI, and BI.
• Design and maintain Power BI datasets, dashboards, and reporting solutions.
• Translate requirements into data models, mappings, and designs.
• Collaborate with stakeholders to deliver reliable data solutions.
• Implement data quality, governance, monitoring, and validation frameworks.
• Contribute production-quality code and assist with CI/CD and operations.
• Leverage AI-assisted tools to accelerate design, development, testing, and documentation.
• Troubleshoot production issues and improve platform reliability and performance.
• Drive automation and reduce technical debt; mentor team members.
• Communicate progress, risks, and dependencies to technical and non-technical audiences.

Skills

Snowflake

DBT

Matillion

SQL

AWS

Python

ETL/ELT

Power BI

Education

Bachelor's degree in Computer Science, Information Systems, Data Engineering, Software Engineering, or related

Tools

Power BI

Job description

Job Description:

What You’ll Do

• Design, build, and maintain scalable data pipelines and integration solutions using Snowflake, DBT, Matillion, AWS, SQL, Python, and modern ETL/ELT technologies.
• Develop, optimize, and support enterprise data products that enable analytics, reporting, AI, and business intelligence initiatives.
• Design and maintain Power BI semantic models, datasets, dashboards, and reporting solutions that support critical business and investment decisions.
• Translate business and technical requirements into data models, mapping specifications, solution designs, and implementation plans.
• Partner with business stakeholders, product owners, architects, and engineers to deliver scalable, reliable, and high-performing data solutions.
• Implement data quality, governance, reconciliation, monitoring, and validation frameworks to ensure accuracy, reliability, and compliance.
• Contribute production-quality code and participate in code reviews, testing, CI/CD automation, and operational support.
• Leverage AI-assisted development tools such as GitHub Copilot, ChatGPT, Claude, and similar technologies to accelerate solution design, development, testing, troubleshooting, and documentation.
• Troubleshoot production issues, perform root cause analysis, and ensure platform reliability and performance.
• Drive continuous improvement through automation, simplification, reusability, and reduction of technical debt.
• Mentor team members and contribute to a collaborative, high-performing engineering culture.
• Communicate effectively with technical and non-technical stakeholders and provide timely updates on progress, risks, and dependencies.

What You’ll Bring

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, Software Engineering, or a related discipline.
• 6+ years of experience designing, developing, and delivering enterprise-scale data solutions.
• Strong hands‑on experience with Snowflake, DBT, Matillion, SQL, AWS, Python, and modern data integration technologies.
• Experience building and optimizing cloud-based data pipelines, data warehouses, and analytical solutions.
• Experience developing and supporting Power BI semantic models, datasets, dashboards, and enterprise reporting solutions.
• Strong understanding of data architecture, data modeling, governance, security, and software engineering best practices.
• Experience working within Agile delivery teams and collaborating with business and technology stakeholders.
• Excellent problem‑solving skills with the ability to balance strategic thinking and hands‑on execution.
• Strong communication skills with the ability to explain complex technical concepts in practical business terms.
• Demonstrated ability to be a self‑starter, take ownership of initiatives, and drive work forward with minimal supervision.
• Comfortable operating in a dynamic environment and wearing multiple hats across engineering, analytics, solution design, production support, and stakeholder engagement.
• Proven ability to prioritize competing demands, manage deadlines, and proactively identify and elevate risks.

Investments Domain Expertise

• 3+ years of experience supporting Investment Management, Asset Management, Capital Markets, Investment Accounting, or Financial Services data platforms.
• Strong understanding of one or more investment domains, including:
  • Commercial Mortgage Loans
  • Fixed Income Securities
  • Private Placements
  • Structured Products
  • Equities
  • Real Estate Investments
  • Alternative Investments
  • Investment Performance and Attribution
• Experience building solutions that support investment operations, portfolio management, investment accounting, risk management, compliance, treasury, or investment reporting functions.
• Understanding of investment data concepts.
• Ability to translate complex investment business processes and requirements into scalable data models, reporting solutions, and analytics platforms.
• Experience partnering directly with investment professionals and business stakeholders to understand challenges, define requirements, and deliver business value.

Preferred Qualifications

• Experience with DBT, Matillion, Control-M, and modern data orchestration platforms.
• Experience supporting enterprise Power BI environments, including governance, performance optimization, and semantic model design.
• Experience integrating data from investment platforms such as Aladdin, Bloomberg, Clearwater, Eagle, Geneva, PAM, or similar investment management systems.
• Experience leveraging AI-augmented engineering practices to improve software development productivity, quality, and delivery outcomes.

What Sets You Apart

The ideal candidate combines deep technical expertise with strong investment domain knowledge. You understand that delivering great data solutions is about more than moving data between systems. You understand how portfolio managers, investment operations teams, accountants, analysts, and business leaders rely on trusted data to make critical decisions.

You are a naturally curious engineer who challenges the status quo, embraces change, and continuously looks for opportunities to improve platforms, processes, and outcomes. You are comfortable working through ambiguity, taking ownership without waiting for direction, and balancing both strategic initiatives and day-to-day operational needs.

You thrive in a collaborative environment, communicate effectively with both technical and business audiences, and consistently deliver high-quality solutions that create measurable business value.

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.

$137,610.00 - $168,190.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

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.

What’s life like at Pacific Life? Visit Instagram.com/lifeatpacificlife

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.