Migration & Integration Developer

attainpartners; United States; On-site; USD 95,000 - 135,000; Full time

Job summary

Attain Partners is seeking an experienced Migration & Integration Developer to support data migration and integration initiatives for Higher Education clients, with a focus on Advancement and fundraising systems. The role emphasizes SQL-based migrations, data transformations, and direct database integration rather than middleware platforms.

The candidate should have deep SQL development expertise, Salesforce configuration experience, and strong understanding of Higher Education Advancement data

Qualifications

• Advanced SQL development: complex queries, stored procedures, views, functions, joins, transformations, data validation scripts.
• Higher education experience: colleges/universities or foundations on data initiatives.
• Advancement domain knowledge: fundraising, donor management, gifts, alumni relations, constituent management.
• Salesforce configuration: objects, fields, relationships, validation rules, flows, data models.
• SQL-based ETL: staging tables, mappings, data transformations, reconciliation, incremental loads.
• SQL-based data integration: scheduled exchanges, incremental updates, error handling, monitoring.
• Data mapping & transformation: translate mappings into SQL logic.
• Data quality & validation: reconciliation queries, duplicates, record-count validation, exceptions.
• Database expertise: SQL Server, Oracle, PostgreSQL.
• Troubleshooting: diagnose data, performance, transformation issues.
• Client collaboration: work with client teams.

Responsibilities

• Design, develop, test, and implement SQL-based data migrations.
• Build and maintain data pipelines, transformation logic, and staging tables.
• Develop and support database-driven data integrations and ETL processes.
• Interpret source-to-target mappings and translate into executable SQL logic.
• Coordinate with architects, consultants, and stakeholders to ensure data accuracy.

Skills

Advanced SQL Development

Higher Education Experience

Advancement Domain Knowledge

Salesforce Configuration

SQL-Based Data Migration

SQL-Based Data Integration

Data Mapping & Transformation

Data Quality & Validation

Database Expertise

Troubleshooting

Client Collaboration

Job description

Attain Partners is an innovative consulting firm dedicated to disrupting the status quo to change the world and improve the lives of those we touch. From strategy to technology and ever y where in between, our experts use their unique skills to advance the important missions of education, nonprofit, healthcare, and state and local government clients.

People are at the center of all we do, and that's why we empower career growth, provide industry-leading benefits packages, encourage a flexible work environment, and foster a culture of inclusion to support the needs of our team. We share a collective passion for our mission and our people. Guided by our seven core values, The Attain Way, our vision is the foundation of our culture-to be and attain the best.

Attain Partners is seeking an experienced Migration & Integration Developer to support data migration and integration initiatives for Higher Education clients, with a strong emphasis on Advancement and fundraising systems. This role is responsible for designing, developing, testing, and executing SQL-based data migrations and integrations between legacy Advancement platforms, institutional databases, and Salesforce environments. The ideal candidate has deep SQL development expertise, hands-on Salesforce configuration experience, and a strong understanding of Higher Education Advancement data, business processes, and system architecture. All migration and integration development will be performed primarily using SQL and database-native technologies, rather than integration platforms such as MuleSoft or Boomi. Candidates must be comfortable building and maintaining data pipelines, transformation logic, staging tables, stored procedures, and integration processes directly within database environments. The developer will collaborate with technical architects, functional consultants, and client stakeholders to ensure data accuracy, integrity, and successful delivery of migration and integration solutions.

Required Skills

• Advanced SQL Development: Strong hands-on experience writing complex SQL queries, stored procedures, views, functions, joins, transformations, and data validation scripts.
• Higher Education Experience: Previous experience working with colleges, universities, or university foundations on enterprise data initiatives.
• Advancement Domain Knowledge: Strong understanding of fundraising, donor management, gift processing, alumni relations, constituent management, and Advancement business processes.
• Salesforce Configuration: Hands-on experience navigating and configuring Salesforce, including standard and custom objects, fields, relationships, validation rules, flows, and data models.
• SQL-Based Data Migration: Experience developing extract, transform, and load (ETL) processes using SQL, including staging tables, source-to-target mappings, data transformations, reconciliation, and incremental data loads.
• SQL-Based Data Integration: Experience building and supporting database-driven integrations, including scheduled data exchanges, incremental updates, error handling, and monitoring.
• Data Mapping & Transformation: Ability to interpret source-to-target mapping specifications and translate business requirements into executable SQL transformation logic.
• Data Quality & Validation: Experience developing reconciliation queries, duplicate identification logic, record-count validation, and exception reporting.
• Database Expertise: Strong working knowledge of relational database technologies, including Microsoft SQL Server, Oracle, or PostgreSQL.
• Troubleshooting: Ability to independently diagnose and resolve data, SQL performance, transformation, and integration issues.
• Client Collaboration: Strong communication skills and ability to work directly with client technical and functional teams.

Desired Skills

• 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.
• Years of Experienc