Data Integration Specialist
About The Position
The Data Integrations Specialist is responsible for the development, maintenance, monitoring, troubleshooting, and optimization of data integrations between Ellucian Banner SaaS and the College’s enterprise applications. Reporting to the Manager, Applications and Integrations, this position serves as the primary technical resource for API-based integrations, data exchange processes, SQL development, and data validation activities that support secure and reliable information sharing across institutional systems. The Data Integrations Specialist works closely with the Banner Operations Lead, functional departments, application owners, vendors, and third-party consultants to ensure enterprise data is accurately, securely, and efficiently exchanged between Banner SaaS, Ethos, Slate, Canvas, Microsoft Entra ID, Microsoft 365, TeamDynamix, Power BI, Argos, and other institutional platforms.
Requirements
- SQL development
- API integration experience
- Knowledge of RESTful APIs, JSON, XML, and enterprise integration technologies, including API authentication, data transformation, and secure data exchange methods.
- Knowledge of data governance principles, data stewardship practices, data quality management, source-of-record concepts, and secure data exchange requirements within enterprise higher education systems.
- Understanding of cybersecurity standards and secure application development awareness, analytical and troubleshooting skills.
- Three years of experience supporting integrations, databases, APIs, enterprise applications, and SQL development.
- Experience developing, supporting, and troubleshooting API-based integrations between enterprise applications, including data mapping, transformation, and synchronization activities.
- Experience validating and reconciling data across multiple systems using SQL queries, reports, and automated processes to ensure data accuracy, completeness, and integrity.
- Experience supporting data governance, data quality, security, and compliance initiatives through the implementation of data validation controls, audit processes, and secure data exchange practices.
Nice To Haves
- Experience with Banner SaaS, Ethos.
- Experience managing and maintaining an ODS or Data Warehouse.
- Experience maintaining data integrations with Slate, Canvas, Microsoft 365, Entra ID, Power BI, and Argos.
- Experience in higher education environments.
Responsibilities
- Design, develop, test, implement, document, and maintain API integrations between Ellucian Banner SaaS and enterprise applications.
- Develop and support Ethos Integration workflows and APIs.
- Create and optimize SQL queries, stored procedures, views, and scripts.
- Monitor integration processes and troubleshoot failures.
- Validate data accuracy between source and destination systems.
- Support ODS, Data Warehouse, reporting, and analytics initiatives.
- Maintain integration documentation and technical standards.
- Assist with Banner SaaS upgrades, testing, and vendor changes.
- Support cybersecurity and compliance initiatives.
- Perform other related duties as assigned.
Benefits
- medical, dental, and vision coverage
- short-term disability
- paid holidays and sick leave
- vacation (excluding faculty positions)
- retirement benefits for eligible employees
- college fee waivers
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
