Data Migration Analyst

Data Migration Analyst (Contract)
Location: Remote in the United States
Team: Operations

Making family care possible. At Abby Care, we are tackling one of the most important and unsolved challenges of our time: family caregiving.
Over 50 million Americans are family caregivers for loved ones without pay, tools, or support. Our mission is clear and ambitious: to train and employ family caregivers so they can get paid for the care they already provide at home.
Abby Care is building a tech-powered, family-first care platform to efficiently deliver care, improve health outcomes, and provide the best-in-class experience nationwide.
We are rapidly expanding our mission and looking for passionate team members to join. Abby Care has partnered with leading insurance plans, healthcare providers, and community organizations. We’re supported by top, mission-driven VCs to empower families throughout the country.

The Role
We’re looking for an organized and detail-orientated Data Migration Analyst to support ongoing data migration and data quality initiatives across our core systems. This is a remote, contract role focused on executing and validating data migrations into Salesforce, supported by source data from Salesforce, Snowflake, CSVs and other systems.

This role is critical to ensuring data accuracy reliability as we migrate, clean, and reconcile data across platforms that support operational workflows. The analyst will work from defined migration plans and mappings, and will collaborate closely with Operations, Analytics, and Engineering partners. This is an execution-heavy role — ideal for someone who is comfortable working with structured data, understands how systems connect, and can follow complex instructions with precision and care.

The Requirements:

• 3+ years of experience with Salesforce data (objects, fields, relationships, flows)

• 3+ years of experience performing data migrations or imports

• Working proficiency in SQL is strongly preferred

• Job Automation or Integration Experience is preferred

• Familiarity with data governance, auditability, or regulated data environments

Key Responsibilities:

• Execute data migrations into Salesforce from source systems following documented mappings and procedures

• Upload, transform, and reconcile data in Salesforce using tools such as Data Loader, Data Import Wizard, or equivalent

• Validate migrated data for completeness, accuracy, referential integrity, and duplication

• Troubleshoot and flag data issues, mismatches, or unexpected behaviors for escalation

• Document migration steps, issues, and resolutions clearly for auditability and repeatability

• Partner with internal teams to understand object relationships, field definitions, and business rules

• Support cleanup, normalization, and ongoing data hygiene initiatives post-migration

• Adhere to data privacy, security, and compliance standards

Who We’re Looking For

• Technical Experience - You have 3+ years of experience in data migration applications. Precise and careful, comfortable with Salesforce data structures/flows and common breaking points. You are someone who takes pride in clean, correct data and understands its impacts on downstream operations

• Communication - Clear, professional communicator across verbal, written, and digital channels. Comfortable clarifying requirements and working within defined rules

• Analytical - Can parse through and digest large amounts of data to find key insights driving migration success. SQL knowledge is a plus.

• Collaboration - You excel in independent ownership and cross-functional, asynchronous workflows. You can communicate clearly with both technical and non-technical stakeholders.

• Adaptability - Solutions-oriented and quick to pivot in the face of change or uncertainty. Highly organized with a knack for problem-solving and a drive to make processes better every day.

Our Value Proposition to You

• Market Range (US-based contractor):

  • $60–$90 per hour depending on experience level

  • Estimated 3-month contract value: $28,800 – $43,200

• Opportunity for hire after contract

Project Scope

1. Migration Execution

• Load data into Salesforce following documented field mappings and transformation rules

• Use tools such as Data Loader, Data Import Wizard, or equivalent

• Handle large datasets across multiple related objects

2. Validation & Reconciliation

• Validate record counts, field accuracy, and referential integrity

• Identify duplicates and mismatches

• Perform post-migration reconciliation checks

• Confirm alignment with business logic and object relationships

3. Issue Identification & Escalation

• Troubleshoot failed loads and integrity errors

• Flag inconsistencies or unexpected behaviors

• Partner with Engineering/Analytics for resolution

4. Documentation & Auditability

• Clearly document migration steps, logic, and issues

• Maintain repeatable procedures for future migrations

• Ensure compliance with data governance standards

5. Post-Migration Data Hygiene

• Support cleanup, normalization, and QA checks

• Help strengthen data reliability across systems

Other potential projects:

• SFDC Admin and Maintenance

• Sales Engineering Build

• Marketcloud Implementation

• External Integrations (PandaDocs, Slack) and Flows

We are an equal opportunity employer and welcome applicants from all backgrounds, consistent with applicable laws. Employment is contingent upon successful completion of a background check, satisfactory references, and any required documentation.