Data Engineer II - ETL/ELT (Remote - NC, AZ, TX, FL)

First Citizens Bank; Raleigh (NC); Remote; USD 95,000 - 135,000; Full time

Job summary

First Citizens Bank is seeking a data engineering professional to design, develop, and maintain scalable data pipelines and infrastructure. The role emphasizes ETL, data governance, security, and cross-functional collaboration with data scientists and analysts.

The position supports remote work with eligibility to hire in North Carolina, Texas, Arizona, or Florida, and requires proficiency in cloud platforms and data technologies. Strong emphasis on performance and automated testing.

Qualifications

• Bachelor's degree in data engineering, data technologies, cloud platforms.
• Or a High School Diploma or GED with 6 years of data engineering experience.
• Experience with cloud platforms and data technologies.

Responsibilities

• Data Pipelines - design, develop, and maintain ETL pipelines for real-time and batch processing.
• Data Warehousing - design and implement data warehouse structures and ensure data quality.
• Data Governance, Quality & Compliance - implement governance, quality frameworks, and documentation.
• Security & Access Management - implement data security measures and access controls.
• Performance Optimization and Troubleshooting - optimize performance and troubleshoot data issues.
• Testing & Automation - write unit tests and adopt automated pipelines using CI/CD tools.
• Code Deployment & Release Management - manage releases across environments including production and DR.
• Cross-Functional Collaboration - work with data scientists and analysts to meet data requirements.

Skills

Python development

ETL design

Data modeling

SQL development

CI/CD practices

Education

Bachelor's Degree in data engineering/data technologies/cloud platforms

High School Diploma or GED with 6 years experience in data engineering

Tools

Qlik Replicate

dbt Cloud

Snowflake

GitLab

GitHub Actions

Medallion Architecture

Snowpipe

RBAC and data masking in Snowflake

Splunk

Dynatrace

Job description

Overview

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

The position is responsible for designing, developing, and maintaining data pipelines and infrastructure. This role implements data integration, processing, and analytics solutions while collaborating with cross-functional teams to deliver efficient and scalable data systems.

Responsibilities & Qualifications

Duties & Responsibilities:

• Data Pipelines - Design, develop, and maintain data pipelines for efficient data processing and integration for real-time and batch-processing. Implement and optimize ETL processes to extract, load, transform and integrate data from various sources. Enhance data flows and storage solutions for improved performance
• Data Warehousing - Design and implement data warehouse structures. Ensure data quality and consistency within the data warehouse. Apply data modeling techniques for efficient data storage and retrieval
• Data Governance, Quality & Compliance - Implement data governance policies and procedures. Implement data quality frameworks, standards and documentation. Ensure compliance with relevant data regulations and standards
• Security & Access Management - Implement data security measures and access controls. Maintain data protection protocols
• Performance Optimization and Troubleshooting - Analyze and optimize system performance for large-scale data operations. Troubleshoot data issues and implement robust solutions
• Testing & Automation - Write unit test cases, validate the data integrity & consistency requirements, adopt automated data pipelines using GitLab, Github, CICD tools.
• Code Deployment & Release Management - Adopt release management processes to promote code deployment to various environments including production, disaster recovery, and support activities.
• Cross-Functional Collaboration - Collaborate with data scientists, analysts, and other teams to understand and meet data requirements. Participate in cross-functional projects to support data-driven initiatives

Qualifications

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

OR

High School Diploma or GED and 6 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 transformations, 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
• 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.