Migration & Integration Developer

This is a fully remote position, open to applicants in United States.

📋 Description

• Design, develop, test, and implement SQL-based data migrations and integrations.

• Create and sustain data pipelines, transformation logic, staging tables, stored procedures, and integration processes within database environments.

• Assist with data migration and integration projects for Higher Education clients, particularly in Advancement and fundraising systems.

• Integrate legacy Advancement platforms, institutional databases, and Salesforce environments.

• Collaborate with technical architects, functional consultants, and client stakeholders.

• Ensure data accuracy, integrity, and the successful delivery of migration and integration solutions.

• Support mock migrations, user acceptance testing, cutover, and production deployments.

• Troubleshoot data, SQL performance, transformation, and integration challenges.

• Assist with sales and business development efforts.

⛳️ Requirements

• Advanced SQL development skills, including complex queries, stored procedures, views, functions, joins, transformations, and data validation scripts.

• Prior experience working with colleges, universities, or university foundations on enterprise data initiatives.

• Strong comprehension of fundraising, donor management, gift processing, alumni relations, constituent management, and Advancement business processes.

• Practical Salesforce configuration experience, encompassing standard and custom objects, fields, relationships, validation rules, flows, and data models.

• Experience in developing SQL-based ETL processes featuring staging tables, source-to-target mappings, transformations, reconciliation, and incremental data loads.

• Experience in building and supporting database-driven integrations with scheduled data exchanges, incremental updates, error handling, and monitoring.

• Ability to interpret source-to-target mapping specifications and convert business requirements into SQL transformation logic.

• Experience with reconciliation queries, duplicate identification, record-count validation, and exception reporting.

• Strong knowledge of Microsoft SQL Server, Oracle, or PostgreSQL.

• Ability to independently diagnose and resolve data, SQL performance, transformation, and integration issues.

• Excellent communication skills and the capacity to work directly with client technical and functional teams.

• 5+ years of professional experience in SQL development, database development, data migration, or data integration.

• 3+ years of experience supporting Higher Education institutions, ideally within Advancement, fundraising, or alumni relations.

• 2+ years of hands-on Salesforce experience, including data model configuration, data loading, and troubleshooting.

• Proven completion of at least one enterprise data migration or integration project involving a Higher Education Advancement system.

• Demonstrated ability to cultivate trusted advisor relationships with clients.

• Experience in supporting sales and business development initiatives.

• Willingness to travel periodically based on business and client requirements.

• Preferred certifications include Microsoft Azure Database Administrator Associate, Azure Data Engineer Associate, Salesforce Certified Platform Administrator, Salesforce Certified Platform App Builder, Salesforce Certified Data Cloud Consultant, and Oracle Database SQL Certified Associate or equivalent.

🏝️ Benefits

• Competitive health, dental, and vision insurance.

• HSA and FSA accounts.

• Life and disability insurance.

• Fertility and family planning benefits.

• Employee assistance and discount programs.

• 11 paid federal holidays.

• Flexible unlimited time off (UTO).

• Generous 401(k) matching with immediate vesting.

• Flexible career paths with opportunities for advancement, mobility, and adaptability.

• Flexible work environment.

• Career growth opportunities.

• Inclusive culture and supportive atmosphere.

• Eligibility for an annual discretionary bonus.