Data Migration Engineer
About the role:
At 8am, we’re empowering professionals with the most trusted, innovative technology to deliver world-class outcomes for their clients and exceptional results for their business. 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.
About us:
Founded in 2005, 8am™ (formerly AffiniPay) is the professional business platform built to help legal, accounting, and other client-focused professionals run stronger, more profitable businesses. Today, more than 250,000 professionals across the U.S. trust 8am to help them work smarter, serve clients better, and unlock their full potential. We have been recognized as one of Inc 5000’s fastest growing companies in the U.S. for 13 years in a row, and as a result, our teams continue to grow as well!
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.
Diversity, equity & inclusion at 8am
At 8am, we recognize that innovation occurs with a strong team of people who are diverse in background, personality, talent and ideas. Experience comes in many forms and ensuring a diverse and inclusive workplace where we continue to learn from each other is an integral part of our culture. We are committed to creating a welcoming and transparent environment for all that embraces those differences through education, equal access to opportunities and information, inclusionary programs, and community outreach.
Why 8am
At 8am, our culture is shaped by the people who bring it to life every day. Together, we build a company rooted in continuous learning, genuine community, holistic wellness, and meaningful engagement—values that empower us as individuals and unite us as a team. Our culture is grounded in our core values: Work Smart, Win Fast; Outshine Ordinary, and We Find a Way. These values drive how we serve our customers and work with each other in a collaborative, inspiring, and empowering environment, every day.
Here’s how we support our 8Team:
Statutory Benefits – Full compliance with Colombian social security (health, pension, and risk coverage)
Staff Referral Bonus – Rewards for referring great candidates to the 8Team
Paid Sick Leave – Covered from day one, with EPS support after the 2nd day
Flexible Time Off (FTO) – Up to 15 paid days off per year
Parental Leave – Maternity and paternity leave in line with Colombian law
Company Holidays – Paid time off for all official Colombian public holidays
Security advisory
Our hiring teams at 8am are dedicated to recruiting top talent that share our passion for serving the professional services industry through innovative financial technology. As such, our Talent Acquisition Team only follows legitimate hiring practices. We will always communicate with our candidates using emails with the 8am domain and will never ask for sensitive/personal data during the application process. All interviews take place over phone call, Zoom/Google Meet or in person. All offers are communicated verbally by our Talent Acquisition Specialists with a written offer letter as a follow up.
About the job
Apply for this position
Data Migration Engineer
About the role:
At 8am, we’re empowering professionals with the most trusted, innovative technology to deliver world-class outcomes for their clients and exceptional results for their business. 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.
About us:
Founded in 2005, 8am™ (formerly AffiniPay) is the professional business platform built to help legal, accounting, and other client-focused professionals run stronger, more profitable businesses. Today, more than 250,000 professionals across the U.S. trust 8am to help them work smarter, serve clients better, and unlock their full potential. We have been recognized as one of Inc 5000’s fastest growing companies in the U.S. for 13 years in a row, and as a result, our teams continue to grow as well!
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.
Diversity, equity & inclusion at 8am
At 8am, we recognize that innovation occurs with a strong team of people who are diverse in background, personality, talent and ideas. Experience comes in many forms and ensuring a diverse and inclusive workplace where we continue to learn from each other is an integral part of our culture. We are committed to creating a welcoming and transparent environment for all that embraces those differences through education, equal access to opportunities and information, inclusionary programs, and community outreach.
Why 8am
At 8am, our culture is shaped by the people who bring it to life every day. Together, we build a company rooted in continuous learning, genuine community, holistic wellness, and meaningful engagement—values that empower us as individuals and unite us as a team. Our culture is grounded in our core values: Work Smart, Win Fast; Outshine Ordinary, and We Find a Way. These values drive how we serve our customers and work with each other in a collaborative, inspiring, and empowering environment, every day.
Here’s how we support our 8Team:
Statutory Benefits – Full compliance with Colombian social security (health, pension, and risk coverage)
Staff Referral Bonus – Rewards for referring great candidates to the 8Team
Paid Sick Leave – Covered from day one, with EPS support after the 2nd day
Flexible Time Off (FTO) – Up to 15 paid days off per year
Parental Leave – Maternity and paternity leave in line with Colombian law
Company Holidays – Paid time off for all official Colombian public holidays
Security advisory
Our hiring teams at 8am are dedicated to recruiting top talent that share our passion for serving the professional services industry through innovative financial technology. As such, our Talent Acquisition Team only follows legitimate hiring practices. We will always communicate with our candidates using emails with the 8am domain and will never ask for sensitive/personal data during the application process. All interviews take place over phone call, Zoom/Google Meet or in person. All offers are communicated verbally by our Talent Acquisition Specialists with a written offer letter as a follow up.