The Data Migration Engineer will build Python scripts for data migration, ensure data accuracy, collaborate with clients and teams, and troubleshoot data issues.
It's a new day with a new opportunity at 8am!
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:
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.
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:
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 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.
Top Skills
AWS
Azure
ETL
GCP
Git
JIRA
MySQL
Postgres
Python
SQL Server
Similar Jobs at 8am (Formerly AffiniPay)
Fintech • Legal Tech • Payments • Sales • Software
Manage end-to-end billing processes, ensuring accurate invoicing and payment collections using Stripe. Reconcile accounts and handle customer inquiries professionally.
Top Skills:
ExcelGoogle SheetsNetSuiteQuickbooksStripeWorkdayXero
Fintech • Legal Tech • Payments • Sales • Software
The Business Operations Specialist will drive strategic projects, improve processes, and manage performance insights using Salesforce and other technologies to enhance revenue growth.
Top Skills:
GongHighspotIntercomMarketoOutreachSalesforce
Fintech • Legal Tech • Payments • Sales • Software
The role involves designing and implementing applications, enhancing user experience, conducting code reviews, and collaborating with UX and DevOps teams.
Top Skills:
AWSGoogle Cloud PlatformMySQLNextjsNode.jsPostgresRuby on RailsReactSQL
What you need to know about the Ottawa Tech Scene
The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.
