Migration & Integration Developer

attainpartners; United States; Remote; USD 120,000 - 130,000; Full time

Benefits offered by this job

Discretionary bonus

Paid holidays

Flexible time off

Retirement match

Job summary

attainpartners is seeking a SQL-focused data migration specialist to build and support database-driven migrations and Salesforce integrations for higher education clients.

You will translate business needs into SQL transformations, validate data movement across legacy platforms, university databases, and Salesforce, and optimize ETL processes for reliability and performance. Strong SQL and Salesforce experience required.

Qualifications

• Strong SQL development skills with complex queries, joins, views, functions, stored procedures and validation scripts.
• Experience with enterprise data initiatives for colleges, universities, or foundations.
• Knowledge of advancement operations (donor, constituent management, fundraising, gift processing, alumni relations).
• Hands-on Salesforce configuration experience and understanding of its data structures.
• Experience building SQL-based ETL and database integrations, including mapping, transformations, reconciliation, and incremental updates.

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.

Skills

SQL development

ETL

Data migrations

Data mapping

Performance tuning

Tools

SQL Server

Oracle

PostgreSQL

Salesforce

Job description

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.