Migration & Integration Developer
Posted 1hrs ago
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Migration & Integration Developer building SQL migrations and integrations for Attain Partners, a consulting firm serving higher-education clients. Connecting Advancement systems, institutional databases, and Salesforce.
Responsibilities:
- Design, develop, test, and execute SQL-based data migrations and integrations
- Build and maintain data pipelines, transformation logic, staging tables, stored procedures, and integration processes within database environments
- Support data migration and integration initiatives for Higher Education clients, especially Advancement and fundraising systems
- Integrate legacy Advancement platforms, institutional databases, and Salesforce environments
- Collaborate with technical architects, functional consultants, and client stakeholders
- Ensure data accuracy, integrity, and successful delivery of migration and integration solutions
- Support mock migrations, user acceptance testing, cutover, and production deployments
- Troubleshoot data, SQL performance, transformation, and integration issues
- Support sales and business development activities
Requirements:
- Advanced SQL development, 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 Salesforce configuration experience, including standard and custom objects, fields, relationships, validation rules, flows, and data models
- Experience developing SQL-based ETL processes with staging tables, source-to-target mappings, transformations, reconciliation, and incremental data loads
- Experience building and supporting database-driven integrations with scheduled data exchanges, incremental updates, error handling, and monitoring
- Ability to interpret source-to-target mapping specifications and translate business requirements into SQL transformation logic
- Experience with reconciliation queries, duplicate identification, record-count validation, and exception reporting
- Strong knowledge of Microsoft SQL Server, Oracle, or PostgreSQL
- Ability to diagnose and resolve data, SQL performance, transformation, and integration issues independently
- Strong communication skills and ability to work directly with client technical and functional teams
- 5+ years of professional experience in SQL development, database development, data migration, or data integration
- 3+ years supporting Higher Education institutions, preferably within Advancement, fundraising, or alumni relations
- 2+ years of hands-on Salesforce experience, including data model configuration, data loading, and troubleshooting
- Demonstrated completion of at least one enterprise data migration or integration initiative involving a Higher Education Advancement system
- Demonstrated ability to build trusted advisor relationships with clients
- Experience supporting sales and business development
- Flexibility to travel periodically based on business and client needs
- Preferred certifications include Microsoft Azure Database Administrator Associate, Azure Data Engineer Associate, Salesforce Certified Platform Administrator, Salesforce Certified Platform App Builder, Salesforce Certified Data Cloud Consultant, and Oracle Database SQL Certified Associate or equivalent
Benefits:
- Competitive health, dental, and vision coverage
- HSA and FSA accounts
- Life and disability insurance
- Fertility and family planning benefits
- Employee assistance and discount programs
- 11 paid federal holidays
- Flexible unlimited time off (UTO)
- Generous 401(k) matching with immediate vesting
- Flexible career paths with advancement, mobility, and flexibility
- Flexible work environment
- Career growth opportunities
- Inclusive culture and supportive environment
- Annual discretionary bonus eligibility


















