Lead Data Engineer: Bank Data Lakehouse & Secure Ingestion

BankOnIT; Alpharetta (GA); On-site; USD 150,000 - 190,000; Full time

Job summary

BankOnIT seeks a Lead Data Engineer to own the Navanta data backbone, from public Call Report data to secure ingestion from bank cores into lakehouses. You will partner with AI/ML, security, and platform teams to ensure a clean, well-modeled foundation for actionable analytics.

You will design lakehouse architectures, enforce data quality and lineage, and lead end-to-end ingestion with observable, auditable pipelines, enabling regulatory-ready data products.

Qualifications

• 8-12+ years in data engineering with end-to-end ownership of ingestion through serving
• Strong Python and expert SQL; rigorous data modeling for analytics
• Hands-on lakehouse experience (Iceberg/Delta/Hudi or equivalent) and modern transformation tooling
• Built reliable pipelines from messy operational and transactional source systems
• Comfort with CDC mechanics and the realities of pulling from databases you do not control

Responsibilities

• Design the lakehouse architecture and catalog for per-bank isolation, dbt models, and a query engine
• Build secure, least-privilege ingestion from bank systems with CDC, batch, and SFTP fallbacks
• Own data modeling for the semantic and metric layer (deposits, concentration, uninsured exposure, asset quality)
• Handle schema drift, data quality, and reconciliation; make ingestion observable and recoverable
• Document data lineage, transformation logic, and access controls for audit readiness
• Define data contracts, quality thresholds, and alerting for pipeline failures

Skills

Python

SQL

Data modeling

End-to-end pipelines

Leadership

Observability

Education

Bachelor's degree

Tools

Apache Iceberg

Delta

Hudi

dbt

Trino

Presto

DuckDB

Dagster

Airflow

Kafka

Redpanda

S3

PostgreSQL

SQL Server

Job description

BankOnIT seeks a Lead Data Engineer to own the Navanta data backbone, from public Call Report data to secure ingestion from bank cores into lakehouses. You will partner with AI/ML, security, and platform teams to ensure a clean, well-modeled foundation for actionable analytics.

You will design lakehouse architectures, enforce data quality and lineage, and lead end-to-end ingestion with observable, auditable pipelines, enabling regulatory-ready data products.