Migration & Integration Developer

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

Additional Requirements

• Demonstrated ability to build trusted advisor relationships with clients
• Experience supporting sales and business development
• Position requires flexibility to travel periodically based on business and client needs
• Additional Information
• Attain Partners values your mental, emotional, and physical health and wellbeing. Our comprehensive benefits package starts on your first day of employment and includes benefits such as:
• Competitive health, dental, and vision coverage, HSA and FSA accounts, life and disability insurance, fertility and family planning benefits, and employee assistance and discount programs
• 11 paid federal holidays and flexible unlimited time off (UTO)
• Generous 401(k) matching with immediate vesting
• Flexible career paths – our career tracks provide advancement, mobility, and flexibility as you continue to grow with us
• A healthy environment where we value unique experiences, and care about everything that makes you, you.
• Attain Partners is committed to fair and equitable compensation practices. The individual base salary for this position is unique to each candidate and will be commensurate with experience, education, and skills. In addition to base salary, this role is eligible for an annual discretionary bonus.
• Interested in this position but the compensation isn’t quite right? Let us know your expectations, and we’ll see if we can make it happen based on your qualifications.
• Salary Range
• $120,000 — $130,000 USD
• Attain Partners is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to sex, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.
• Applicants have rights under Federal Employment Laws. For more Information visit EEO, EEO Poster Supplement, Family and Medical Leave Act (FMLA), and Employee Polygraph Protection Act (EPPA).
• If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.
• 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.
• 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 Experience
• 5+ years of professional experience in SQL development, database development, data migration, or data integration.
• 3+ years of experience 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 experience completing at least one enterprise data migration or integration initiative involving a Higher Education Advancement system.
• Microsoft Certified: Azure Database Administrator Associate or Azure Data Engineer Associate
• Salesforce Certified Platform Administrator
• Salesforce Certified Platform App Builder
• Salesforce Certified Data Cloud Consultant
• Oracle Database SQL Certified Associate or equivalent database certification

Preferred Qualifications

• Desired Skills
• Certifications (Preferred but not required)
• Attain Partners is committed to fair and equitable compensation practices. The individual base salary for this position is unique to each candidate and will be commensurate with experience, education, and skills. In addition to base salary, this role is eligible for an annual discretionary bonus.