New

Migration Lead - Education Cloud

United States - Remote

Attain Partners is an innovative consulting firm dedicated to disrupting the status quo to change the world and improve the lives of those we touch. From strategy to technology and everywhere in between, our experts use their unique skills to advance the important missions of education, nonprofit, healthcare, and state and local government clients.  

People are at the center of all we do, and that’s why we empower career growth, provide industry-leading benefits packages, encourage a flexible work environment, and foster a culture of inclusion to support the needs of our team. We share a collective passion for our mission and our people. Guided by our seven core values, The Attain Way, our vision is the foundation of our culture—to be and attain the best. 

Job Description

The Migration Lead is responsible for planning, coordinating, and executing data migration efforts into Salesforce Education Cloud and/or Salesforce Advancement. This role oversees the end-to-end migration of source system data—typically delivered in CSV or structured extract formats—into the target Salesforce environment, ensuring data is clean, mapped, transformed, validated, and successfully loaded. The Migration Lead partners closely with functional and technical teams to interpret business requirements, define data models, establish migration rules, and ensure data quality and reconciliation throughout all iterations.

 

Job Responsibilities

  • Build, update, and maintain Source-to-Target Mapping (STM) documentation and migration rules.
  • Prepare datasets and apply transformation logic prior to loading into Salesforce.
  • Execute test and production data loads using Salesforce Data Loader, including inserts, updates, and upserts.
  • Troubleshoot and resolve Data Loader errors, ensuring all records load successfully with proper relationships.
  • Sequence load operations to correctly load parent/child relationships, junction objects, affiliations, and Advancement records.
  • Partner with functional and technical leads to clarify data requirements, business rules, and migration constraints.
  • Manage iterative migration cycles, including initial loads, delta loads, and final cutover activities.
  • Perform post-load data validation and reconciliation to ensure completeness and accuracy.
  • Maintain documentation for migration activities, load instructions, and validation steps.
  • Communicate progress, risks, and issues to project managers and client stakeholders.
  • Support testing activities by preparing test data and addressing defects related to data quality or structure.
  • Participate in migration-related meetings, including data review sessions, mapping walkthroughs, and go-live planning.

 

Required Skills

  • 5+ years of hands-on Salesforce experience, with direct work in Education Cloud and/or Advancement.
  • Strong proficiency with Salesforce Data Loader, including large-volume loads, upsert strategies, relationship mapping, and error resolution.
  • Deep understanding of Education Data Architecture (EDA), including account models, contact structures, affiliations, course connections, and Advancement objects.
  • Experience executing full data migration lifecycles, including mapping, cleansing, transformation, validation, and multi-iteration test loads.
  • Ability to interpret and translate business requirements into data rules, transformation logic, and load sequences.
  • Strong skills in analyzing source data provided via CSV or other extracts to identify required adjustments and understand structural alignment to Salesforce.
  • Comfort working with lookup relationships and load sequencing, including parent-child dependencies, external ID strategies, and record relationships.
  • Experience performing reconciliation and validation after each migration cycle to ensure accuracy and completeness.
  • Excellent communication skills, with the ability to work closely with functional leads, technical architects, and client stakeholders.
  • Strong attention to detail, particularly in managing large datasets, resolving load errors, and ensuring readiness for cutover.
  • Familiarity with Salesforce environments, including sandboxes, scratch orgs, change sets, and deployment patterns related to migrations.
  • 5+ years of SQL Skills

 

Desired Skills

  • Experience with Salesforce Education Cloud or Advancement implementations beyond data migration (functional or technical exposure).
  • Familiarity with Salesforce Admin tasks, including managing objects, fields, validation rules, and permissions during migration cycles.
  • Experience with tools used to transform or stage data prior to loading.
  • Understanding of advancement, student, or alumni lifecycle processes, including gifts, campaigns, engagement scoring, and constituent management.
  • Experience building or reviewing Source-to-Target Mapping (STM) documents and metadata dictionaries.
  • Knowledge of data quality frameworks and basic data profiling techniques.
  • Exposure to SQL for querying, validating, and profiling source data.
  • Experience managing data cutover plans, blackout windows, delta loads, and final production load execution.
  • Familiarity with Salesforce Bulk API, Bulk API 2.0, and considerations for large-volume data loads.
  • Experience collaborating with third-party SIS/CRM/advancement platforms that frequently integrate with Salesforce.
  • Ability to work in agile delivery models, including sprint planning, iterative cycles, and coordinated testing.
  • Strong documentation skills for migration guides, data validation instructions, and post-load reconciliation steps.

 

 

Additional Information

Attain Partners values your mental, emotional, and physical health and wellbeing. Our comprehensive benefits package starts on your first day of employment and includes benefits such as:

  • Competitive health, dental, and vision coverage, HSA and FSA accounts, life and disability insurance, fertility and family planning benefits, and employee assistance and discount programs
  • 11 paid federal holidays and flexible unlimited time off (UTO)
  • Generous 401(k) matching with immediate vesting
  • Flexible career paths – our career tracks provide advancement, mobility, and flexibility as you continue to grow with us
  • A healthy environment where we value unique experiences, and care about everything that makes you, you.

 

Attain Partners is committed to fair and equitable compensation practices. Individual base salary for this position is unique to each candidate and will be commensurate with experience, education, and skills, ranging from $125,000 - $140,000. In addition to base salary, this role is eligible for an annual discretionary bonus.

Interested in this position but the compensation isn’t quite right? Let us know your expectations, and we’ll see if we can make it happen based on your qualifications.

 

Attain Partners is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to sex, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law. 

Applicants have rights under Federal Employment Laws. For more Information visit EEO, EEO Poster Supplement, Family and Medical Leave Act (FMLA), and Employee Polygraph Protection Act (EPPA). 

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process. 

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf

Education

Select...
Select...
Select...
Select...
Select...
Select...
Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Attain Partners’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.