Analytics Engineer

Pacific Life Insurance Company is hiring an Analytics Engineer to help turn enterprise data into trusted, reusable analytics products. This onsite role in Newport Beach, CA focuses on supporting reporting, machine learning, data science, and AI-powered business solutions through scalable, modern analytics engineering practices.

In this position, you will collaborate with both business and technical stakeholders to build and validate analytical models, strengthen data documentation and lineage, and contribute to Snowflake Cortex solutions and AI agents grounded in trusted enterprise data and business context.

What you will do

• Develop and maintain modular SQL transformations and analytical data models using dbt and Snowflake, producing reusable datasets for reporting, analysis, data science, and AI use cases.
• Partner with stakeholders to understand business processes and translate requirements into clear 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 keep analytical data accurate, understandable, and reliable.
• Support the 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 to manage work, collaborate through pull requests, automate validation, and deploy controlled changes from development to production.
• Apply approved tools such as Claude Code and GitHub Copilot to support development, testing, documentation, and workflow automation.
• Review and validate AI-generated outputs while following engineering, privacy, and security standards.
• Provide hands-on guidance, demonstrations, documentation, and knowledge transfer to help business partners adopt analytics products and use Snowflake Cortex.
• Troubleshoot analytical models and workflows, improve query performance and efficiency, modernize manual processes, and contribute reusable patterns to the team’s engineering playbook.
• Coordinate with data engineering, platform, governance, and technology partners to deliver solutions aligned with enterprise architecture, access controls, and operational standards, including AWS-based components where applicable.

What you bring

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Mathematics, Engineering, or a related field, or equivalent practical experience.
• Typically 2–5 years of professional experience in analytics engineering, data engineering, business intelligence development, or a related technical role.
• 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 explain technical concepts so stakeholders can use analytical solutions.
• A detail-oriented approach to troubleshooting, validating results, documenting decisions, and following work through delivery.
• Experience with Snowflake Cortex, AI agents, or generative AI solutions is preferred.
• Familiarity with Claude Code, GitHub Copilot, or similar AI-assisted tools is a plus, including a willingness to learn and apply them responsibly.
• Experience in insurance, financial services, or another regulated environment is preferred but not required.

Tools and technologies

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

Compensation and benefits

Salary range: USD 103,140 to 126,060 per year.

• 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