Collections Information Analyst

Job Purpose

The Collections Information Analyst is responsible for the technical requirements associated with maintaining, troubleshooting, and enhancing Bishop Museum’s collections data and database systems. This position will assist with the centralization, integration, and migration of several collections management databases into a unified framework.

Duties and Responsibilities

• Responsible for the technical administration of the Museum's collections databases, including Axiell’s EMu CMS and other MS SQL platforms.
• Perform an assessment of the current collections management databases across departments (Library, Archives, Anthropology, Ethnology, Registrar, Conservation, Natural Sciences) and help develop a roadmap for integration of databases into a new, centralized framework.
• Develop specifications for system architecture and design of the new framework based on user needs.
• Assist with the migration and standardization of existing collections data from the current systems to the centralized framework.
• Serve as the liaison between staff, IT, and vendors for resolving issues and coordinating further developments and upgrades to the system.
• Maintain systems and provide daily support to ensure high availability for users, manage bug reporting, and troubleshooting of issues.
• Implement quality control checks and reports for data integrity based on various collections metadata standards.
• Work with museum IT to ensure collections database and multimedia servers are working properly and backed up nightly. Coordinate system maintenance schedules with vendor and monitor maintenance reports for issues.
• Create and maintain user accounts and access privileges between individuals, groups, and departments; ensure policies provide record-level security to private and sensitive data.
• Develop and modify Crystal Reports and standardized data exports based on user requirements.
• Document maintenance procedures and system requirements; assist with the creation and updating of training documentation for users.
• Provide database management support and workflow recommendations to collections digitization projects.
• Coordinate, test, and install new releases and upgrades to EMu and other systems.
• Work with the EMu community on standardized database developments.
• Performs other duties, as assigned, to accomplish the goals of the Museum.

Qualifications

• A Bachelor's degree in information systems or a museum-related field with 3-5 years of relevant experience.
• Experience working with Axiell’s EMu CMS and MS SQL preferred.
• Experience working with Crystal Reports required.
• Experience working in a museum setting and knowledge of museum operations, policies, and standards;
• knowledge of data management standards and best practices, collections management, and registration practices preferred.
• Understanding of various collections metadata standards such as MARC, DACS, EAD, CCO, DarwinCore.
• Experience with data manipulation and data analysis tools and procedures, especially R, Python, OpenRefine, or similar.
• Programming experience and an understanding of APIs preferred.
• Experience with Linux/Unix and SQL preferred.
• Familiarity with XML-based information technologies (XSD, XSLT, XPath, XQuery) preferred.
• Interest in learning new skills and keep up with emerging technology.
• Ability to interact and collaborate with developers and end-users.
• Ability to communicate technical concepts clearly in writing and verbally.
• Excellent interpersonal, time management, and organizational skills; ability to work effectively as part of a team and independently.

Visit Job Website