Data Migration Specialist

About the Role

The Data Migration Associate executes the end-to-end data migration process for SMB Petcare customers during onboarding, following established procedures and tools. This role involves receiving client-provided data files, evaluating data quality, and performing hands-on work to organize, clean, and transform data for extraction into a proprietary migration tool used to import data into client applications. Strong technical proficiency in Excel, sharp attention to detail, and the ability to follow structured processes across multiple concurrent migration workstreams are required.

Responsibilities

• 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.
• 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.
• 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.
• 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.

Requirements

• 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

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

About the Company

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, and Move fast with purpose. These values guide how we work, collaborate, and grow—together.

Benefits

• 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

Pay

Salary Range: $50,000 - $55,000