Senior Data Integration Architect – Ellucian ERP & API

re-zoo-me; Boston (MA); Hybrid; USD 110,000 - 150,000; Full time

Job summary

Massachusetts College of Pharmacy and Health Sciences seeks a Senior Data Integration Developer to extend the Ellucian Colleague ERP ecosystem, migrate Colleague SaaS, and implement Ethos API integrations for institutional reporting.

You will partner 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 in application development or integration teams.
• Strong SQL skills including complex queries and performance tuning.
• Experience with REST APIs, ETL/ELT pipelines, and SFTP file-based exchange.
• Experience designing or supporting data warehouse or data marts.

Responsibilities

• Design, build, and maintain integrations between cloud, internal, and external systems using Ethos API, Ellucian Data Connect, and Integration Designer.
• Develop code to integrate enterprise apps using ETL tools and languages like C#, .NET, JavaScript, JSON, SQL, and SOQL.
• Build and support web services (SOAP/REST) for cross-system integrations.
• Transform languages/schemas (XML, XSLT, XSD, DTD) and manage data pipelines in SQL Server/Azure SQL and PostgreSQL.
• Support data lakes, warehouses, and reporting environments; contribute to CI/CD and DevOps practices.

Skills

SQL

REST APIs

ETL/ELT

Data warehousing

C#/.NET

PowerShell

Python

JavaScript

JQuery

SFTP

Microsoft Office

Education

Bachelor's degree

Tools

Ellucian Colleague

Ethos API

Data Connect

Azure DevOps

Job description

Massachusetts College of Pharmacy and Health Sciences seeks a Senior Data Integration Developer to extend the Ellucian Colleague ERP ecosystem, migrate Colleague SaaS, and implement Ethos API integrations for institutional reporting.

You will partner with Admissions, Registrar, Financial Aid, Business Office, and other units to translate business needs into reliable data integrations and reporting solutions.