« Back to all jobs Collections Information Manager

Description:

The Collections Information Manager at the Saint Louis Art Museum ensures the integrity of and access to collections information both inside and outside the museum through the administration of the collections management system.

Responsibilities:

  • Participate in the planning of collection-related projects throughout the Museum, including gathering functional and technical requirements for each project. Promote and support expanded use of TMS for a wider variety of endeavors. Develop and implement strategies for data entry and reporting in support of new initiatives.
  • Support the integrity of collections data by creating tools for users and their supervisors to monitor data quality, ensuring that standards and procedures are followed. Use available tools, such as TMS Audit Trail, TMS Alerts, Crystal Reports, and SQL queries, to perform data-hygiene checks, expose entries which do not meet standards, and perform cleanup as needed.
  • Work closely with colleagues in Digital Assets and Information Technology to ensure that SLAM’s online collections data is mapped from TMS properly and accurately. Collaborate with intradepartmental team to develop new ideas for digital projects, using TMS as the data source.
  • Standardize and document field usage, preferred terminology, and authority controls, including expanded use of Getty Vocabularies and Linked Open Data resources. Manage documentation of data standards for all modules in the collections management system through the administration of Collections Information SharePoint site.
  • Write complex SQL queries and data update scripts; develop custom database objects including views, stored procedures, and functions to improve processes, automate workflows, facilitate ease of reporting, and increase efficiency for data-entry users. Perform batch data updates using SQL scripts and the TMS Object Importer Tool, as appropriate.
  • Manage configuration and security settings, user accounts, and query groups for TMS and suite of related applications. Provide training and support to users; offer supplementary training sessions to all user groups as needed.
  • Manage portfolio of reports and develop ad-hoc reports as needed, using Crystal Reports and PowerBI software. Manage work of report development contractor.
  • Create and manage library of custom forms, alerts and list views using a combination of SQL scripts and the TMS Form Designer and List View Designer applications.
  • Supervise and direct the work of the Collections Database Assistant and Collections Cataloger.
  • Keep abreast of developments and standards in the fields of museum collections management systems, database administration, information management, and related reporting and analytics applications.
  • Serve as primary liaison to Gallery Systems for user concerns. Escalate support requests as needed, report bugs, and submit feature requests.
  • Represent SLAM in TMS user community online and at conferences.

Apply Now