Collaborate with our team to design and implement data mapping strategies from multiple legacy sources to Salesforce NPSP/NPC objects
Lead the end-to-end ETL (Extract, Transform, Load) process, ensuring data is cleaned, transformed, and loaded accurately and efficiently
Develop and execute robust data validation plans post-migration to guarantee data quality and user acceptance
Proactively identify and implement improvements to our data migration methodology, tools, and documentation to build a repeatable and scalable process
Work closely with our Salesforce Administrator, Salesforce Developers, project managers, and business stakeholders to ensure a smooth and successful migration
Requirements
Proven, hands-on experience with the Salesforce Nonprofit Success Pack (NPSP) and Nonprofit Cloud (NPC) data models
Demonstrated expertise in leading at least 2-3 full-cycle data migration projects into Salesforce
Strong understanding of Salesforce data architecture, data modeling principles, and the use of External IDs
Proficiency in data manipulation tools, including advanced spreadsheet functions (VLOOKUP, INDEX/MATCH, Pivot Tables) and data loaders (e.g., Salesforce Data Loader, Dataloader.io, or similar)
Exceptional attention to detail and a problem-solving mindset
Scripting skills for data transformation (Python is a plus)
Experience with SQL for data extraction and analysis