Senior Data Integration Architect — ERP & SaaS Reporting

Massachusetts College of Pharmacy and Health Sciences; Boston (MA); On-site; USD 110,000 - 150,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. You will partner with Admissions, Registrar, Financial Aid, and Business Office to translate needs into reliable data integrations and analytics.

You will design, build, and maintain integration services, develop web services (SOAP/REST),

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 (SQL Server/Azure SQL).
• Experience with 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 (Word, Excel, Outlook).

Responsibilities

• Design, build, and maintain integrations between cloud, internal, and external systems using Ethos API, Ellucian Data Connect, and Integration Designer.
• Develop and support web services using SOAP and REST to enable integration across enterprise systems.
• Transform languages and schemas, including XML, XSLT, and XSD.
• Build and maintain SQL tables, views, stored procedures, and ETL pipelines feeding data lakes and warehouses.
• Contribute to CI/CD tooling and DevOps practices supporting the development lifecycle.
• Support the ongoing Colleague SaaS migration, including UAT, troubleshooting, and issue remediation.
• Collaborate with Admissions, Registrar, Financial Aid, Business Office, and other units to translate needs into technical specs.
• 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.

Skills

SQL

REST APIs

ETL/ELT pipelines

Data warehouse

CI/CD tooling

XML/XSLT/XSD

Education

Bachelor's degree

Tools

Ellucian Colleague

Ethos API

Data Connect

Integration Designer

Azure DevOps

SQL Server/Azure SQL

PostgreSQL

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. You will partner with Admissions, Registrar, Financial Aid, and Business Office to translate needs into reliable data integrations and analytics.

You will design, build, and maintain integration services, develop web services (SOAP/REST),