Migration & Integration Developer
Attainpartners · United States - Remote
About this role
## Migration & Integration Developer Attain Partners is seeking an experienced **Migration & Integration Developer** to support **data migration and integration** initiatives for **Higher Education** clients—especially around **Advancement and fundraising systems**. In this role, you will design, develop, test, and execute **SQL-based data migrations and integrations** between **legacy Advancement platforms**, **institutional databases**, and **Salesforce** environments. Work is performed primarily using **SQL and database-native technologies** (not middleware tools like MuleSoft or Boomi). You’ll build and maintain **data pipelines**, **transformation logic**, **staging tables**, **stored procedures**, and **integration processes** directly within database environments. You’ll collaborate with **technical architects**, **functional consultants**, and **client stakeholders** to ensure **data accuracy**, **integrity**, and successful delivery. --- ### Required Skills - **Advanced SQL Development:** Complex SQL queries, stored procedures, views/functions, joins, transformations, and data validation scripts. - **Higher Education Experience:** Experience with colleges/universities/university foundations on enterprise data initiatives. - **Advancement Domain Knowledge:** Fundraising, donor management, gift processing, alumni relations, constituent management, and Advancement business processes. - **Salesforce Configuration:** Standard/custom objects, fields, relationships, validation rules, flows, and data models. - **SQL-Based Data Migration:** ETL using SQL (staging tables, source-to-target mappings, transformations, reconciliation, incremental loads). - **SQL-Based Data Integration:** Database-driven integrations (scheduled exchanges, incremental updates, error handling, monitoring). - **Data Mapping & Transformation:** Translate mapping specs and business requirements into executable SQL. - **Data Quality & Validation:** Reconciliation queries, duplicate identification logic, record-count validation, exception reporting. - **Database Expertise:** Relational databases such as **Microsoft SQL Server**, **Oracle**, or **PostgreSQL**. - **Troubleshooting:** Diagnose and resolve data, SQL performance, transformation, and integration issues. - **Client Collaboration:** Communicate effectively with client technical and functional teams. ### Desired Skills - Experience with Higher Education Advancement platforms (e.g., Ellucian Advance, Kindsight ascend, Blackbaud CRM/Raiser’s Edge, Banner Advancement, Salesforce Education Cloud). - Familiarity with Advancement data structures (constituents, households, relationships, gifts, pledges, payments, designations, campaigns, recognition credits). - Experience migrating legacy Advancement platforms to Salesforce or Kindsight ascend. - Salesforce Data Loader, Bulk API, and import/export processes. - Salesforce SOQL and object relationships. - Experience with SSIS / SQL Server Agent (or equivalent scheduling technologies). - Reusable SQL scripts, migration frameworks, and automated validation. - Data governance/stewardship, data quality, and master data management principles. - Support for mock migrations, UAT, cutover, and production deployments. - Git (or other source control) for managing SQL development. ### Years of Experience - **5+ years** professional experience in SQL development, database development, data migration, or data integration. - **3+ years** supporting Higher Education institut
Listing freshness
CronJobs last confirmed this listing 1h ago. If its source stops confirming the opening for seven days, this page is removed from active inventory.