Programmer Database Analyst

Description

Job Summary

The Programmer Database Analyst creates and supports data driven library systems through the design, development and implementation of software tools and integration, web application development and programming of library information systems. Works in conjunction with Five College system, campus and library partners to solve technical issues.

Essential Functions

• Provides programming for library information systems; works with Library staff to identify information requirements; designs and programs queries and reports to support library functions; designs and programs updating scripts to allow batch modifications to databases; creates and maintains programs using web and command line Application Programming Interfaces (API); creates and maintains scripts, programming and databases that facilitate exchange of library information between library, campus departments, and other entities.
• Designs, develops, and implements software tools and integrations based on user feedback; prepares test data; troubleshoots technical problems and sees through to resolution; develops and maintains design and troubleshooting documentation; collaborates with team members to improve the library’s tools, systems, and procedures; provides technical support for the library systems; engages with user experience (UX) and web design staff to improve and test user interfaces, specifically for usability and accessibility.
• Communicates with internal and external partners; assists in problem-solving with Five College System Coordinator and other Five College library staff; exports data files to various affiliated organizations.
• Establishes, participates, and maintains relationships with campus and library departments, patrons and subject matter experts in order to remain apprised of direction, project status, architectural and technology trends, risks, and functional/integration issues.
• Participates in the Libraries' assessment program by collecting, recording, and maintaining statistics for monthly reports as needed.

Other Functions

• Attends professional development activities as assigned or required to meet departmental and library goals and objectives.
• Serves on internal library committees as needed.
• Works creatively, collaboratively and effectively to promote teamwork, diversity, equality and inclusively within the Libraries and campus.
• Performs related duties as assigned to meet department, division and university goals and objectives.

Minimum Qualifications (Knowledge, Skills, Abilities, Education, Experience, Certifications, Licensure)

• Bachelor’s Degree in Information Science, Information Technology, Computer Science, Business Information Systems or a related field, OR three (3) years' experience with progressively more responsible systems analysis, programming, web-based applications, and database management.
• Experience with SQL or library automation or Business Intelligence (BI) systems.
• Extensive experience developing web applications using one or more of the following: JavaScript, PHP, Python or Ruby; Windows and UNIX operating systems, and SQL database clients. Familiarity with JSON and XML.

Preferred Qualifications (Knowledge, Skills, Abilities, Education, Experience, Certifications, Licensure)

• Working knowledge of known DevOps tools such as Git, GitHub, or GitLab.
• Experience working on complex issues where analysis of situations or data requires in-depth evaluation of variable factors.
• Exercises judgment in selecting methods, techniques and evaluation criteria for obtaining results consistent with broadly defined policies and practices.
• Capable of constructing and pursuing alternatives toward a solution.
• Experience with frequent communications among inter-organizational and external customer/vendor contacts, especially as part of a team who represents the organization.
• Demonstrated ability to learn new technologies and to stay current with technical developments.
• Ability to deal with ambiguity, change and innovation.
• Strong analytical skills.
• Excellent written and verbal communication skills.
• Demonstrated successful experience with web-based applications.
• Strong commitment to support the teaching and learning mission of the university, and the ability to interact effectively, productively and collaboratively across the Libraries.
• Ability to manage projects, set and adjust priorities, work under pressure, be thorough and accurate, follow tasks through to completion, meet deadlines and work independently.

Physical Demands/Working Conditions

• Typical office environment.

Work Schedule

• Monday - Friday, daytime hours (37.5 hours/week).
• This position has the opportunity for a hybrid work schedule, which is defined by the University as an arrangement where an employee’s work is regularly performed at a location other than the campus workspace for a portion of the week. As this position falls within the Professional Staff Union, it is subject to the terms and conditions of the Professional Staff Union collective bargaining agreement.

Salary Information

Level 26

PSU Salary Ranges

Special Instructions to Applicants

Along with the application, please submit a resume, cover letter, and contact information for three (3) professional references. The search will remain open until filled.

UMass Amherst is committed to a policy of equal opportunity without regard to race, color, religion, gender, gender identity or expression, age, sexual orientation, national origin, ancestry, disability, military status, or genetic information in employment, admission to and participation in academic programs, activities, and services, and the selection of vendors who provide services or products to the University.  To fulfill that policy, UMass Amherst is further committed to a program of affirmative action to eliminate or mitigate artificial barriers and to increase opportunities for the recruitment and advancement of qualified minorities, women, persons with disabilities, and covered veterans.  It is the policy of the UMass Amherst to comply with the applicable federal and state statutes, rules, and regulations concerning equal opportunity and affirmative action.