Salesforce Data Migration Specialist

Hello We’re Spectrum One. We’re on a mission to continuously support our team’s growth—not just technically, but also in how we communicate with clients around the world. With your help, we aim to enhance the communication skills of our team members so they can confidently represent us in every interaction. Since 2015, our support has helped clients raise $150 million in funding, and our services are now available in various parts of the world. None of this would have been possible without the dedication of our team—and now we want to invest further in helping them become the best communicators they can be. Highlights 8 years in the software development industry Profitable; net revenue growth of 200% in 2021 Over $150M raised in funding by our clients Work anywhere in the world with our permanent work-from-home setup Why join Spectrum One? As a team member in Spectrum One, you’ll get the opportunity to really help grow the direction of the company. We don’t micro-manage. We love hustlers who take ownership of their roles. But you’ll definitely get guidance and plenty of support from each other on the team. You’ll be in an environment where learning is always encouraged to empower you to do your best. Competitive hourly rate (flexible based on experience) Permanent work-from-home setup Friendly and collaborative team culture Opportunity to make a direct impact on client-facing success About the Role We are undertaking several data migration projects to consolidate legacy systems into Salesforce, and we're looking for an experienced Salesforce Data Migration Specialist to be a key player in this initiative. You will be instrumental in ensuring the integrity, accuracy, and efficiency of our customers’ data transition into various Salesforce orgs, which commonly utilize the Nonprofit Success Pack (NPSP) and Nonprofit Cloud (NPC). This is a fantastic opportunity to make a significant impact on our organization's data infrastructure and help us build a foundation for future success. Responsibilities: Design & Map: Collaborate with our team to design and implement data mapping strategies from multiple legacy sources to Salesforce NPSP/NPC objects Execute ETL: Lead the end-to-end ETL (Extract, Transform, Load) process, ensuring data is cleaned, transformed, and loaded accurately and efficiently Ensure Data Integrity: Develop and execute robust data validation plans post-migration to guarantee data quality and user acceptance Optimize Processes: Proactively identify and implement improvements to our data migration methodology, tools, and documentation to build a repeatable and scalable process Collaborate: Work closely with our Salesforce Administrator, Salesforce Developers, project managers, and business stakeholders to ensure a smooth and successful migration Qualifications: 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 Salesforce certifications (e.g., Administrator, Platform App Builder) Spectrum One is an equal opportunities employer and welcomes applications from all qualified candidates. #J-18808-Ljbffr