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 Software Engineer will design and implement scalable applications, develop and maintain web applications, and lead technology initiatives within a team.
Top Skills:
AWSCSSDjangoDjango Rest FrameworkDockerGceHTMLJavaScriptKubernetesMySQLPostgresPythonReactSQL
Fintech • Legal Tech • Payments • Sales • Software
The Billing Specialist will manage the end-to-end billing process, ensuring accurate invoicing, payment collections, and account reconciliations as well as managing Stripe integrations and providing customer support.
Top Skills:
ExcelGoogle SheetsNetSuiteQuickbooksStripeWorkdayXero
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
What you need to know about the Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
