Integration Analyst

JOB SUMMARY

The Integration Analyst will be responsible for developing and maintaining integrations between various systems using Python, MSSQL, APIs, and SFTP. The ideal candidate will have a strong background in data validation and ETL (Extract, Transform, Load) methodologies. Proficiency in other programming languages is a plus.

ORGANIZATIONAL RELATIONSHIPS

Reports to: Executive Director of Enterprise Services

Supervisory Responsibility: N/A

Indirect Supervisory Responsibility: N/A

ESSENTIAL DUTIES - May include, but is not limited to the following:

- Develop, test, and maintain integration solutions between various systems and platforms.
- Work with APIs, SFTP, SQL, CSV, and JSON to connect and transfer data between systems.
- Utilize Python and MSSQL to develop and manage data integration processes.
- Implement and manage ETL methodologies to ensure data accuracy and consistency.
- Conduct data validation to ensure data integrity and quality.
- Collaborate with cross-functional teams to gather integration requirements and deliver solutions.
- Troubleshoot and resolve integration issues in a timely manner.
- Document integration processes, procedures, and solutions.

ADDITIONAL/NON-ESSENTIAL DUTIES

{{Additional/Non-Essential Duties - in the context of ADA - the functions could be assigned to another individual, or adjusted, to allow a disabled person to hold the position}}

All remaining duties are considered "nonessential" within the context of the ADA, which means that the function could be reassigned to another employee in order to allow a disabled individual to hold the position. Alternatively, the manager could try to provide a reasonable accommodation so that the disabled individual could perform the function.

LOCATION

Main Campus Hybrid (some remote, some main campus, and/or some other physical location)

Qualifications

EDUCATION

Required Education:

Bachelor's degree in Computer Science or other related field; or Associate’s degree with equivalent experience and/or preferred certification as an alternative credential.

Preferred Education:

Master's degree in Computer Science or other related field

LICENSES/CERTIFICATIONS

Preferred:

PCPP (Certified Professional in Python Programming)

PCEP/PCAP (Certified Associate)

Microsoft Certified: Azure Database Administrator Associate

AWS Certified Developer – Associate

EXPERIENCE

Required:

• 3-5 years experience with integrations or similar technologies.
• Proven experience in Python and MSSQL.
• Experience with data validation and ETL methodologies.
  

Preferred: