Analytics Engineer

Pacific Life • Newport Beach, CA

5d • Onsite

About The Position

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. We’re actively seeking a talented Analytics Engineer to join our Analytics Engineering team as part of our Advanced Analytics function in our Newport Beach, CA office. Reporting to the Director, Analytics Engineering, this role will help transform enterprise data into trusted, reusable analytics products that support reporting, machine learning, data science, and AI-powered business solutions. You’ll collaborate with business stakeholders, analytics delivery, data engineers, visualization engineers, and data scientists to translate business needs into tested, documented, and scalable analytical models. Our work goes beyond building data transformations. We capture the business definitions, rules, and relationships that make data meaningful and usable by both people and AI agents. Working with dbt, Snowflake, Snowflake Cortex, AWS, and modern engineering practices, you’ll help deliver reliable analytics solutions while enabling stakeholders to confidently use data and AI. You’ll also contribute to our adoption of AI-assisted and agentic development using tools such as Claude Code and GitHub Copilot, with appropriate testing, human review, and security controls.

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.
• Hands-on professional 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 version control, 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 is preferred.
• Ability to translate business questions into technical requirements, explain technical concepts clearly, and help stakeholders understand and use analytical solutions.
• A thoughtful, detail-oriented approach to troubleshooting, validating results, documenting decisions, and following work through delivery.

Nice To Haves

• Professional AWS experience is preferred.
• Experience with Snowflake Cortex, AI agents, or generative AI solutions is preferred.
• Familiarity with Claude Code, GitHub Copilot, or other AI-assisted and agentic development tools is a plus, along with a willingness to learn and apply them responsibly.
• Experience in insurance, financial services, or another regulated environment is preferred, but not required.

Responsibilities

• Develop and maintain modular SQL transformations and analytical data models using dbt and Snowflake, creating reusable data sets 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.
• Build automated tests, validate business logic, investigate discrepancies, and maintain documentation and lineage to help ensure analytical data is accurate, understandable, and reliable.
• Contribute to the development, testing, and evaluation of Snowflake Cortex solutions and AI agents grounded in 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 deliver controlled changes across development and production environments.
• Apply approved tools such as Claude Code and GitHub Copilot to 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 that help business partners adopt analytics products, use Snowflake Cortex, and become more self-sufficient.
• Troubleshoot analytical models and workflows, improve query performance and efficiency, modernize manual processes, and contribute reusable patterns and improvements to the team’s engineering playbook.
• Work with data engineering, platform, governance, and technology partners to deliver solutions that align with enterprise architecture, access controls, and operational standards, including AWS-based components where applicable.

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level