Job Overview:
The Data Integration Engineer will provide technical support to ensure the reliability, integrity, accessibility, and usability of enterprise applications supporting mission-critical business functions. This role focuses on designing and implementing integrations to connect multiple data sources, platforms, and applications, including ERP, CRM, REST services, and unstructured 
data. The ideal candidate will leverage their expertise in API development, ETL processes, and integration frameworks to create scalable, reusable, and reliable data integration solutions. They will play a critical role in supporting institutional goals through efficient data exchange processes and collaboration with cross-functional teams.
Key Responsibilities:
Design, develop, and unit test ETL and API/Data Service implementations to support seamless integration of enterprise applications.
Create and maintain integrations using tools like Informatica Intelligent Cloud Services (IICS) and API Management platforms.
Develop APIs using Open API Specification, REST/SOAP services, and GraphQL to support data exchange across systems.
Collaborate with data architects on data model and logical interface designs to ensure scalability, quality, and efficiency.
Troubleshoot and resolve technical issues in data integrations, ensuring rapid response to production challenges.
Adhere to data architecture standards, reuse code bases, and create detailed design artifacts to document solution metadata and implementation.
Provide Tier 2 on-call production support for implemented solutions.
Participate in peer design and code reviews to ensure adherence to quality standards.
Work collaboratively with business and IT stakeholders to analyze business requirements and design integration solutions.
Qualifications:
Required Knowledge, Skills, and Abilities:
Extensive experience with Ellucian Ethos API development, Open API Spec Design and Development, and system integrations.
Expertise in Enterprise API (or Web) Services, SQL, and ETL development.
Proficiency in technologies such as PL/SQL, ProC, Unix Shell scripting, XML, JSON, and advanced integration tools (e.g., Informatica CDI/CAI).
Experience with REST/SOAP APIs, Open API Specification, and GraphQL.
Knowledge of secure data transmission and integration techniques.
Strong communication and collaboration skills across technical and non-technical teams.
Proven ability to analyze technical issues effectively and provide innovative solutions.
Ability to define and document integration requirements and design artifacts.
Commitment to customer focus and continuous improvement.
Experience in analyzing, designing, and coding data exchange or integration solutions.
Preferred Skills:
Knowledge of advanced scripting languages like PERL or Node.js.
Java programming experience.
Familiarity with Salesforce CRM integration features.
Knowledge of Agile or SCRUM practices.
Education and Experience:
Bachelor’s degree in Computer Science, Management Information Systems, or a related field (or equivalent combination of education and demonstrable work experience).
Progressively responsible experience in the analysis, design, and implementation of data exchange and application integrations.
Certifications (Preferred):
Agile or SCRUM methodologies.
Salesforce Platform certifications.
Informatica iPaaS certifications
