Senior Data Engineer

Lean Tech

full-time

Posted on: 10/15/2025

Location Type: Remote

Location: Remote • 🇨🇴 Colombia

✨ AI Apply

Senior

NumpyPandasPythonSQL

About the role

Design, develop, and maintain validation utilities in Python, leveraging frameworks such as Pandas, NumPy, and Pytest following a Test-Driven Development (TDD) approach.
Extract, validate, and process loan and financial data from mainframe sources through direct query methods.
Access and interpret VSAM and IAM files via SFTP/FTP transfers to staging areas using libraries such as copybook or cobol-py for data parsing and structuring.
Design and automate record-level data comparison and reconciliation processes, ensuring precision and reliability in validation logic.
Collaborate with QA and business analysts to align validation frameworks with functional business rules and loan servicing requirements.
Create and maintain clear technical documentation, test cases, and validation process reports.
Integrate testing and automation tools such as Tricentis Tosca and qTest for advanced validation coverage.
Work with SQL Server for storing validation results and supporting structured data analysis.
Interpret and analyze existing COBOL-based logic and data structures to build accurate Python translation utilities.
Maintain compliance with security, quality, and industry standards throughout all validation activities.

Bachelor’s degree in Computer Science, Data Engineering, or a related field, or equivalent experience (6+ years) in software and data engineering.
Proven experience in Python programming with hands-on knowledge of Pandas, NumPy, and Pytest.
Strong understanding of Test-Driven Development (TDD) practices and automation frameworks.
Experience accessing and processing legacy mainframe data sources (VSAM, IAM files).
Proficiency with data validation, data reconciliation, and record-level comparisons.
Knowledge of financial applications, particularly core banking or loan servicing systems (preferably Portico).
Understanding of adjustable-rate mortgage (ARM) and interest rate adjustment processes.
Experience in SQL Server database design and query optimization.
Familiarity with FTP/SFTP data exchange, data parsing, and file transformation.
Strong experience in creating documentation and reporting technical test results.
Excellent written and verbal communication skills in English.
Ability to work independently, manage priorities, and collaborate effectively across multiple teams.
Nice to have: Experience with COBOL interpretation and mainframe file parsing.

Benefits

Tip: use these terms in your resume and cover letter to boost ATS matches.

PythonPandasNumPyPytestTest-Driven DevelopmentSQL Serverdata validationdata reconciliationdata parsingCOBOL

communicationcollaborationindependencepriority managementdocumentation