The Database Administrator is responsible for managing all data information systems including Altru and The Museum System (TMS) and serves all functional areas with emphasis on Development, Collections, Marketing and Communications, and Visitor Services. In addition, the Data Administrator will develop and run reports and analyze data, manage data entry, data extraction, data quality initiatives, and other data related activities. The Data Administrator will be the lead contact for data analytics, working with key staff to understand data needs and develop actionable insights, as well as improve current practices.
Essential Duties and Responsibilities
- Day-to-day administration of the databases, including the creation of new user accounts, setting permissions for users, developing custom data views, facilitating data entry and queries of the data, and keeping current of necessary software updates.
- Pull data, run reports, and provide data analysis.
- Manage data needs of Development, Collections, Visitor Services/Public Programs, and Education and provide cross-departmental communication of changes.
- Oversee data migration (new data and existing data within the system) and synthesize pre-migration data with current designations and categories.
- Monitor data quality and remove corrupt data and outdated data.
- Prepare departmental reports based on relevant data.
- Configuring fields in the database to more efficiently aid data entry and querying.
- Identify and recommend new ways to capture data and streamline the ticketing and data capture processes.
- Staff members must be able to work with visitors of all ages to support the various events sponsored by the Museum. Each staff member will be expected to work on a minimum of three museum-wide events per year:
- JANM’s Gala Dinner and Auction—(off-site) typically held in the Spring (April-May)
- JANM’s Family Festival Day—Oshogatsu Festival (January)
- JANM’s Family Festival Day—Natsumatsuri Festival (August)
This list is not exhaustive and may be supplemented as necessary. Incumbent will perform related duties as assigned.
Knowledge, Skills, and Abilities
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions outlined above.
Bachelor’s degree in information technology, computer science, informatics, economics, data science, statistics preferred; or an equivalent combination of education and experience.
Minimum of at least 3 years of using Altru and/or Gallery Systems TMS (preferred) or other relational databases experience. Ability to multitask, prioritize, and work independently. Ability to work well under pressure to meet deadlines. Possess excellent organizational skills and be detail oriented. Professional phone manner is essential. Ability to work in a team-environment, be a self-starter. Demonstrate commitment and flexibility at all times in order to ensure high quality service. Ability to adjust and provide appropriate action when unanticipated need arises. Knowledge of Japanese American history and culture a plus.
Has excellent communication and negotiation skills. Ability to make public presentations to various types of audiences including staff, volunteers, community groups, other museum and academic professionals, as well as the general public. Is able to read, write, and comprehend routine reports and correspondence, including safety rules, operating and maintenance instructions, and procedural manuals.
Is Computer literate, comfortable with Google Workspace, MS Word and Excel. Working knowledge of SQL and web-based content management systems a plus. Accuracy and attention to detail are essential.
Ability to calculate figures and amounts such as discounts, interest, proportions, percentages, area, circumference, and volume. Ability to apply concepts of basic algebra and geometry.
Ability to act on own initiative, making consistently sound decisions. Must be able to comply with institutional policies and procedures. Perform successfully when juggling and re-prioritizing multiple assignments in a fast-paced, changing work environment. Is able to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form. Reliable follow-through on assigned projects in a complete, well conceived, and timely manner.
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this job, the employee is regularly required to use hands to finger, handle, or feel objects, tools, or controls. The employee frequently is required to talk or hear. The employee is occasionally required to stand, walk, sit, reach with hands and arms, climb or balance, and stoop, kneel, crouch, or crawl.
The employee must occasionally lift and/or move up to 20 pounds. Specific vision abilities required by this job include close vision, distance vision, and the ability to adjust focus.
The work environment characteristics described here are representative of those the employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
The noise level in the work environment is usually moderate.
The Database Administrator is a temporary, full-time position with funding through June 2024. Please note, however, that this is an at-will position, meaning that your employment may be terminated at any time, with or without notice, and with or without cause. There is, in other words, no guarantee that you be employed until any date in the future, including through June 30, 2024.
Reports To: IT Manager, T. Takenouchi
Positions Supervised: None