Data Migration & Salesforce Integration Specialist

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 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