Description
Data Migration Associate
Work Authorization Notice: Candidates must be authorized to work in the United States for the duration of employment without requiring current or future employer sponsorship of any kind, including but not limited to OPT, STEM OPT, H-1B, or any other visa classification.
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.
Interview Process & Expectations
Our interviews are designed to be interactive and conversational. Candidates are expected to respond based on their own experience and thinking during live interviews.
To ensure a fair and consistent interview experience, the use of real-time AI tools or other external assistance to generate or guide interview responses is not permitted. Interviews are intended to reflect an individual’s judgment, problem-solving approach, and communication.
CCPA Disclosure Notice: Click Here
Similar jobs
Est. 57,500 USD
Support Consultant Location: Remote (US- Eastern/Central preferred) What You'll Do: Provide technical support and troubleshooting for Togetherwork's platform for Microsoft Dynamics 365-based software and related applicat…
Est. 155,000 USD
Director, Customer Experience PMO TogetherWork | Customer Experience Reports to: Vice President, Customer Experience Work Authorization Notice: Candidates must be authorized to work in the United States for the duration…
Est. 73,000 USD
Solution Consultant Location: Austin, TX (Hybrid), OR remote (US) What You'll Do: The solution consultant will work with clients to help leverage their investment in our technologies. The ideal candidate will be able to…
Est. 124,000 USD
Development ManagerLocation: Austin, TexasCompensation: Competitive compensation + benefits Candidates must be authorized to work in the United States for the duration of employment without requiring current or future em…
Est. 57,500 USD
Implementation Specialist Work Authorization Notice: Candidates must be authorized to work in the United States for the duration of employment without requiring current or future employer sponsorship of any kind, includi…
Est. 92,500 USD
QA Automation Engineer Location: Remote Work Authorization Notice: Candidates must be authorized to work in the United States for the duration of employment without requiring current or future employer sponsorship of any…
Est. 140,000 USD
Senior Product Manager, Financial Products Department: Product & Strategy Reports To: Director, Product Management Location: Austin, TX (Hybrid Required) Work Authorization Notice: Candidates must be authorized to wo…
Est. 85,000 USD
Marketing Manager Location: Austin, TX (hybrid 3 days/week in office required); or Remote in Texas/Denver, CO Work Authorization Notice: Candidates must be authorized to work in the United States for the duration of empl…
Est. 124,000 USD
Frontend Engineer Location: Austin, TX (hybrid) Schedule: Full-time | Hybrid (2–3 days in office) Work Authorization Notice: At this time, we are unable to provide immigration sponsorship for this position. Candidates mu…
Est. 120,000 USD
FP&A Manager Location: Austin, TX (Hybrid) Work Authorization Notice: Candidates must be authorized to work in the United States for the duration of employment without requiring current or future employer sponsorship…
Est. 124,000 USD
Sr. Quality Engineer Location: Austin, TX (hybrid) Schedule: Full-time | Hybrid (2–3 days in office) Work Authorization Notice: Candidates must be authorized to work in the United States for the duration of employment wi…
Est. 165,000 USD
Department: Product & Strategy Reports To: Chief Product Officer Location: Austin, TX (Hybrid Required 2-3 days/week) Work Authorization Notice: At this time, we are unable to provide immigration sponsorship for this…
Est. 55,000 USD
Internal Operations Specialist Work Authorization Notice: Candidates must be authorized to work in the United States for the duration of employment without requiring current or future employer sponsorship of any kind, in…
Est. 60,000 USD
Sales Development Representative (SDR) Location: Austin, TX (Hybrid) Work Authorization Notice: Candidates must be authorized to work in the United States for the duration of employment without requiring current or futur…
Est. 110,000 USD
Salesforce Solution Consultant Location: Remote Candidates must be authorized to work in the United States for the duration of employment without requiring current or future employer sponsorship of any kind, including bu…
Est. 80,000 USD
Business Development Representative Austin, TX (Hybrid) Job Summary We are a rapidly-growing software company that enables pet daycare, kennel, grooming, and training business owners to manage their businesses more effic…
Est. 120,000 USD
Product Marketing Manager – Association's Austin, TX or Remote *Note: Direct experience marketing to associations or association-based organizations is a required qualification for this role Work Authorization Notice: Ca…
Est. 85,000 USD
Title: Integrated Marketing Manager (Austin, TX) Location: Austin, TX (hybrid 2 days/week in office required) We are looking for an Integrated Marketing Manager to serve as the primary driver of demand generation and pip…
Est. 92,500 USD
Account Manager (Accountant) (Remote - EST/CST) Account Manager (Accountant) Location: Remote (U.S. — Eastern and Central Time Zones Only) Compensation: up to $95,000 USD per year Work Authorization Notice: Candidates mu…
Est. 114,000 USD
Enterprise Solutions Engineer Location: Austin, TX (Hybrid) Reports to: VP of Sales Engineering & Partnerships Are you a technically sharp, customer-obsessed Solutions Engineer who thrives at the intersection of soft…
Est. 215,000 USD
Who We Are At Justworks, you’ll enjoy a welcoming and casual environment, great benefits, wellness program offerings, company retreats, and the ability to interact with and learn from leaders in the startup community. We…
Est. 190,000 USD
Who We Are At Justworks, you’ll enjoy a welcoming and casual environment, great benefits, wellness program offerings, company retreats, and the ability to interact with and learn from leaders in the startup community. We…
Est. 52,000 USD
Billing Contractor- Part-Time Location: Remote (EST or CST) Schedule: Part-time (20-25 hrs/week) **Please note: this is a contractor role through December 2026.** The Billing Contractor supports recurring billing operati…
Est. 100,000 USD
Salesforce Developer Location: Remote Candidates must be authorized to work in the United States for the duration of employment without requiring current or future employer sponsorship of any kind, including but not limi…
Est. 140,000 USD
Workstream is a mission-driven company building the all-in-one HR, payroll, and hiring platform for managing the hourly workforce. There are 2.7 billion hourly workers, making up 80% of the global workforce, but this mar…
Est. 215,000 USD
Who We Are At Justworks, you’ll enjoy a welcoming and casual environment, great benefits, wellness program offerings, company retreats, and the ability to interact with and learn from leaders in the startup community. We…
Est. 215,000 USD
Who We Are At Justworks, you’ll enjoy a welcoming and casual environment, great benefits, wellness program offerings, company retreats, and the ability to interact with and learn from leaders in the startup community. We…
Workstream is a mission-driven company building the all-in-one HR, payroll, and hiring platform for managing the hourly workforce. There are 2.7 billion hourly workers, making up 80% of the global workforce, but this mar…
Est. 87,500 USD
Who We Are At Justworks, you’ll enjoy a welcoming and casual environment, great benefits, wellness program offerings, company retreats, and the ability to interact with and learn from leaders in the startup community. We…
Est. 150,000 USD
Who We Are At Justworks, you’ll enjoy a welcoming and casual environment, great benefits, wellness program offerings, company retreats, and the ability to interact with and learn from leaders in the startup community. We…