First Citizens Bank · 2 weeks ago
Lead Data Engineer – Qlik/ Snowflake/ DBT
United States
Full-time
Remote
Senior Level, Lead/Staff
6+ years expFirst Citizens Bank is seeking a Lead Data Engineer to design, build, and operate secure data pipelines on Snowflake. The role involves managing data ingestion frameworks, ensuring security and governance, and implementing robust data models and orchestration processes.
BankingInsuranceLendingPaymentsWealth Management
Responsibilities
Design and implement scalable data ingestion frameworks
Implement Raw → DV 2.0 (Hubs/Links/Satellites) → Consumption patterns in dbt Cloud with robust tests (unique/not null/relationships/freshness)
Build performant Snowflake objects (tables, streams, tasks, materialized views) and optimize clustering/micro-partitioning
Author and operate Airflow (MWAA) DAGs and/or dbt Cloud jobs; design idempotent, rerunnable, lineage-tracked workflows with SLAs/SLOs
Enforce RBAC/ABAC, network policies/rules, masking/row access policies, tags, data classification, and least-privilege role hierarchies
Operationalize audit-ready controls (change management, approvals, runbooks, separation of duties, evidence capture)
Use CI/CD flows, Terraform, Git branching for code promotion
Bake tests into dbt; implement contract checks, reconciliations, and anomaly alerts
Monitor with Snowflake ACCOUNT_USAGE/INFORMATION_SCHEMA, event tables, and forward logs/metrics to SIEM/APM (e.g., Splunk, Datadog)
Right-size warehouses, configure auto-suspend/auto-resume, multi-cluster for concurrency, resource monitors, and query optimization
Build controls and evidence to satisfy internal audit, SOX/GLBA/FFIEC/PCI-like expectations
Qualification
Required
Bachelor's Degree and 6 years of experience in Advanced data engineering, enterprise architecture, project leadership OR High School Diploma or GED and 10 years of experience in Advanced data engineering, enterprise architecture, project leadership
Preferred
Snowflake Platform (hands-on, production): Secure account setup: databases/schemas/stages, RBAC/ABAC role design, grants, network policies/rules, storage integrations
Data protection: Dynamic Data Masking, Row Access Policies, Tag-based masking, PII classification/lineage tagging
Workloads & features: Streams/Tasks, Snowpipe, external tables, file formats, copy options, retries & dedupe patterns
Operations: warehouse sizing, multi-cluster, resource monitors, Time Travel & Fail-safe, cross-region/account replication
Networking concepts: AWS PrivateLink/S3 access patterns, external stages, (at least) high-level familiarity with VPC/DNS/endpoint flows
DBT Cloud: Dimensional + Data Vault 2.0 modeling in dbt (H/L/S), snapshots, seeds, exposures, Jinja/macros, packages, artifacts
Testing and documentation discipline; deployment environments (DEV/QA/UAT/PROD) and job orchestration
Orchestration: Airflow (MWAA): Operators/Sensors (dbt, Snowflake, S3), XComs, SLAs, retries, backfills, alerting, and modular DAG design
Experience deciding when to run in dbt Cloud orchestration vs Airflow, and integrating both cleanly
Data Quality & Observability: Contract tests, reconciliations, freshness SLAs, anomaly detection; surfacing lineage and test results to stakeholders
Query tuning (profiling, pruning, statistics awareness, result caching)
Audit & Controls: Change control with approvals/evidence, break-glass procedures, production access separation, audit log retention/immutability
Runbooks, PIR/RCAs, control mapping (e.g., to SOX/GLBA/PCI-like controls where relevant)
Programming & Cloud: Python (ETL utils, Airflow tasks), SQL (advanced), and AWS basics (S3, IAM, CloudWatch, MWAA fundamentals)
Bonus Skills: Snowflake governance: data classification at scale, Universal Search, tags + masking automation
Iceberg/external table strategies; Kafka or event-driven ingestion patterns
Great Expectations, Monte Carlo/Anomalo/Atlan/Collibra/BigID integrations
dbt: advanced macros, dbt mesh, custom materializations, Slim CI, state comparison, deferral, exposures to BI lineage
BI/Semantic: ThoughtSpot/Looker/Power BI metric-layer design; semantic modeling concepts
Packaging & distribution: internal dbt packages, reusable Terraform modules, cookie-cutter project templates
Platform engineering: FinOps for Snowflake, cost charge-back/show-back, warehouse auto-tuning utilities
Security engineering: SCIM/SSO (Okta), MFA patterns, service-account hardening, ephemeral credentials
SRE practices: SLIs/SLOs, on-call runbooks, incident management
Company
First Citizens Bank
First Citizens Bank provides banking services, essential business and professional services, wealth management capabilities, and more.
10001+ employees
H1B Sponsorship
First Citizens Bank has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (126)
2024 (115)
2023 (249)
2022 (53)
2021 (12)
2020 (9)
Funding
Current Stage
Public CompanyTotal Funding
$33M2021-05-07Post Ipo Debt· $10M
2018-08-29Post Ipo Debt· $23M
1986-10-31IPO
Leadership Team
C
Craig Nix
Chief Financial Officer
Samantha Bureau - Johnson
SVP & Director, Customer Contact Center
Recent News
2026-01-06
2025-12-22
Company data provided by crunchbase