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., 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., All employees are responsible for maintaining an environment that is free from discrimination, intimidation, harassment, including sexual harassment., * 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., * 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.

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), * 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. *