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

First Citizens Bank; Tallahassee (FL); Remote; USD 90,000 - 130,000; Full time

Job summary

First Citizens Bank is seeking a Data Engineer to design, develop, and maintain scalable data pipelines and infrastructure. This remote role collaborates with data scientists and analysts to deliver real-time and batch data solutions.

You will implement ETL, build data warehouses, enforce governance and security, and optimize performance across large datasets using Python, Snowflake, dbt Cloud, and CI/CD tooling.

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.

Responsibilities

• Design, develop, and maintain data pipelines for real-time and batch processing.
• Implement ETL processes and data integration from multiple sources.
• Design data warehouse structures and ensure data quality.
• Apply data modeling techniques for efficient storage and retrieval.
• Implement data governance, quality frameworks, and compliance measures.
• Enforce data security and access controls.
• Analyze and optimize performance for large-scale data operations.
• Write unit tests and adopt automated pipelines using CI/CD tools.
• Manage code deployment across environments including production and DR.
• Collaborate with data scientists and analysts to meet data requirements.

Skills

Data modeling

Data warehousing

ETL design

Cloud data platforms

Data governance

Security & access management

Performance optimization

Testing & automation

CI/CD concepts

Cross-functional collaboration

Education

Bachelor's Degree in a related field

High School Diploma or GED

Tools

Qlik Replicate

Python

dbt Cloud

Snowflake

Snowpipe

RBAC

GitLab

GitHub Actions

Splunk

Dynatrace

AWS

Azure

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.