Data Engineer II - ETL/ELT

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 and analytics solutions, and collaborates with cross-functional teams on data-driven initiatives.

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
• Data pipeline development
• Medallion Architecture
• Qlik Replicate
• Snapshot ingestion
• Change data capture
• Batch ingestion
• Python development
• dbt Cloud
• Data transformations
• Data testing
• SQL development
• Snowflake
• Snowpipe
• Snowflake Tasks
• Stored procedures
• Role-based access control
• Data masking
• Cloud-native development
• AWS
• Azure
• CI/CD pipelines
• GitLab
• GitHub Actions
• Observability
• Monitoring
• Splunk
• Dynatrace
• Regulated environments
• Data governance
• Cloud certifications
• Data platform certifications

Benefits

• Remote role

Company

• Commercial and personal banking, lending, and wealth management
• Raleigh, North Carolina, USA
• http://www.firstcitizens.com/
• Founded in 1898
• 10001+ employees

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
• 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, RBAC and Data Masking, AWS, Azure, CI/CD with GitLab or GitHub Actions, Data Governance

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