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/AIndirect Supervisory Responsibility: N/AESSENTIAL 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)
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:

Experience with IPaaSExperience with web technologies such as HTML, CSS, and Java Script Experience  with Powershell and GraphQLKNOWLEDGE, SKILLS, AND ABILITIES

Required:

Proven knowledge of Python, MSSQ, APIs, JSON, and ETL methodologies.

Curiosity and constantly learning.

Excellent problem-solving and analytical skills.

Attention to detail

Strong communication and collaboration skills.

Ability to work independently and as part of a team. Preferred:

Proficiency in other programming languages.

Familiarity with data visualization tools.

Knowledge of agile development methodologies.

WORK ENVIRONMENT All employees are responsible for maintaining an environment that is free from discrimination, intimidation, harassment, including sexual harassment.

This position is considered Non-Essential for the purposes of Emergency Response.

Physical Requirements:

Sitting:
Prolonged periods of sitting at a desk and working on a computer (typically 75% to 100% of the workday).Vision:
Close visual acuity is required to read, write, review code syntax, write SQL queries, and analyze data on dual monitors.

Fingering & Grasping:
Regular use of hands and fingers to type on a keyboard, navigate with a mouse, and operate standard office equipment.

Talking & Hearing:
Ability to…