Senior Data Engineer - ETL/ELT

First Citizens; Raleigh (NC); Remote; USD 120,000 - 180,000; Full time

Job summary

First Citizens is seeking a Senior Data Engineer to design and operate modern cloud-native data pipelines. You will build batch and streaming components, implement Snowflake-based patterns, and ensure data quality and governance.

You will mentor junior engineers, collaborate with leads, and contribute to platform-level improvements while adhering to established architectures and security controls.

Qualifications

• Bachelor's Degree or 4 years of data engineering experience.
• Or High School Diploma with 8+ years of data engineering experience.
• Experience designing and operating cloud-based data pipelines.

Responsibilities

• Design and build data pipelines following Medallion Architecture.
• Develop and support ingestion pipelines with Qlik Replicate.
• Create dbt models and CI/CD deployments.
• Implement Snowflake ingestion patterns and RBAC, masking, and governance.
• Develop Python-based pipeline components and monitoring.

Skills

Medallion Architecture

Python

dbt

Snowflake

CI/CD

AWS

Azure

Qlik Replicate

Snowpipe

RBAC

Education

Bachelor's Degree in Data Engineering/related field

High School Diploma with 8+ years experience

Tools

Qlik Replicate

Python

dbt

Snowflake

AWS

Azure

GitLab

GitHub Actions

Splunk

Dynatrace

Job description

Overview

This is a remote role that may only be hired in the following location(s): North Carolina, Arizona, Texas.

We are seeking a Senior Data Engineer with strong hands-on experience building and operating modern data pipelines in a cloud-based data platform. This role sits one level below the Lead Data Engineer and is focused on implementing, enhancing, and supporting data pipelines and platform capabilities under established architectural patterns.

Senior Data Engineers are expected to be daily hands-on contributors who can independently deliver complex pipeline components, partner effectively with Leads, and mentor junior engineers while continuing to grow toward platform ownership and technical leadership.

Responsibilities & Qualifications

Duties & Responsibilities

Data Pipeline Development

• Design and build data pipelines using established Medallion Architecture patterns (Bronze, Silver, Gold).
• Implement batch and CDC-based ingestion pipelines from databases, files, and APIs.
• Support pipeline reliability, scalability, performance, and cost optimization.

Data Ingestion & Integration

• Develop and support ingestion pipelines using Qlik Replicate for snapshot and CDC patterns.
• Implement ingestion processes for structured and semi-structured data.
• Build and extend Python-based pipeline components following existing frameworks.

Transformation, Modeling & Testing

• Develop dbt models using SQL and Jinja templating.
• Implement and maintain automated tests for data quality, freshness, and schema validation.
• Participate in CI/CD-based deployments of dbt transformations.

Snowflake Development & Governance

• Implement Snowflake ingestion patterns using Snowpipe and Tasks.
• Apply and support RBAC, dynamic masking, and tag-based access controls.
• Develop stored procedures and support governed data access patterns.

Cloud Development

• Develop and operate data workloads using AWS services such as S3, Lambda, ECS Fargate, Glue, DynamoDB, and IAM, or equivalent Azure services.
• Collaborate with senior engineers on deployment pipelines, automation, and environment promotion.

Operational Excellence

• Troubleshoot data pipeline issues and participate in production support.
• Implement logging, monitoring, and alerting for pipelines and data processes.
• Contribute to performance tuning and cost optimization efforts.

Collaboration & Mentorship

• Mentor junior data engineers through code reviews and technical guidance.
• Collaborate with Lead Data Engineers on design and implementation decisions.
• Partner with stakeholders to translate requirements into technical solutions.

Qualifications

Bachelor's Degree and 4 years of experience in Data engineering, data technologies, cloud platforms

OR

High School Diploma or GED and 8 years of experience in Data engineering, data technologies, cloud platforms

Preferred Qualifications:

• Building data pipelines using Medallion Architecture patterns
• Data ingestion using Qlik Replicate (snapshot, CDC, batch)
• Python development for data pipeline components
• dbt Cloud modeling, testing, and SQL development
• Snowflake ingestion and processing (Snowpipe, Tasks, Stored Procedures)
• RBAC and data masking concepts in Snowflake
• Cloud-native development on AWS or equivalent Azure platforms
• Experience with CI/CD pipelines (GitLab, GitHub Actions, etc.)
• Observability and monitoring tools such as Splunk or Dynatrace
• Experience in regulated or governance-heavy environments
• Snowflake AI development using Cortex CoCo
• Relevant cloud or data platform certifications

#LI-JM1

Additional Information

Benefits are an integral part of total rewards and First Citizens Bank is committed to providing a competitive, thoughtfully designed and quality benefits program to meet the needs of our associates. More information can be found at https://jobs.firstcitizens.com/benefits.