Snowflake Cortex Data Jobs

1 job found

Today

Analytics Engineer

Pacific Life Insurance Company Newport Beach, CA

Newport Beach, CA

Today

$103k - $126k/yr Full time Analytics Engineer Artificial Intelligence Azure DevOps

Apply Now

Job Description

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

View full job page →

Get Snowflake Cortex Data Jobs alerts

New Snowflake Cortex Data Jobs, daily.