Data Integrations Specialist - Remote

Position Summary

Information Technology Services at Rosalind Franklin University of Medicine and Science invites applications for a full-time Data Integrations Specialist. The University encourages applications from individuals belonging to groups underrepresented in their field and those that can add new and valuable perspectives to the academic environment.

The Data Integrations Specialist will support and grow our enterprise data integrations environment. The position will require a close working relationship with the Data and Integrations team and functional domain subject matter experts. The Data Integrations Specialist will collaborate with other Information Systems teams, software vendors, external consultants, and internal partners to determine business requirements, priorities, define, and develop Data Integrations strategies. The Data Integrations Specialist will be involved in data retrieval via APIs, data integration script building, monitoring, validation, troubleshooting and maintenance. The Data Integration specialist will also be involved with data updates, extracts, and automations, as well as SQL query writing, SSIS package creation and modification, Data Warehouse modifications and maintenance, and SSRS and Power BI report creation and modification.

Interfacing with software vendors will be required to implement new integrations and troubleshoot problems with existing integrations. This position will also need to interface with end-users to suggest and plan data integrations. This position will utilize technologies that are in line with the IT vision of the University to maintain the required data integrations.

Our generous benefits package includes medical, dental, and vision plans; paid parental leave; short term and long term disability plans; life insurance; flexible spending accounts; and a 403(b) retirement plan which includes a 8% employer contribution after 2 years of service. RFUMS is committed to employee wellbeing and work-life balance. Full time staff are eligible for 3 weeks of vacation/ paid leave, 15 sick days, and 13 holidays plus two floating holidays.

This position may be eligible for a remote work arrangement.

Who We Are

The Department of Information Technology Services (ITS) provides students, faculty, and staff with technology resources and support services that foster the mission, vision, and strategic plan of Rosalind Franklin University. Our vision is to be an enabler of innovation and a valued community partner that enhances the education of future health care professionals, assists researchers in the process of scientific discovery, and improves the technology skills of the RFU community.

ITS is responsible for the planning, management, and direction of technology initiatives in support of the academic and administrative operations at RFU. We are committed to developing and maintaining highly effective, reliable, secure information systems that support instructional, administrative and research functions.

ITS is composed of professional staff spread across multiple teams with a common set of skills and ambition, and a desire to collaborate both internally and externally with the RFU community.

Essential Duties & Responsibilities

• Support, develop, monitor and troubleshoot data and systems integration via a combination of APIs and other data retrieval and processing scripting languages.
• Support and develop automated data validation and update procedures
• Support and develop reports and dashboards using SSRS and other BI tools.
• Provide dashboards and reports that show the status of the current state of data integrations
• Create documentation of data integration and automated data update processes
• Design a well-integrated data integration, automation, and validation environment that meets present and future needs.
• Other duties as assigned

Conditions of Employment

• Must achieve satisfactory results from a background check
• Compliance with the current COVID19 vaccination policy

Required Education & Experience

• Bachelor's degree in Computer Science, Engineering or a related scientific or technical discipline.
• Four years of experience performing duties similar to those listed.
• Experience implementing and supporting production data integration systems.
• Experience creating user documentation and providing user training.
• Experience with a variety of automated API, script development and data management tools.
• Experience developing and supporting mission-critical applications.
• Experience creating reports and dashboards.

Required Knowledge, Skills, & Abilities

• Experience developing, troubleshooting and maintaining API data integrations
• Strong interpersonal skills and the ability to effectively communicate with a wide range of individuals and constituencies in a diverse community.
• Working knowledge of Data Integration principles and practices.
• Strong SQL and data extraction skills.
• Experience designing dimensional models.
• Experience with enterprise integration, transaction processing, and transactional business rules.
• Experience with system design and integration tasks, comprising design and implementation of major systems, integration of systems elements, and related support systems.
• Ability to organize, prioritize, and schedule work assignments.
• Ability to explain data integrations to the end-user.

Preferred Qualifications

• Five or more years of experience in a position performing duties similar to those listed is preferred.
• Knowledge of Microsoft SSIS, SSRS and Power BI
• Experience working in a Higher Education environment
• Experience working with Ellucian Colleague ERP/SIS
• Knowledge of PowerShell, Python

Typical Physical Demands & Working Conditions

• Selected candidate must have the mental and physical capabilities to perform the essential functions of the position with or without reasonable accommodations.

EOE, Including Disability / Vets