Senior Data Engineer

Job description

Company Overview

Lean Tech is a rapidly expanding organization situated in Medellín, Colombia.

We pride ourselves on possessing one of the most influential networks within software development and IT services for the entertainment, financial, and logistics sectors.

Our corporate projections offer many opportunities for professionals to elevate their careers and experience substantial growth.

Joining our team means engaging with expansive engineering teams across Latin America and the United States, contributing to cutting‑edge developments in multiple industries.

Position Title

Mid+ Data Engineer (Legacy System Validation Specialist)

Location

Remote (LATAM)

What you will be doing

This position is ideal for a detail‑oriented and technically skilled Data Engineer passionate about bridging modern Python‑based solutions with legacy financial systems.

The role focuses on developing and maintaining a Python‑based validation utility to ensure the accuracy of interest rate adjustments on the Fiserv Portico account processing and servicing platform used by credit unions.

You will play a vital role in ensuring data consistency, accuracy, and system reliability through test‑driven development (TDD), data validation, and cross‑system integration.

This position requires analytical thinking, hands‑on programming, and strong collaboration with business, QA, and loan servicing teams.

Responsibilities

• 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.
  
  

Requirements & Qualifications

• 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.
  
  
• Familiarity with Tricentis Tosca and qTest for validation automation.
  
  
• Knowledge of Infrastructure as Code and DevOps automation for deployment consistency.
  
  
• Prior experience in financial institutions, especially in core banking or credit union systems.
  
  
• Exposure to data quality frameworks, ETL processes, or data migration initiatives.
  
  

Soft Skills

• Excellent communication skills in English (written and verbal).
  
  
• Strong analytical and problem‑solving abilities.
  
  
• Excellent attention to detail and precision in data handling.
  
  
• Adaptability to work across modern and legacy technologies.
  
  
• Proactive communication and collaboration with technical and non‑technical stakeholders.
  
  
• Self‑driven and capable of managing multiple priorities in dynamic environments.
  
  

Why you will love Lean Tech

• Join a powerful tech workforce and help us change the world through technology.
  
  
• Professional development opportunities with international customers.
  
  
• Collaborative work environment.
  
  
• Career path and mentorship programs that will lead to new levels.
  
  

Join Lean Tech and contribute to shaping the data landscape within a dynamic and growing organization.

Your skills will be honed, and your contributions will be vital to our continued success.

Lean Tech is an equal‑opportunity employer.

We celebrate diversity and are committed to creating an inclusive environment for all employees.

Required Skill Profession

Bases De Datos, Analítica Y Bi