Senior Data Engineer
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.
● 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
To excel in this role, you should possess:
● 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.