Data Engineer – ETL & Reconciliation

We’re seeking a meticulous Data Engineer to join our client's finance/operations function. In this role, you’ll design and run reliable data pipelines that ingest, clean, and transform transaction information coming from banks, payment partners, and internal applications.

This position is key to ensuring their financial datasets are complete, consistent, and fully prepared for analysis and reporting. It combines strong technical skills with an emphasis on data accuracy, control, and reconciliation.

Core Responsibilities

• Develop, enhance, and manage automated pipelines to load daily transaction files from spreadsheets, APIs, and other sources.


• Reconcile records between banks, acquirers, and payment gateways to identify and resolve discrepancies.


• Create automated checks to catch missing, duplicate, or misaligned data.


• Transform raw inputs into standardized, finance-ready formats suitable for reporting.


• Work closely with the finance team to deliver reliable settlement and transaction summaries.


• Manage elements such as currency conversions, time zone adjustments, fees, and totals.


• Maintain detailed logs and audit trails to ensure traceability of all processing steps.


• Optionally help build internal dashboards or reporting tools to give finance better visibility.

Requirements

• Minimum of 3 years’ experience in ETL, data engineering, or equivalent roles.


• Advanced Python skills (especially working with tabular/array libraries like Pandas or NumPy) and strong SQL knowledge.


• Practical background in data preparation, transformation, and quality control.


• Experience handling financial or high-volume transactional data preferred.


• Ability to deal with messy inputs, multiple file types, and varied data sources.


• High attention to detail and strong documentation habits to support audits and compliance.

Bonus Skills

• Familiarity with payment ecosystems, e-commerce settlements, or acquirer reconciliation processes.


• Exposure to cloud storage services (such as Google Drive or S3) and API-based integrations.


• Understanding of finance operations, settlement cycles, or related workflows.


• Experience with scheduling and orchestration tools (like cron or Airflow) to automate processes.