At Modelit, we are looking for a Data Migration Specialist with strong expertise in leading end-to-end data migrations and a solid background in Python and SQL for data transformation and validation, and excellent English communication skills, both written and spoken.

The ideal candidate will work on complex data projects involving Salesforce (NPSP or NPC), collaborating closely with clients and internal teams to ensure data accuracy, integrity, and alignment with business needs.

They will have the opportunity to contribute to reusable migration frameworks, work with version control in GitHub, while continuously growing their skills with support from our career development programs, flexible culture, and Salesforce certification opportunities.

Responsibilities

• Lead end-to-end data migrations from legacy systems, such as SQL Server, custom databases, or other Salesforce orgs, into Salesforce (NPSP or NPC).
• Participate in discovery and design sessions to understand legacy data structures and define the migration strategy, covering data cleansing and transformation, field mapping, alignment with the Salesforce data model, testing and validation, and data access considerations.
• Design and document data mapping logic, ensuring accurate field alignment between source and target systems.
• Design and implement data transformations and cleansing scripts in Python and SQL.
• Prepare datasets for import and perform pre- and post-load validation to ensure data integrity.
• Lead client-facing validation sessions to confirm design assumptions, review results, and resolve data-related issues collaboratively.
• Maintain all scripts and documentation in GitHub using version control.
• Collaborate with project managers, solution architects, and business analysts to align migration work with system design.
• Manage multiple concurrent migration efforts, balancing priorities and communicating progress and risks to stakeholders.
• Develop and maintain reusable migration frameworks and templates to ensure consistency and repeatability across projects.

Requirements

• 3+ years of experience in data migration or data analysis, ideally within Salesforce projects.
• Proven hands-on experience with Python for data manipulation, transformation, and automation.
• Strong command of SQL for querying, joining, and validating large datasets.
• Solid understanding of relational databases and entity relationships.
• Working knowledge of the Salesforce data model, especially Nonprofit Cloud (NPC) and NPSP.
• Experience performing ETL, data cleaning, and validation.
• Familiarity with Salesforce Data Loader or similar tools.
• Proficiency with GitHub or other version control systems.
• Excellent analytical and problem-solving abilities.
• Strong written and verbal communication skills, with experience in client-facing roles.
• Strong communication skills in English (oral and written).

Nice to Have

• Experience with other Salesforce-managed packages such as PMM or NCCM.
• Prior experience migrating data for nonprofit organizations.
• Familiarity with automation frameworks or additional scripting languages.

Benefits

• Paid time off – because rest matters.
• On-site (from our offices at Sinergia), hybrid, or remote work – your choice!
• Flexible hours – start your day anytime between 8–10am and wrap up between 5–7pm.
• Career growth opportunities – we grow together.
• Ongoing training & development – keep learning, keep leveling up.
• Certification vouchers on us – we’ve got your back when you’re ready to get certified.
• A team culture you’ll love – supportive, collaborative, and fun.