Systems Integration Analyst

    • Hamilton, NY

Job Category Professional/Administrative
Position Title Systems Integration Analyst
Full Time/Part Time Full Time
Division Dean of the Faculty
Department Information Technology Services - Services and Shared Infrastructure
Department Statement
Colgate Information Technology Services ( ITS ) is a dynamic organization that serves the diverse technology needs of the university community. Comprised of several functional areas - Classrooms, Digital Media & Events; Data Analytics & Decision Support; Engagement & Support; Information Security; Learning & Applied Innovation; Services & Shared Infrastructure - ITS prides itself on exceptional customer service and building collaborative relationships to meet the unique needs of our liberal arts campus. ITS endeavors to foster an inclusive environment that values diversity, professional development, creativity, and innovation to support the growth of individuals and the organization. Under the leadership of the CIO , ITS is embarking on a strategic planning process to align services and resources with several exciting new initiatives identified in Colgate's Third Century Plan.

We seek a collaborative and creative thinker to join the Services and Shared Infrastructure ( SSI ) team to help support our systems integrations and expanding information management systems. The Systems Integration Analyst will be responsible for supporting the Colgate mission by analyzing needs, providing technical guidance, helping with process improvement, and implementing solutions for academic and administrative areas of the university. This position is responsible for optimizing the user experience of assigned software and systems, developing sustainable integrations, developing operational reports, and developing in-house solutions when appropriate. The Systems Integration Analyst's primary accountabilities include becoming knowledgeable in Ellucian Banner, building and supporting integrations with third-party SaaS and other on-premise software solutions.

Accountabilities
Accountable for supporting the Colgate mission by analyzing needs, providing technical guidance, helping with process improvement, and implementing solutions for academic and administrative areas of the university. Accountable for optimizing the user experience of assigned software and systems, developing sustainable integrations, developing operational reports, and developing in-house solutions when appropriate. Primary accountabilities include becoming knowledgeable in Ellucian Banner, building and supporting integrations with third-party SaaS and other on-premise software solutions.
Specific accountabilities include but are not limited to:
-Gather requirements, assess functional needs and provide technical consultation for existing and new processes and systems.
-Research, recommend and implement software solutions as part of a team. Maximize the usefulness and performance of assigned systems and integration points. Deploy new modules, upgrades, and fixes to assigned software applications and systems. Assist in establishing requirements, methods and procedures for routine maintenance.
-Develop custom solutions where necessary and appropriate. Perform testing, including error handling. Develop user guides and training documentation.
-Following generally accepted practices in programming and software development, develop system interfaces and system integrations.
-Participate in the development of contingency plans including reliable backup and restore procedures.
-Design, create and manage database structures in the development, testing, and production environment and monitoring.
-Work with end-users to design and create operational reporting solutions.
-Lead small projects and actively participate in assigned projects. Work with other staff members to meet task deadlines and communicate about the project status.

Technical Competencies

Name Systems Integration
Description
Demonstrates a basic understanding of enterprise systems features and functionality. Ability to execute specific system changes and create systems interfaces as assigned. Troubleshoots basic system issues. Demonstrates a basic understanding of end-user behavior as relates to systems configuration and functionality.

Name Database Administration
Description
Demonstrated coding ability sufficient to contribute to the creation, monitoring and performance of databases. Ability to independently develop relatively simple data structures. Consistently demonstrates ability to follow prescribed development techniques that maximize efficiency and speed of development.

Name Project Management
Description
Demonstrated ability to successfully participate in projects. Demonstrated ability to navigate and consistently add value in a matrixed organization. Consistently meets deadlines and is collaborative with the team.

Name Customer Service
Description
Displays empathy and patience with users of all levels of sophistication. Able to successfully support most users on campus with common issues. Demonstrated ability to consistently follow through with solutions and information for all types of users. Demonstrated ability to diffuse the most challenging situations, remain calm and focused. Demonstrated ability to assess user sophistication and communicate (oral and written) with customers in an appropriate level of detail. Always conveys confidence to the user in ITS ability to solve issues.

Name Programming
Description
Demonstrates ability to research, recommend and implement simple software solutions. Develops relatively simple applications, under supervision. Demonstrates Ability to consistently follow prescribed development techniques that maximize efficiency and speed of development.

Name Report Writing
Description
Demonstrates ability to work with end-users with varying levels of technical ability and create reports that display accurate data from an operational database.

Behavioral Competencies

Name Personal Accountability for Results:
Description
Takes ownership and accountability for decisions, performance and outcomes and behaves in a responsible manner with a positive attitude related to area of responsibility.

Name Effective Communication:
Description
Demonstrates effective written and oral communication skills; communicates clearly and knowledgeably; shares information with others, seeks input from others; adapts communication to diverse audiences; protects private and confidential information.

Name Problem Solving (and Decision Making):
Description
Analyzes and prioritizes situations to identify and solve problems; solutions increase efficiency and improve quality; involves others in solving problems and making decisions; factors organizational goals into decisions; makes clear, transparent, timely decisions.

Name Change Management
Description
Responds positively to changing university initiatives and readily adapts behavior to maintain effective performance; understands the long term direction of the university and can relate this to one's own departmental area; adapts to new methodologies, techniques and process steps for greater impact.

