Migration & Integration Developer

Attain Partners

6d•$120,000 - $130,000

About The Position

Attain Partners is seeking an experienced Migration & Integration Developer to support data migration and integration initiatives for Higher Education clients, particularly in Advancement and fundraising systems. The developer designs, develops, tests, and executes SQL-based data migrations and integrations between legacy Advancement platforms, institutional databases, and Salesforce environments. Development is performed primarily with SQL and database-native technologies rather than integration platforms such as MuleSoft or Boomi. The role involves building and maintaining data pipelines, transformation logic, staging tables, stored procedures, and integration processes within database environments. The developer collaborates with technical architects, functional consultants, and client stakeholders to ensure data accuracy, integrity, and successful delivery. Attain Partners is a consulting firm serving education, nonprofit, healthcare, and state and local government clients. The company describes a flexible work environment, a culture of inclusion, and support for career growth. This position requires periodic travel based on business and client needs. Compensation is a base salary of $120,000–$130,000 USD, commensurate with experience, education, and skills, and the role is eligible for an annual discretionary bonus.

Requirements

5+ years of professional experience in SQL development, database development, data migration, or data integration.
3+ years of experience supporting Higher Education institutions, preferably in Advancement, fundraising, or alumni relations.
2+ years of hands-on Salesforce experience, including data model configuration, data loading, and troubleshooting.
Demonstrated experience completing at least one enterprise data migration or integration initiative involving a Higher Education Advancement system.
Strong hands-on SQL skills, including complex queries, stored procedures, views, functions, joins, transformations, and data validation scripts.
Previous experience working with colleges, universities, or university foundations on enterprise data initiatives.
Strong understanding of fundraising, donor management, gift processing, alumni relations, constituent management, and Advancement business processes.
Hands-on experience navigating and configuring Salesforce, including standard and custom objects, fields, relationships, validation rules, flows, and data models.
Experience developing SQL-based ETL processes using staging tables, source-to-target mappings, data transformations, reconciliation, and incremental data loads.
Experience building and supporting database-driven integrations, including scheduled data exchanges, incremental updates, error handling, and monitoring.
Ability to interpret source-to-target mapping specifications and translate business requirements into executable SQL transformation logic.
Experience developing data reconciliation queries, duplicate identification logic, record-count validation, and exception reporting.
Strong working knowledge of relational database technologies such as Microsoft SQL Server, Oracle, or PostgreSQL.
Ability to independently diagnose and resolve data, SQL performance, transformation, and integration issues.
Strong communication skills and ability to work directly with client technical and functional teams.
Demonstrated ability to build trusted advisor relationships with clients.
Flexibility to travel periodically based on business and client needs.

Nice To Haves

Experience with Higher Education Advancement platforms such as Ellucian Advance, Kindsight ascend, Blackbaud CRM/Raiser's Edge, Banner Advancement, or Salesforce Education Cloud.
Familiarity with Advancement data structures, including constituents, households, relationships, gifts, pledges, payments, designations, campaigns, and recognition credits.
Experience migrating legacy Advancement platforms to Salesforce or Kindsight ascend.
Experience with Salesforce Data Loader, Bulk API, and Salesforce data import/export processes.
Experience with Salesforce SOQL and Salesforce object relationships.
Experience with Microsoft SQL Server Integration Services (SSIS), SQL Server Agent, or equivalent database scheduling technologies.
Experience developing reusable SQL scripts, data migration frameworks, and automated validation processes.
Understanding of data governance, data stewardship, data quality, and master data management principles.
Experience supporting mock migrations, user acceptance testing (UAT), cutover, and production deployments.
Familiarity with Git or other source control solutions for managing SQL development.
Microsoft Certified: Azure Database Administrator Associate or Azure Data Engineer Associate certification.
Salesforce Certified Platform Administrator certification.
Salesforce Certified Platform App Builder certification.
Salesforce Certified Data Cloud Consultant certification.
Oracle Database SQL Certified Associate or equivalent database certification.

Responsibilities

Design, develop, test, and execute SQL-based data migrations and integrations between legacy Advancement platforms, institutional databases, and Salesforce environments.
Build and maintain data pipelines, transformation logic, staging tables, stored procedures, and database-based integration processes.
Develop ETL processes, source-to-target mappings, data transformations, reconciliation processes, and incremental data loads.
Build and support database-driven integrations, including scheduled data exchanges, incremental updates, error handling, and monitoring.
Develop data-quality and validation processes, including reconciliation queries, duplicate identification logic, record-count validation, and exception reporting.
Diagnose and resolve data, SQL performance, transformation, and integration issues.
Collaborate with technical architects, functional consultants, and client technical and functional teams.
Support sales and business development.
Travel periodically based on business and client needs.