Data Engineer / Data Modeler

Compunnel, Inc.; Atlanta (GA); On-site; USD 100,000 - 140,000; Full time

Job summary

A leading financial technology firm in Atlanta is seeking an experienced Data Engineer / Data Modeler to design data models and develop data pipelines for the payments subsystem. The ideal candidate will have a background in data engineering, seven or more years of experience in financial services, and expertise in ETL development and cloud platforms. The position requires proficiency in SQL and Python, with strong knowledge of payments domain concepts.

Qualifications

• Minimum 7 years of experience in data engineering and data modeling.
• Strong understanding of payments domain concepts.
• Hands-on experience with data modeling techniques.

Responsibilities

• Design and implement logical and physical data models for payments.
• Develop ETL/ELT pipelines for data integration.
• Monitor and tune data pipelines for performance.

Skills

Data modeling

ETL development

Cloud data platforms

Python

SQL

Education

Bachelor’s degree in Computer Science or related field

Tools

AWS Redshift

Azure Synapse

Informatica

Talend

Kafka

Job description

We are seeking an experienced Data Engineer / Data Modeler to join our banking technology team, focusing on the payments subsystem.

This role involves designing and maintaining scalable data pipelines and models to support real-time and batch payment processing, settlement, reconciliation, and regulatory reporting.

The ideal candidate will bring deep expertise in data modeling, ETL development, cloud data platforms, and modern data engineering practices.

Key Responsibilities

• Design and implement logical and physical data models for the payments domain, including merchant onboarding, transactions, clearing, settlement, funding, fraud/risk, and reporting.
• Develop ETL/ELT pipelines to integrate data from core banking systems, payment gateways, and external partners into enterprise data stores.
• Ensure data quality, lineage, and governance across payment processing workflows.
• Build and optimize data warehouses and lakes on cloud platforms such as AWS or Azure.
• Collaborate with architects, developers, and business analysts to translate payment business processes into data models and schemas.
• Implement real-time and batch data integration for use cases including fraud detection, reconciliations, settlement reporting, and regulatory compliance.
• Monitor and tune data pipelines for scalability, performance, and cost efficiency.
• Partner with security and compliance teams to enforce data privacy and regulatory requirements (e.g., PCI-DSS, SOX, AML/KYC).

Required Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or a related field (or equivalent experience).
• Minimum 7 years of experience in data engineering and data modeling within financial services or banking.
• Strong understanding of payments domain concepts such as authorization, clearing, settlement, reconciliation, chargebacks, and fraud.
• Hands-on experience with data modeling techniques including 3NF, star/snowflake schemas, and dimensional modeling.
• Proficiency in SQL and experience with ETL/ELT tools such as DataStage, Informatica, Talend, or dbt.
• Strong experience with cloud data platforms like AWS Redshift, Azure Synapse, Snowflake, or Databricks.
• Proficiency in Python for data processing and automation.
• Experience with real-time streaming technologies such as Kafka, Kinesis, or EventHub.
• Familiarity with version control systems (e.g., Git) and CI/CD pipelines.

Preferred Qualifications

• Knowledge of regulatory and compliance requirements in payments and banking.
• Understanding of API-based integration for payment systems.
• Familiarity with containerization tools such as Docker and Kubernetes for deploying data services.