Data Migration Analyst
Data Migration Analyst (Contract)
Location: Hybrid out of San Francisco, CA
Team: Operations
About Abby Care
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 hybrid 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
Key Workstreams
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.