Data Integration Engineer

Position Outline: Data Integration Engineer (Developer)

Job Title: Data Integration Engineer

Reports To: Integration Team Manager

Location: Remote

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 Banner ERP, Salesforce CRM, REST services, and unstructured data. Position requires experience with Salesforce (CRM) and Ellucian Banner integrations.

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.

• Provide Tier 2 on-call production support for implemented solutions.

Qualifications:

Required Knowledge, Skills, and Abilities:

• Position requires experience with Salesforce (CRM) and Ellucian Banner integrations.

• Extensive experience with Ellucian Ethos API development, Open API Spec Design and Development, and system integrations.

• Proficiency in technologies such as PL/SQL, Pro C, 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.

• Ability to define and document integration requirements and design artifacts.

Preferred Skills:

• Knowledge of advanced scripting languages like PERL or Node.js.

• Java programming experience.

• 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.