Migration & Integration Developer

Role overview Build and support database-driven data migrations and integrations for higher education institutions, with a focus on fundraising and advancement systems. The work centers on translating business needs and source-to-target mappings into SQL transformations, then validating that data moves accurately between legacy platforms, institutional databases, and Salesforce. Development is performed primarily with SQL and database-native tools.

Responsibilities - Develop SQL-based migration and integration processes, including staging tables, stored procedures, scheduled exchanges, and incremental loads. - Translate mapping specifications and stakeholder needs into transformation logic across source and target systems. - Configure Salesforce objects, fields, relationships, validation rules, flows, and data models as needed for delivery. - Create reconciliation queries, record-count checks, duplicate detection, and exception reports to verify data quality. - Troubleshoot data, query performance, transformation, and integration issues; support monitoring and error handling. - Work with technical architects, functional consultants, and client teams to deliver reliable solutions and maintain trusted relationships.

Requirements - Strong SQL development skills, including complex queries, joins, views, functions, stored procedures, and validation scripts. - Experience with enterprise data initiatives for colleges, universities, or university foundations. - Knowledge of advancement operations such as donor and constituent management, fundraising, gift processing, or alumni relations. - Hands-on Salesforce configuration experience and understanding of its standard and custom data structures. - Experience building SQL-based ETL and database integrations, including mapping, transformations, reconciliation, and incremental updates. - Working knowledge of a relational database such as SQL Server, Oracle, or PostgreSQL, plus the ability to collaborate directly with client teams.

Nice to have - Experience with higher education advancement platforms, or migrations from legacy advancement systems to Salesforce or a related platform. - Relevant database or Salesforce certifications. - Experience supporting business development and willingness to travel periodically for client needs.

Benefits and work setup Benefits include health, dental, and vision coverage; health and dependent care accounts; life and disability insurance; family planning support; employee assistance programs; 11 paid federal holidays; flexible unlimited time off; and an immediately vested retirement match. The role is eligible for an annual discretionary bonus, with a stated base salary range of $120,000–$130,000.