Data Integration Specialist

Company Description:

SUNY Schenectady County Community College (SUNY
Schenectady) is one of the State University of New York’s finest two-year colleges located in upstate New York’s vibrant and growing
Capital Region, with easy access to Boston, NYC, the Adirondack and Catskill Mountains, Montreal and scenic Hudson Valley, all of which are
just a few hours away. SUNY Schenectady is a premier college that provides quality, comprehensive education for transfer, career, training,
and workforce development in a student-centered environment, serving students from a wide range of backgrounds. The College offers more than
50 transfer and career programs in science, aviation, culinary, music, and liberal arts, and serves more than 5,000 students. We take pride
in being an urban campus with a small town feel.

Job Description:

SUNY Schenectady County Community College
is seeking a Data Integration Specialist to join their Information Technology team. Reporting to the Chief Information Officer, the Data
Integration Specialist designs, builds, and supports modern integrations across SUNY’s enterprise systems, including Ellucian Banner,
Brightspace, identity and access management, reporting solutions, and document management. The role covers application integrations (REST
APIs, Ethos/Data Connect), data pipelines (e.g., Constituo), and operational scheduling (Ad Astra), along with administration and break/fix
support for core systems such as Banner, Banner Document Management, and Argos. This position ensures secure, reliable, and well-documented
data exchange, adheres to change management best practices, and supports end users with training and troubleshooting.

RESPONSIBILITIES:

Integration Engineering:

• Design, develop, and maintain integrations between Banner,
  LMS, identity platforms, Slate CRM, Ad Astra, Constituo, and other campus systems using RESTful APIs, Ellucian Ethos/Data Connect, and
  scripting (e.g., Python, PowerShell).
• Automate data flows, jobs, and transformations; implement monitoring, alerting, and error
  handling for integration workloads.
• Collaborate on integration architecture, data mapping, and schema design aligned with
  institutional reporting needs.

Application Support & System Administration:

• Provide administration and break/fix
  support for Banner, Banner Document Management, Argos, Laserfiche, and related platforms.
• Perform user account management,
  permissions updates, workflow configuration, and environment maintenance across supported systems.
• Diagnose and resolve
  application-level and system-level issues, coordinating updates, fixes, and upgrades within defined maintenance windows.

Data,
Reporting, and Analytics:

• Write and optimize Oracle SQL/PL/SQL queries and stored procedures; support reporting via Argos or
  comparable tools.
• Partner with functional offices on data validation, reconciliation, and report standards to ensure accuracy and
  auditability.

Security, Compliance, and Governance:

• Ensure integrations comply with FERPA, cybersecurity
  principles, and institutional data handling standards (API security, least privilege, encryption in transit/at rest).
• Follow
  established change management procedures (e.g., ITIL-aligned) for documentation, testing, approvals, and communication.

Platform Operations:

• Plan, test, and implement system patching and upgrades.
• Monitor application performance and
  system availability; address capacity and reliability issues proactively.
• Maintain technical documentation: integration workflows,
  system configurations, SOPs, and runbooks.

Stakeholder Enablement:

• Provide training and responsive end-user support
  for staff and faculty.
• Translate technical concepts into clear guidance for non-technical audiences; contribute to knowledge base
  articles.

Requirements:

Required Qualifications:

• Bachelor’s degree in
  Computer Science, Information Systems, or related field with three or more years in data integration/API development OR an Associate’s
  degree in Computer Science, Information Systems, or related field with five or more years in data integration/API
  development.
• Hands-on experience building and utilizing API integrations and RESTful web services.
• Proficiency in SQL
  (Oracle), PL/SQL, and scripting (Python, PowerShell).
• Experience administering enterprise systems such as Ellucian Banner, Argos,
  Laserfiche, or comparable platforms.
• Strong troubleshooting skills for application and system issues; demonstrated experience with
  reporting tools (e.g., Argos).
• Experience with system patching, change management, and production support
  operations.
• Excellent communication skills; ability to explain technical concepts to non-technical stakeholders.
• Strong
  organizational skills with the ability to manage multiple priorities in a fast-paced environment.

Preferred
Qualifications:

• Prior experience in higher education IT environments.
• Knowledge of Ellucian Ethos, Ellucian
  Experience, Banner Workflow, and Data Connect.
• Familiarity with LMS data models, institutional reporting practices, and
  tools.
• Experience with Ad Astra, Slate CRM, and Constituo integration frameworks.
• Working knowledge of Linux/Unix, cron
  jobs, cPanel; and development with JavaScript, PHP, ReactJS.
• Understanding of cybersecurity principles for data exchange and API
  security; FERPA compliance.

Special Information:

• VISA sponsorship is not available for this
  position
• Offers of employment will be conditional based on the successful completion of a background check and verification of
  official college transcripts

Additional Information:

Salary: $65,000

At SUNY
Schenectady, salary is only one aspect of your compensation package.

Benefits and perks:

As a full-time team
member, you will have access to a competitive benefits package designed to support your health, financial security, professional growth, and
work-life balance:

Comprehensive Health Coverage – Medical, dental, and vision plans to ensure the well-being of you
and your family.

Flexible Retirement Plans – Options to select the retirement system that best aligns with your
goals, plus access to a deferred compensation plan to enhance your long-term savings.

Generous Time Off – Ample
vacation, sick leave, and paid holidays, plus a paid college closure between Christmas and New Year’s Day.

Professional
Growth & Development – Opportunities for continuous learning and career advancement through a variety of professional development
programs.

Family-Friendly Support – Access to on-site childcare providers (subject to availability) to help ease the
demands of balancing work and family life.

Wellness Initiatives – Discounted YMCA memberships and participation in
wellness events to promote physical and mental health.

Application Instructions:

Applications Due
By: Applications accepted until position is filled.

If you need a disability-related accommodation to apply to this
position, please contact the Human Resources Office at (518) 381-1218 or [email protected].

Applicants must submit the following documents to be considered for this
position:

• Cover letter
• Resume
• Completed SUNY Schenectady Employment Application
• References: Please
  provide three professional references which include name, title, and contact information

CAMPUS SAFETY REPORT

The
Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act, or Clery Act, mandates that all Title IV institutions,
without exception, prepare, publish and distribute an Annual Security Report. This report consists of two basic parts: disclosure of the
College’s crime statistics for the past three years; and the availability regarding the College’s current campus security policies. SUNY
Schenectady County Community College’s Annual Security Report is available here.

SUNY Schenectady is an Equal Opportunity
Employer. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United Stated
and to complete the required employment eligibility verification form upon hire.