A

Attain Partners

Education and nonprofit consultancy

Migration & Integration Developer - Higher Education / Advancement

Data EngineeringConfirmed live in the last 24 hours
Full-timeRemote in USA

About the Job

Requirements

  • Advanced hands-on experience writing complex SQL 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 experience navigating and configuring Salesforce, including standard and custom objects, fields, relationships, validation rules, flows, and data models.
  • Experience developing SQL-based extract, transform, and load (ETL) processes, including staging tables, source-to-target mappings, data transformations, reconciliation, and incremental data loads.
  • Experience building and supporting database-driven integrations, including scheduled data exchanges, incremental updates, error handling, and monitoring.
  • Ability to interpret source-to-target mapping specifications and translate business requirements into executable SQL transformation logic.
  • Experience developing reconciliation queries, duplicate identification logic, record-count validation, and exception reporting.
  • Strong working knowledge of relational database technologies, including Microsoft SQL Server, Oracle, or PostgreSQL.
  • Ability to independently diagnose and resolve data, SQL performance, transformation, and integration issues.
  • Ability to work directly with client technical and functional teams.
  • At least 5 years of professional experience in SQL development, database development, data migration, or data integration.
  • At least 3 years of experience supporting higher education institutions, preferably within Advancement, fundraising, or alumni relations.
  • At least 2 years of hands-on Salesforce experience, including data model configuration, data loading, and troubleshooting.
  • Demonstrated experience completing 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.

Responsibilities

  • Design, develop, test, and execute SQL-based data migrations and integrations between legacy Advancement platforms, institutional databases, and Salesforce environments.
  • Build and maintain data pipelines, transformation logic, staging tables, stored procedures, and integration processes directly within database environments.
  • Collaborate with technical architects, functional consultants, and client stakeholders to ensure data accuracy, integrity, and successful delivery of migration and integration solutions.

Desired Qualifications

  • 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.
  • Microsoft Certified: Azure Database Administrator Associate or Azure Data Engineer Associate certification.
  • Salesforce Certified Platform Administrator certification.
  • Salesforce Certified Platform App Builder certification.
  • Salesforce Certified Data Cloud Consultant certification.
  • Oracle Database SQL Certified Associate or equivalent database certification.

About the Company

Attain Partners

Education and nonprofit consultancy

Attain Partners is a management and technology consulting firm serving mission-driven organizations. The company provides strategy, organizational transformation, research administration, enterprise technology, data, and implementation services. It serves higher-education institutions, nonprofits, public-sector organizations, and commercial partners. Its operating model centers on consulting teams combining sector expertise with technology platforms and program delivery. Teams work across strategy, change management, Salesforce, data, research administration, project management, and client service. The business combines technical knowledge, practical execution, and ongoing support across the markets it serves.

Company size
Not listed
Company stage
Not listed
Total funding
Not listed
Headquarters
McLean, VA
Founded
2021

Recently Posted Jobs

Explore more opportunities at Attain Partners

See more jobs