Data Engineer II

First Citizens Bank is hiring a Data Engineer II to support its data engineering platforms. The role designs, develops, and maintains scalable data pipelines and infrastructure, implements data integration, processing, analytics, governance, security, and automation solutions, and collaborates with cross-functional teams.

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

Preferred

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

Medallion Architecture

Data Pipeline Development

Qlik Replicate

Snapshot Ingestion

CDC Ingestion

Batch Ingestion

Python Development

dbt Cloud

Data Transformations

Data Testing

SQL Development

Snowflake

Snowpipe

Snowflake Tasks

Stored Procedures

RBAC

Data Masking

AWS Development

Azure Development

CI/CD Pipelines

GitLab

GitHub Actions

Observability Tools

Splunk

Dynatrace

Regulated Environments

Data Governance

Cloud Certifications

Data Platform Certifications

Benefits

Remote role

Company

Financial planning, asset management, brokerage, insurance, and trust services

Raleigh, North Carolina, USA

http://www.firstcitizens.com/

Founded in 1898

51-200 employees

Qualifications

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

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

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

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

Required skills

Data Pipeline Development, Medallion Architecture, Qlik Replicate, Python, dbt Cloud, SQL, Snowflake, Role-Based Access Control, Data Masking, AWS, CI/CD, Regulated Environments

Preferred skills

Data ingestion using Qlik Replicate (snapshot, CDC, batch), Python development for data pipeline components, dbt Cloud transformations, testing, and SQL development, RBAC and data masking concepts in Snowflake, Experience in regulated or governance-heavy environments, Relevant cloud or data platform certifications

Experience

2+ years