About this opportunity
First Citizens Bank lists this Data Engineer II - ETL/ELT opportunity in raleigh, North Carolina. Review the employer’s description below for duties, qualifications and application requirements.
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:
Qualified candidates will have proven, hands-on production experience with most of the following:
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 benefits.
Who can apply
Review the original listing for work authorization, qualifications and employer requirements.