Manager, Data Migration

Summary

Join AffiniPay as the Data Migration Manager and oversee end-to-end data migrations for clients transitioning to our platform. Lead data extraction, transformation, and loading (ETL) processes, ensuring accuracy, security, and efficiency. Collaborate with Customer Operations, Sales, Engineering, and Product teams. This role demands strong technical expertise in data manipulation, scripting, and SQL-based transformations, along with a deep understanding of customer onboarding and operational workflows. You will manage and execute data migrations, develop and optimize ETL processes, work with various platforms, utilize SQL tools, build scripts and automation, and partner with cross-functional teams. You will also identify and troubleshoot data issues, develop validation processes, communicate with stakeholders, define data migration strategies, and optimize processes for efficiency and scalability.

Requirements

• 5+ years of experience in data migration, data engineering, or a related field, preferably in FinTech, SaaS, or professional services software
• Expertise in SQL-based data manipulation (PostgreSQL, MySQL, SQL Server, CSVs, Excel)
• Proficiency in Python (Django), Ruby, or Ruby on Rails for scripting and data processing
• Strong understanding of ETL workflows, data architecture, and database management
• Experience working with large datasets, relational databases, and data transformation techniques
• Ability to troubleshoot data inconsistencies and implement validation processes
• Strong project management and stakeholder communication skills
• Familiarity with data security best practices and compliance standards

Responsibilities

• Manage and execute the migration of customer data from legacy systems to our platform, ensuring accuracy and integrity
• Develop and optimize ETL processes to extract, clean, transform, and import data
• Work with Salesforce, Zoom, Jira and other platforms to facilitate seamless customer transitions
• Utilize SQL tools to manipulate and transform data as needed
• Build scripts and automation for data processing using Python (Django), Ruby, or modern frameworks
• Partner with Customer Success, Sales, Product, and Engineering teams to ensure smooth data migration and onboarding
• Identify and troubleshoot data integrity issues, working with internal teams to resolve discrepancies
• Develop data validation processes to ensure migrated data is complete and accurate
• Communicate technical concepts to non-technical stakeholders and assist with customer-facing discussions related to data migration
• Define and document data migration strategies, workflows, and best practices
• Continuously optimize migration processes to improve efficiency, scalability, and reliability
• Evaluate and implement automation tools to reduce manual data handling
• Ensure compliance with data security, privacy, and regulatory requirements

Preferred Qualifications

Experience working with Salesforce and Zoom preferred

Benefits

• All employees receive fully covered medical, dental and vision coverage - Choose from our 2 available health plans based on what fits you and/or your family!
• Have some fur babies? - We offer them insurance too!
• RELAX and enjoy your time away with our flexible paid time off policy!
• We will help you plan for your future - 401K, or RRSP if in Canada, with a company match
• Competitive compensation packages that include mid-year and end-of-year bonuses and equity options for all full-time employees
• Health Wellness Program that includes nutrition consultations, mental health apps, and access to discounted memberships
• Have plans to grow your family? - Parental resources, including 16 weeks of paid time off for primary caregivers
• Professional development opportunities including mentorships, leadership programs and our AffiniPayU courses
• We believe it is important to give back with our Matching Gift Program and organized activities focused on donations, volunteerism and supporting the local communities throughout the country
• D&I initiatives provide educational opportunities regarding multicultural issues, tolerance, and celebrating diversity among our entire staff
• An incredible, in-office experience at our headquarters in Austin and San Diego including free lunch delivery, a fully stocked kitchen, and some “sweet” surprises for those afternoon pick-me-ups