Lead Data Engineer – ETL/ELT

First Citizens Bank

. Design, build, and operate data pipelines using Medallion Architecture across Bronze, Silver, and Gold layers .

Posted 11/2/2026full-timeRemote • United StatesSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and operating data pipelines using Medallion Architecture, with a strong focus on data security, compliance, and cloud-native services. Proficient in advanced data engineering practices, including CI/CD, automated testing, and mentoring junior engineers.

Highest-signal resume keywords

Medallion Architecture Data PipelinesQlik Replicate Data IngestionPython-Based Pipeline DevelopmentSnowflake Features and GovernanceAdvanced SQL and dbt Transformations

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data Pipeline DesignData TransformationCloud PlatformsAdvanced SQLPython ProgrammingCI/CD ImplementationAutomated TestingData GovernanceELT ArchitectureBatch Data Ingestion

Soft Skills

Technical LeadershipMentoringCollaborationDesign DiscussionsCode Reviews

Tools & Technologies

AWS ServicesSnowflakeDbtQlik ReplicateJinja TemplatingS3LambdaECS FargateGlueDynamoDB

Industry Keywords

Data EngineeringData SecurityComplianceProduction-Grade Data PlatformsData Quality

Tech Stack

Tools & technologies

AWSAzureCloudDynamoDBPythonSnowflakeSQL

About the role

Key responsibilities & impact

Design, build, and operate data pipelines using Medallion Architecture across Bronze, Silver, and Gold layers
Own ingestion, transformation, governance, testing, and publishing layers
Ensure pipeline reliability, scalability, performance, and cost efficiency
Implement CDC and batch ingestion using Qlik Replicate
Design ingestion patterns for databases, files, and APIs
Build reusable Python-based pipeline components and frameworks
Develop dbt models using advanced SQL and Jinja templating
Implement automated testing for data quality, schema validation, and freshness
Enable CI/CD-driven transformation deployments
Implement Snowpipe, Tasks, Streams, and Stored Procedures
Design and enforce RBAC, dynamic masking, and tag-based access control
Ensure data security and compliance through platform-level controls
Build and deploy data components using AWS services such as S3, Lambda, ECS Fargate, Glue, DynamoDB, and IAM, or equivalent Azure services
Collaborate on CI/CD, infrastructure automation, and environment promotion
Serve as a technical leader and mentor junior and mid-level data engineers
Lead design discussions, code reviews, and technical decision-making
Establish and enforce engineering best practices and standards

Requirements

What you’ll need

Bachelor’s Degree and a minimum of 6 years of experience in Advanced Data Engineering, data technologies, cloud platforms, and project or technical leadership OR High School Diploma or GED and a minimum of 10 years of experience in Advanced Data Engineering, data technologies, cloud platforms, and project or technical leadership
Deep, hands-on production experience designing, building, and operating production-grade data platforms
Production experience with modern ELT architectures, Snowflake, dbt, Qlik Replicate, Python-based pipeline development, and cloud-native services
Experience designing and operating Medallion Architecture data pipelines
Experience with CDC and batch data ingestion using Qlik Replicate
Custom Python data pipeline development
dbt Mesh Architecture experience
dbt Cloud transformations, testing, SQL, and Jinja templating
Snowflake features including Snowpipe, Tasks, Streams, and Stored Procedures
Snowflake governance including RBAC, tokenization, dynamic data masking, and tag-based access control
Release management, code deployment, and disaster recovery activities
Cloud development using AWS or equivalent Azure services
Ability to mentor junior and mid-level data engineers
Ability to lead design discussions, code reviews, and technical decision-making

Benefits

Comp & perks

Competitive, thoughtfully designed and quality benefits program
Benefits information available at https://jobs.firstcitizens.com/benefits