Senior Data Integration Developer

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

Information Services seeks a Senior Data Integration Developer to support and extend our Ellucian Colleague ERP ecosystem, including the ongoing Colleague SaaS migration, Ethos API integrations, and institutional reporting infrastructure. This role partners directly with stakeholders across Admissions, Registrar, Financial Aid, Business Office, and other business areas to translate business needs into reliable, well-architected data integrations and reporting solutions that support tactical and strategic decision-making across the university.

Application Development (40%)

• Design, build, and maintain integrations between various cloud, internal, and external systems using an appropriate framework, such as developing custom built services/applications, or using Ethos API, Ellucian Data Connect, and Integration Designer.
• Develop and support web services using both Simple Object Access Protocol (SOAP) and Representational State Transfer (REST) protocols to enable integration across enterprise systems.
• Experience transforming languages and schemas, including XML, XSLT, XSD, and DTD.
• Build and maintain tables, views, stored procedures, and ETL pipelines feeding data lakes, warehouses, and other institutional reporting environments in SQL Server/Azure SQL and PostgreSQL environments.
• Contribute to CI/CD tooling and DevOps practices supporting the development lifecycle.

Application Support (40%)

• Support the ongoing Colleague SaaS migration, including UAT, environment troubleshooting, log analysis, and remediation of post-migration integration issues.
• Collaborate with stakeholders from Admissions, Registrar, Financial Aid, Business Office, and other business units to understand business needs and translate them into technical specifications for integrations and reporting solutions.
• 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 and monitor reported incidents and defects; coordinate investigation, resolution, and documentation of results.

General (20%)

• Incorporate new data requirements, source systems, and reporting needs into existing data lake and warehouse environments.
• Use subject matter expertise to guide decisions on data modeling, data sourcing, data quality, and delivery approach.
• Perform complex data analysis to produce clear, well-documented data definitions.
• Maintain current knowledge of Ellucian, Salesforce, and Blackboard ecosystem developments, higher‑ed data standards, and integration best practices.

Requirements

Required:

• Bachelor's degree preferred
• Minimum 4 years of experience working in application development or integration teams
• Strong SQL skills, including complex queries, stored procedures, and performance tuning (SQL Server/Azure SQL)
• 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

Preferred:

• Experience with Ellucian Colleague, Ethos API, or Data Connect (or comparable higher‑ed ERP experience, e.g., Banner, PeopleSoft)
• Familiarity with higher‑ed compliance reporting (IPEDS, FISAP, Title IV)
• Experience with Azure DevOps, CI/CD pipelines, or version control workflows

Physical Requirements

• Standing, sitting, manual dexterity, ability to move between offices and floors of buildings.
• Ability to meet deadlines and perform well under pressure.
• Ability to be physically in attendance at designated worksite during scheduled work hours and to work some evenings and weekends.
• Normal range of vision and hearing (with or without correction).
• Ability to lift up to 5-10 lbs.

Stipend

N/A

About Us

Applicants must be authorized to work for any employer in the U.S. MCPHS is unable to sponsor, or take over sponsorship of an employment Visa. MCPHS is also not an E-Verify institution.

About Us
Established in 1823, Massachusetts College of Pharmacy and Health Sciences (MCPHS) is the oldest institution of higher education in Boston, a city that is home to many of the world's top universities and healthcare institutions. We are one of the largest and most highly‑ranked schools for health and life sciences, and our alumni and faculty continually distinguish themselves in healthcare settings around the globe.

MCPHS has more than 7000 students across campuses in Boston's Longwood Medical and Academic Area (LMA), downtown Worcester, MA and downtown Manchester, NH.

Our vision is to empower our Community to create a healthier, more equitable world, which we strive to achieve through our core values of integrity, community, engagement, collaboration, support, and innovation.

We offer competitive salaries and excellent benefits that include a substantial contribution toward the cost of medical, vision, and dental insurance, generous time off, retirement and pension plans, and flexible work arrangements to support work/life balance for our employees while supporting the MCPHS strategic plan .

MCPHS is an equal opportunity employer dedicated to ensuring equal opportunity for all members of the University community. We aim to recruit, develop, and retain the most skilled faculty and staff. All qualified applicants will be considered for employment.

Pay Range

The estimated pay range for this job. Disclosing pay information promotes competitive and equitable pay.

The actual pay rate will depend on the person's qualifications and experience.

$137,800.00 - $155,700.00 / year

Pay Transparency

The pay range associated with this posting reflects the amount the University reasonably expects to pay for this role at this time. Salary offers are determined based on experience, skills, and qualifications as well as internal equity, market data, and pay in comparison to similarly situated employees doing comparable work.

Work and Life

Employer Privacy Policy

EEO is the Law

ADP Privacy Statement Artificial Intelligence Google Privacy Policy Google Terms of Service