Analytics Engineer

Pacific Life Insurance Company is hiring an Analytics Engineer to turn enterprise data into trusted, reusable analytics products for reporting and AI use cases.

Responsibilities

• Develop and maintain modular SQL transformations and analytical data models using dbt and Snowflake, delivering reusable datasets for reporting, analysis, data science, and AI.
• Collaborate with business and technical stakeholders to translate needs into data definitions, business rules, metrics, and semantic models.
• Document relationships and assumptions so data can be interpreted consistently across teams and use cases.
• Build automated tests, validate business logic, investigate discrepancies, and maintain documentation and lineage to support accuracy, clarity, and reliability.
• Support development, testing, and evaluation of Snowflake Cortex solutions and AI agents using trusted enterprise data and business context.
• Use Git, Azure DevOps (ADO), and CI/CD workflows for pull-request collaboration, automated validation, and controlled releases across development and production.
• Apply approved AI development tools, including Claude Code and GitHub Copilot, for development, testing, documentation, and workflow automation.
• Review and validate AI-generated outputs while adhering to engineering, privacy, and security standards.
• Provide hands-on guidance, demonstrations, documentation, and knowledge transfer so business partners can adopt analytics products and use Snowflake Cortex more independently.
• Troubleshoot analytical models and workflows, improve query performance and efficiency, modernize manual processes, and contribute reusable patterns to the team’s engineering playbook.
• Partner with data engineering, platform, governance, and technology teams to deliver solutions aligned to enterprise architecture, access controls, and operational standards (including AWS-based components where applicable).

Requirements

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Mathematics, Engineering, or a related field, or equivalent practical experience.
• Typically at least 2–5 years of professional experience in analytics engineering, data engineering, business intelligence development, or a related technical role (minimum 2 years).
• Hands-on experience with dbt and Snowflake, including developing, testing, documenting, and maintaining analytical data models.
• Strong SQL skills and practical understanding of relational and dimensional modeling, data transformation, business logic, and query optimization.
• Experience with Git, branching, pull requests, code reviews, automated testing, and CI/CD.
• Experience with Azure DevOps (ADO) or a comparable delivery platform.
• Working knowledge of Python for scripting, automation, or data-related development.
• Familiarity with AWS and cloud-based data environments; professional AWS experience preferred.
• Ability to translate business questions into technical requirements and clearly communicate technical concepts so stakeholders can adopt analytics solutions.
• Detail-oriented approach to troubleshooting, validating results, documenting decisions, and following work through delivery.
• Preferred: experience with Snowflake Cortex, AI agents, or generative AI solutions.
• Plus: familiarity with Claude Code, GitHub Copilot, or other AI-assisted/agentic tools, with willingness to learn and apply them responsibly.
• Preferred: experience in insurance, financial services, or another regulated environment (not required).

Technologies

• dbt
• Snowflake
• Snowflake Cortex
• AWS
• Python
• Git
• Azure DevOps (ADO)
• CI/CD
• Claude Code
• GitHub Copilot

Location & Compensation

• Location: Newport Beach, CA (onsite)
• Salary: USD 103,140 - 126,060 per year

Benefits

• Medical, Dental, Vision
• Wellbeing Reimbursement Account
• Paid Time Off
• Holiday Schedules
• Financial Planning Time Off
• Paid Parental Leave
• Adoption Assistance Program
• 401k savings plan with company match
• Additional contribution regardless of participation