Data Migration Specialist

Data Migration Specialist

Petcare

Data Migration Associate

Location: Remote (US)

Role Summary

The Data Migration Associate is responsible for executing the end-to-end data migration process for SMB Petcare customers during onboarding, following established procedures and tools. This role receives client-provided data files, evaluates data quality, and performs the hands-on work of organizing, cleaning, and transforming data for extraction into a proprietary migration tool used to import data into client applications. This role requires strong technical proficiency in Excel, sharp attention to detail, and the ability to follow structured processes across multiple concurrent migration workstreams.

What You'll Do:

1. Client Data Intake & Assessment

• Receive and review client-provided data files in a variety of formats (CSV, Excel, etc.) to assess structure, completeness, and quality.
• Identify gaps, formatting inconsistencies, duplicate records, and data anomalies prior to processing.
• Maintain tracking of submission and migration status across multiple concurrent onboarding engagements.
• Flag data gaps, corrections needed, or missing information to the Onboarding Specialist for client follow-up.

2. Data Cleaning & Transformation

• Organize and clean raw client data to meet the structural requirements of the proprietary migration tool.
• Use advanced Excel capabilities, including XLOOKUP, pivot tables, and Power Query, to manipulate, reshape, and validate data at scale.
• Use basic SQL queries, where needed, to extract targeted datasets from client databases, with support from the Shared Services team for more complex queries.
• Apply consistent data standards and transformation logic across all onboarding engagements.

3. Data Extraction & Migration Execution

• Extract prepared data into the proprietary migration tool following established procedures.
• Execute data imports into client applications, validating results for accuracy and completeness post-import.
• Troubleshoot import errors and data mapping issues, escalating systemic problems to senior team members when appropriate.
• Ensure migrations are completed within onboarding timelines without sacrificing data integrity.

4. Quality Control & Documentation

• Enforce data quality standards throughout the intake, cleaning, and migration lifecycle.
• Maintain accurate records of data submissions, transformation steps, issues identified, and resolutions.
• Log data issues and resolutions using standard templates for team reference.

What You'll Bring:

Technical & Functional Skills

• Advanced Microsoft Excel proficiency, including XLOOKUP, pivot tables, and Power Query for data manipulation and transformation.
• Familiarity with structured data formats, including CSV, Excel, and flat-file structures.
• Ability to interpret data relationships and identify format or structural errors across datasets.

Execution & Detail Orientation

• Strong attention to detail and commitment to data accuracy.
• Ability to follow and apply structured processes consistently across multiple workstreams.
• Strong organizational skills for managing simultaneous client data migrations.
• Comfortable operating in a high-volume, process-driven environment.

Communication

• Clear and professional written communication skills.
• Ability to clearly explain data issues and required corrections to internal stakeholders, including Onboarding and Configuration teams.

Problem Solving

• Ability to identify and resolve data inconsistencies, format errors, and mapping conflicts.
• Structured approach to reviewing and troubleshooting complex datasets.
• Willingness to escalate issues to senior team members when appropriate.

Preferred Qualifications (Nice to Have)

• Basic SQL experience for querying and extracting data from relational databases.
• Exposure to SaaS onboarding or data migration workflows.

What Drives Us

At Togetherwork, we exist to help community-driven organizations grow and thrive, creating better experiences for the people they serve.

As part of our team, you'll contribute to our TW28 vision by living our core values:

• Obsess over our customers.
• Own it. Together.
• Move fast with purpose.

These values guide how we work, collaborate, and grow—together.

The Company offers a comprehensive employee benefits program, including:

• Medical, dental, and vision insurance options 100% Employer paid short/long term disability 100% employer-paid Basic Life and AD&D insurance 401(k) retirement plan with a 100% company match up to 4% Flexible paid personal/vacation time built on mutual trust and accountability 10 sick days annually 10 company paid holidays 12 weeks paid parental leave

Salary Range Disclosure The base range represents the low and high end of the Togetherwork salary range for this position. Actual salaries will vary and may be above or below the range based on factors including, but not limited to location, experience, and performance. The range listed is just one component of Togetherwork's total compensation package for employees. Other rewards may include discretionary bonuses, long term incentives, a flexible paid vacation/personal time policy, 6 weeks paid parental leave and more.

Salary Range $50,000 - $55,000

Inclusion and Diversity: Togetherwork is an Equal Employment Opportunity Employer. We are a company where diverse backgrounds, experiences and viewpoints are valued. Togetherwork does not make hiring or employment decisions on the basis of race, color, religion, gender, gender identity, sex, sexual orientation, disability, veteran status, age, ethnic or national origin, or any other basis protected by all local, state or federal laws.