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 Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
