Senior Data Integration Architect Ellucian Colleague ERP

MCPHS; Boston (MA); On-site; USD 110,000 - 140,000; Full time

Job summary

MCPHS Information Services seeks a Senior Data Integration Developer to support Ellucian Colleague ERP and related SaaS migration efforts. You will translate business needs into reliable data integrations and reporting solutions across Admissions, Registrar, Financial Aid, and Business Office to support strategic decision-making.

Responsibilities include designing integrations, building ETL pipelines, and maintaining reporting infrastructure in SQL Server/Azure SQL and PostgreSQL, while

Qualifications

• Bachelor's degree preferred.
• Minimum 4 years of experience in application development or integration.
• Strong SQL skills including complex queries and performance tuning.
• Experience with REST APIs, ETL/ELT pipelines, and SFTP file exchange.
• Experience designing or supporting data warehouse/data mart solutions.
• Proficiency with .NET/C#, PowerShell, Python, JavaScript, and JQuery.
• Strong problem solving and communication skills.
• Ability to work independently and in a team.
• Proficiency with Microsoft Office Suite.

Responsibilities

• Design, build, and maintain integrations using Ethos API, Ellucian Data Connect, and Integration Designer.
• Develop web services using SOAP/REST for enterprise integration.
• Create and maintain ETL pipelines feeding data lakes and warehouses.
• Collaborate with Admissions, Registrar, Financial Aid, and other units.
• Support Colleague SaaS migration including UAT and troubleshooting.
• Monitor incidents and coordinate resolution.

Skills

SQL

REST APIs

ETL/ELT pipelines

Data warehousing

.NET/C#

PowerShell

Python

JavaScript

JQuery

SFTP

Azure DevOps

Education

Bachelor's degree

Tools

Azure SQL

Job description

MCPHS Information Services seeks a Senior Data Integration Developer to support Ellucian Colleague ERP and related SaaS migration efforts. You will translate business needs into reliable data integrations and reporting solutions across Admissions, Registrar, Financial Aid, and Business Office to support strategic decision-making.

Responsibilities include designing integrations, building ETL pipelines, and maintaining reporting infrastructure in SQL Server/Azure SQL and PostgreSQL, while