Senior Data Engineer - Snowflake & AWS Data Pipelines

Relha LLC; Charlotte, Northern (NC, KY); Hybrid; USD 125,000 - 153,000; Full time

Benefits offered by this job

Health benefits

Paid time off

Parental leave

401k match

Job summary

Pacific Life is seeking a Senior Data Engineer to join the Customer Data team in Charlotte, NC. You will design and build ETL/ELT pipelines in Snowflake on AWS, and develop data models using dbt and Matillion. The role emphasizes Agile delivery with Azure DevOps CI/CD and collaboration with engineers and business partners.

You will also apply AI-assisted development tools to enhance productivity while upholding data governance and quality standards across the data platform.

Qualifications

• 5+ years of experience in data engineering, data integration, or a related technical role; Bachelor’s degree in IT, Computer Science, Data Science, Statistics, or equivalent practical experience.
• Hands-on experience with SQL-based data platforms, ETL/ELT development, and modern cloud or MPP data environments (e.g., Snowflake).
• Working knowledge of AWS, dbt, Matillion, CI/CD pipelines, and Azure DevOps, or comparable tools.
• Proficiency in SQL and at least one programming language such as Python or Java.
• Ability to solve a range of straightforward technical problems using established processes, while receiving moderate guidance and direction.

Responsibilities

• Design, build, test, and support ETL/ELT data pipelines that ingest and transform customer data into an existing Snowflake platform on AWS.
• Develop and maintain data transformations and models using tools such as dbt and Matillion, following established development standards and patterns.
• Execute Agile delivery processes, contributing to sprint planning, development, testing, and deployment activities using Azure DevOps and CI/CD practices.
• Collaborate with senior data engineers, architects, and business partners to understand data requirements, analyze solutions, and deliver reliable customer data assets.
• Utilize approved AI-assisted development tools to improve productivity, code quality, and efficiency while adhering to Pacific Life data governance, security, and quality standards.

Skills

SQL proficiency

Programming in Python or Java

Education

Bachelor’s degree in IT, Computer Science, Data Science, Statistics, or equivalent

Tools

Snowflake

dbt

Matillion

AWS

Azure DevOps

CI/CD pipelines

Job description

Pacific Life is seeking a Senior Data Engineer to join the Customer Data team in Charlotte, NC. You will design and build ETL/ELT pipelines in Snowflake on AWS, and develop data models using dbt and Matillion. The role emphasizes Agile delivery with Azure DevOps CI/CD and collaboration with engineers and business partners.

You will also apply AI-assisted development tools to enhance productivity while upholding data governance and quality standards across the data platform.