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.
What the Team is Saying
Similar Jobs
%20copy.jpg)
What We Do
At 8am, our vision is to power a world where professionals thrive. We start every day on a mission to empower professionals with the most trusted, innovative technology to deliver world-class outcomes for their clients and exceptional financial results for their business. They count on our purpose-built solutions to simplify operations, ensure compliance, and fuel profitable growth, so they can focus on their clients and do more of the work that matters.
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!
Why Work With Us
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.
Gallery
8am (Formerly AffiniPay) Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
