Integration Analyst

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.

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)  

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 IPaaS
• Experience with web technologies such as HTML, CSS, and JavaScript
• Experience with Powershell and GraphQL
   

KNOWLEDGE, 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.
   

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.

• 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 communicate clearly and exchange accurate information during team meetings, video calls, or when gathering system requirements.

• Lifting: Infrequent, light physical effort. May need to lift up to 10 to 15 pounds occasionally (e.g., carrying a laptop, notebooks, or light office supplies).
• Mobility: Occasional walking, standing, bending, or reaching to move around the office or attend meetings.

• Environment: Typically an indoor, climate-controlled open-office setting or a dedicated home-office environment. Noise levels are generally quiet to moderate.
• Cognitive Load: High mental stamina is required for extended troubleshooting, logical problem-solving, and managing complex ETL pipelines.

None

Monday - Friday, 8:00am-4:30pm

All new hires and employees transferring into a new position will have a 90-day probationary period within which to learn the functions of the job and to be evaluated. Following the probationary period, the employee can transition to regular status, have the probationary period extended in order to receive more training, or employment can be terminated. Required compliance training is as follows:

All new hires and employees transferring into a new position will have a 90-day probationary period within which to learn the functions of the job and to be evaluated. Following the probationary period, the employee can transition to regular status, have the probationary period extended in order to receive more training, or employment can be terminated.

• SEU promotes a safe working environment. Employees are responsible for completing assigned tasks safely and efficiently, and supervisors are responsible for creating and maintaining a safe work environment. 
• Employees must report any unsafe work conditions or practices, as well as any near-miss incidents, to their supervisor and Risk Management. 
• Work-related injuries must be immediately reported to Security and Human Resources. When life or limb are at risk, please dial 911. Supervisors and employees should ensure that injury/accident reports are submitted to the Office of Human Resources within 24 hours of the incident. 
• Emergency Employees report for or must remain at work in emergency situations.  Dismissal or closure announcements do not apply to this position, unless instructed otherwise by your direct supervisor or a member of the Leadership Team.  

All full-time positions at SEU are deemed security-sensitive and require background checks. Employees required to drive their own personal vehicle, a rental car or an SEU vehicle in performance of their duties must pass an MVR records check and meet the requirements of the University’s insurance carrier in order to meet the requirements of the position.

SEU is an at-will employer.  This job description does not constitute an employment agreement between the employer and employee and is subject to change by the employer as the needs of the employer and requirements of the job change. The employer retains the right to change or assign other duties to this position.

The employee must be able to perform the essential functions of the position satisfactorily and, if requested, reasonable accommodations will be made to enable employees with disabilities to perform the essential functions of their job, absent undue hardship.

SEU is committed to providing a workplace that is free from unlawful discrimination and harassment. All forms of discrimination against or harassment of a person because of his or her identification within a protected category are strictly prohibited and will not be tolerated. This prohibition applies equally to conduct by and against employees, vendors, visitors, and students.