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 Ordin