Name Leadership and Teamwork:
Description
Applies skills and knowledge to achieve department and organizational goals; helps others perform at their best; self-aware and open to feedback; adds value; high quality work, understands and supports organizational goals; builds wide sphere of influence to enhance individual and organizational effectiveness; builds productive working relationships; cooperates and collaborates with colleagues; treats others with respect; resolves conflicts among team members; balances individual and team goals.

Name Creativity and Innovation:
Description
Thinks of and encourages new ideas, and is keen to experiment and see ideas implemented; finds new and innovative ways of creating value for the university at the division, department or function level.

Name Diversity and Inclusion:
Description
Demonstrates respect for people and their differences; understands the benefits of a diverse workforce; is trusted and respected by others; includes and welcomes others; works to understand the perspective of others; promotes opportunities to experience diversity on campus.

Name Sustainability:
Description
Understands the impact of personal behavior in achieving the university's commitment to a more fully sustainable and carbon neutral campus. Shows support for the university's sustainability initiatives by personal behavior, and by influencing and encouraging others to use sustainable practices.

Professional Experience/ Qualifications
-One or more years of related professional experience, with an earned Bachelor's Degree in Information Technology or a related degree, or an equivalent additional professional experience in essential duties and responsibilities.
-Basic proficiency in one or more of the following: Oracle (PL/ SQL ), SQL Server, MySQL, or other database technology.
-Basic understanding of object-oriented programming languages such as Java or C#, or other structured programming languages such as Python, PHP , Power Shell, etc.
-Understanding of relational databases and the ability to create and manage database structures as needed for development and troubleshooting.
-Basic understanding of APIs.
-Demonstrated excellence in client contact and strong communication skills.
-Demonstrated understanding of, sensitivity to, and respect for the academic, cultural and social diversity in the Colgate University community.
-All applicants must submit a Diversity Statement as it pertains to this role (see Other Information section).

Preferred Qualifications
-Three to five years or more of related professional experience, with an earned Bachelor's Degree in Information Technology or a related degree, or an equivalent additional professional experience in essential duties and responsibilities .
-Expert programmer with proficiency in one or more of the following: Oracle (PL/ SQL ), SQL Server, MySQL, or other database technology.
-Expert knowledge in object-oriented programming languages such as Java or C#, or other structured programming languages such as Python, PHP , Power Shell, etc.
-Expert knowledge of relational databases and the ability to create and manage database structures as needed for development and troubleshooting.
-Experience with Oracle or SQL Server database administration.
-Experience supporting Ellucian Banner.
-Expert knowledge of APIs.
-Experience in developing web applications with HTML , CSS , and JavaScript.

Education
Bachelor's Degree in Information Technology or a related degree or an equivalent of professional related experience.

Certifications
Physical Requirements
Other Information
Colgate is committed to attracting and retaining a diverse faculty, staff, and student population. We strive to be an inclusive community - one that embraces and values diversity (in the broadest sense possible) in an environment of mutual respect, communication, and engagement. A variety of cultures and perspectives enriches the quality of campus life, and the opportunity to share different views and experiences is at the core of Colgate's educational enterprise. These differences can include, but are not limited to: race; ethnicity; gender and gender expression; sexual orientation; socio-economic status; geographic background; national origin; culture; age; mental, cognitive and physical abilities; religious beliefs; and political beliefs. As a result, we ask all candidates seeking consideration for the Systems Integration Analyst position to submit a diversity statement with their application materials.

To learn more about Colgate University, visit www.colgate.edu.

Requisition Number 2020S008Posting
Temporary No
Work Schedule
The normal schedule is daily, Monday through Friday concurrent with the business hours of the office. Adjustments to the normal schedule to accommodate evening, overnight, weekend and holiday work as required for system and service maintenance and upgrades.

Job Open Date 01/06/2020
Job Close Date
Open Until Filled Yes
Special Instructions Summary
Requirement- Along with your cover letter and resume, please submit a diversity statement as it pertains to this role. You can upload it under the Diversity Statement document heading.

EEO Statement
It is the policy of Colgate University not to discriminate against any employee or applicant for employment on the basis of their race, color, creed, religion, age, sex, pregnancy, national origin, marital status, disability, protected Veterans status, sexual orientation, gender identity or expression, genetic information, being or having been victims of domestic violence or stalking, familial status, or any other categories covered by law. Colgate is an Equal Opportunity/Affirmative Action employer. Candidates from historically underrepresented groups, women, persons with disabilities, and protected veterans are encouraged to apply.

Clery Act
CAMPUS CRIME REPORTING AND STATISTICS
The Campus Safety Department will provide upon request a copy of Colgate's Annual Security and Fire Safety Report. This report includes statistics as reported to the United States Department of Education for the previous three years concerning reported: 1. crimes that occurred on-campus; in certain off-campus buildings or property owned or controlled by Colgate University; and on public property within, or immediately adjacent to and accessible from, the campus and 2. fires that occurred in student housing facilities. The report also includes institutional policies concerning campus security and fire safety, such as policies concerning sexual assault, life safety systems, and other related matters. To obtain a copy, contact the Campus Safety Compliance Manager via e-mail at cusafety@colgate.edu. You may also access the report from the Campus Safety web page at: www.colgate.edu/offices/support/campussafety.

Colgate University is known for its innovative staff, loyal alumni, and world-class faculty.

Colgate University Company Image


Back to top