Professional/Administrative

Systems Integration Analyst

Full Time

Dean of the Faculty

Information Technology Services - Services and Shared Infrastructure

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.

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.

Systems Integration

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.

Database Administration

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.

Project Management

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.

Customer Service

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.

Programming

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.

Report Writing

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

Personal Accountability for Results:

Takes ownership and accountability for decisions, performance and outcomes and behaves in a responsible manner with a positive attitude related to area of responsibility.

Effective Communication:

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.

Problem Solving (and Decision Making):

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.

Change Management

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.

Leadership and Teamwork:

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.

Creativity and Innovation:

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.

Diversity and Inclusion:

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.

Sustainability

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.

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

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

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

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; socioeconomic 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.

You can upload the statement under the Diversity Statement document heading.

A diversity statement may be any length (e.g. a short paragraph, a page) explaining your experiences, contributions, and/or commitments related to diversity, equity, and inclusion. Examples of topics you may discuss include (but are not limited to): 1) how your experiences or competencies might serve to advance the university’s commitment to creating a diverse and inclusive campus, 2) your experiences working with diverse populations, or 3) how you will contribute to the university’s strategic initiatives in this area (see Colgate’s Diversity, Equity, and Inclusion Plan).

For information on how to write a diversity statement, see our Guidance on Crafting Diversity Statements.

2021S053Posting

No

Weekdays

07/01/2021

Yes

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.

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.