Senior Data Integration & ERP API Engineer

Massachusetts College of Pharmacy and Health Sciences; Boston (MA); On-site; USD 138,000 - 156,000; Full time

Job summary

Massachusetts College of Pharmacy and Health Sciences Information Services seeks a Senior Data Integration Developer to support the Ellucian Colleague ERP ecosystem, including Colleague SaaS migration, Ethos API integrations, and reporting infrastructure.

This role partners with Admissions, Registrar, Financial Aid, Business Office, and other units to translate business needs into reliable data integrations and reporting solutions.

Qualifications

• Bachelor's degree preferred.
• Minimum 4 years of experience in application development or integration teams.
• Strong SQL skills, including complex queries, stored procedures, and performance tuning.
• Experience with system integration via REST APIs, ETL/ELT pipelines, and file-based exchange (SFTP).
• Experience designing, building, or supporting data warehouse or data mart solutions.
• Strong problem‑solving skills with data and software applications.
• Detail-oriented and self-starter with strong written and interpersonal skills.
• Ability to work independently, as well as part of a team.
• Proficiency with Microsoft Office Suite, including Word, Excel, and Outlook.

Responsibilities

• Design, build, and maintain integrations across systems using Ethos API, Ellucian Data Connect, and Integration Designer.
• Develop and support SOAP/REST web services for enterprise integrations.
• Create and maintain ETL pipelines feeding data lakes and warehouses (SQL Server/Azure SQL, PostgreSQL).
• Contribute to CI/CD tooling and DevOps practices.
• Support Colleague SaaS migration, including UAT, environment troubleshooting, log analysis, and post-migration fixes.
• Collaborate with Admissions, Registrar, Financial Aid, Business Office to translate needs into specs.
• Assist with data loading, cleanup, and reconciliation of large datasets.

Skills

SQL

REST APIs

ETL/ELT pipelines

Data warehousing

CI/CD pipelines

Data integration

Education

Bachelor's degree preferred

Tools

Ellucian Colleague

Ethos API

Data Connect

Azure DevOps

Job description

Massachusetts College of Pharmacy and Health Sciences Information Services seeks a Senior Data Integration Developer to support the Ellucian Colleague ERP ecosystem, including Colleague SaaS migration, Ethos API integrations, and reporting infrastructure.

This role partners with Admissions, Registrar, Financial Aid, Business Office, and other units to translate business needs into reliable data integrations and reporting solutions.