Senior Data Integration Engineer (Remote, ERP Migrations)

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

Job summary

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

The role partners with Admissions, Registrar, Financial Aid, Business Office, and other areas to translate business needs into reliable data integrations and well-architected reporting solutions that drive

Qualifications

• Bachelor's degree preferred in a related field.
• 4+ years experience in application development or integration teams.
• Strong SQL skills with complex queries and performance tuning.
• Experience with REST APIs, ETL/ELT pipelines, and SFTP file exchanges.
• Experience building data warehouses or data marts.
• Proficiency in languages such as C#, PowerShell, Python, JavaScript.
• Excellent problem-solving and communication skills.
• Ability to work independently and in a team.
• Familiarity with Ellucian Colleague, Ethos API, or Data Connect is a plus.

Responsibilities

• Design, build, and maintain integrations between cloud, internal, and external systems using Ethos API, Ellucian Data Connect, and Integration Designer.
• Write functional, high-quality code to integrate cloud-based enterprise applications and internal data sources using ETL tools and languages like C#, .NET, JavaScript, JSON, SQL, and SOQL.
• Develop and support web services using REST and SOAP to enable integration across enterprise systems.
• Transform languages and schemas including XML, XSLT, XSD, and DTD.
• Build and maintain tables, views, stored procedures, and ETL pipelines feeding data lakes, warehouses, and reporting environments in SQL Server/Azure SQL and PostgreSQL.
• Contribute to CI/CD tooling and DevOps practices.
• Support ongoing Colleague SaaS migration, including UAT, environment troubleshooting, log analysis, and remediation of post-migration issues.
• Collaborate with Admissions, Registrar, Financial Aid, Business Office, and others to translate business needs into technical specifications.
• Support federal and institutional compliance reporting pipelines.
• Debug and resolve issues with existing integrations across the enterprise ecosystem.
• Assist with data loading, cleanup, and reconciliation of large record sets across enterprise applications (e.g., HR/payroll reconciliation, user access audits).
• Actively review incidents and defects; coordinate investigation, resolution, and documentation.

Skills

SQL

REST APIs

ETL/ELT pipelines

SFTP file exchange

Data integration

Reporting

Problem solving

Team collaboration

PowerShell

Python

C#/.NET

JavaScript

Education

Bachelor's degree preferred

Tools

Ellucian Colleague

Ethos API

Data Connect

Azure DevOps

Job description

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

The role partners with Admissions, Registrar, Financial Aid, Business Office, and other areas to translate business needs into reliable data integrations and well-architected reporting solutions that drive