Data Engineer — ETL/SQL Specialist for Banking Data

Axiom Bank; Town of Florida (NY); Hybrid; USD 110,000 - 160,000; Full time

Benefits offered by this job

12 Paid Holidays

Generous PTO

4% 401(k) match

Medical, Dental, and Vision benefits

100% Company Paid Life, AD&D Insurance

Job summary

Axiom Bank is seeking a seasoned Data Engineer to design, build, and optimize Python-based ETL/ELT pipelines for ingestion, staging, and transformation at our Maitland location. You will ensure data quality and reliability across core banking data sources.

You will leverage SQL for complex data transformations and performance tuning, maintain data lineage, and support audits with strong documentation and collaboration across teams.

Qualifications

• Bachelor's degree in a related field or equivalent experience.
• Five+ years of progressively responsible experience in data engineering, ETL/ELT, data warehousing, analytics engineering, or related.
• Experience supporting production data pipelines, reconciliations, and audit-ready evidence.

Responsibilities

• Develops, executes, troubleshoots, and improves Python-based ETL/ELT pipelines for ingestion, staging, transformation, mapping, validation, and output generation.
• Uses SQL to query, transform, validate, reconcile, and load warehouse data; optimizes queries and resolves database issues.
• Maintains source-to-target mappings, schemas, data models, field definitions, relationships, historical structures, lineage, and downstream dependencies.
• Resolves missing or malformed files, incorrect dates, duplicates, nulls, schema or data-type changes, mapping errors, and unexpected balances.
• Executes recurring and ad hoc data processes in the required order and delivers approved staging, intermediate, and final outputs on schedule.
• Monitors production workflows using logging, alerting, retries, backfills, backups, and recovery procedures.
• Performs root-cause analysis across source data, manual inputs, code, mappings, databases, interfaces, and reports.

Skills

Python

SQL

ETL/ELT

Data warehousing

Data modeling

Data quality testing

Version control

Monitoring

Incident response

Documentation

Education

Bachelor's degree in Computer Science / Information Technology / Data Engineering

Tools

Git

Job description

Axiom Bank is seeking a seasoned Data Engineer to design, build, and optimize Python-based ETL/ELT pipelines for ingestion, staging, and transformation at our Maitland location. You will ensure data quality and reliability across core banking data sources.

You will leverage SQL for complex data transformations and performance tuning, maintain data lineage, and support audits with strong documentation and collaboration across teams.