The Data Migration Engineer will manage the transition of data from legacy systems to modern platforms using Python and ETL processes, ensuring data integrity while collaborating with clients and internal teams.
At AffiniPay, we're transforming how professionals get paid by building innovative fintech solutions. As we continue to grow, we're seeking a Data Migration Engineer to help us transition clients from legacy systems to our modern platforms. This role is ideal for someone who enjoys solving complex data challenges, working with clients, and writing clean, scalable code.
What You'll Do
About You
Nice to Have
Additional Information
The monthly salary range for this position is $10,000,000 to $12,600,000 COP. The salary range for performing this role outside of Colombia may differ. AffiniPay is committed to offering competitive, fair and commensurate compensation and has provided an estimated pay range for this role. Actual compensation may vary based on job-related knowledge, skills, experience and education.
What You'll Do
- Build and maintain Python scripts to extract, transform, and load (ETL) data from client legacy systems into AffiniPay platforms.
- Design and execute robust data transformation processes to ensure data accuracy, consistency, and integrity during migration.
- Work closely with clients to assist with data extraction and explain how their data has been migrated and where it resides in the new system.
- Collaborate with internal teams to plan and execute migrations, working through Jira tickets and contributing to a shared Git codebase.
- Participate in daily standups and periodic client meetings to provide updates and resolve data-related challenges.
- Troubleshoot data issues and optimize migration performance.
About You
- Professional Experience: 3+ years of experience working professionally with Python in production environments.
- Database Expertise: Strong knowledge of relational databases (e.g., PostgreSQL, MySQL, SQL Server) and experience writing complex queries.
- Data Transformation Skills: Fluent in data mapping, cleaning, normalization, and transformation.
- ETL Knowledge: Hands-on experience designing and implementing ETL processes.
- Version Control: Familiarity with Git workflows and collaborative coding practices.
- Communication: Comfortable explaining technical concepts to non-technical stakeholders and clients.
- Problem Solver: Strong analytical and troubleshooting skills with attention to detail.
Nice to Have
- Experience with Jira or similar ticketing systems.
- Prior work on data migration projects involving fintech or legacy systems.
- Knowledge of cloud environments (AWS, GCP, or Azure).
Additional Information
The monthly salary range for this position is $10,000,000 to $12,600,000 COP. The salary range for performing this role outside of Colombia may differ. AffiniPay is committed to offering competitive, fair and commensurate compensation and has provided an estimated pay range for this role. Actual compensation may vary based on job-related knowledge, skills, experience and education.
Top Skills
AWS
Azure
ETL
GCP
Git
MySQL
Postgres
Python
SQL Server
Similar Jobs at AffiniPay
Fintech • Legal Tech • Payments • Sales • Software
The Senior Systems Administrator leads IT support, manages SaaS platforms, troubleshoots hardware/software issues, mentors team members, and enhances user productivity through innovative solutions.
Top Skills:
Google WorkspaceIntuneKandjiOktaZoomZscaler
Fintech • Legal Tech • Payments • Sales • Software
As a Senior Full Stack Engineer, you will build and implement new features on AffiniPay's payment platform, improve usability, and mentor other developers.
Top Skills:
AWSDockerHelmJavaScriptJqueryKubernetesMySQLPostgresReactRuby On RailsSQL
Fintech • Legal Tech • Payments • Sales • Software
As a Customer Support Specialist, you'll maintain customer satisfaction, resolve product-related issues, and enhance engagement for our legal software.
Top Skills:
SaaS
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
