Database and Data Integrity Manager

Wanted! Looking for eager individuals who are willing to be trained and gain experience in a great museum! We are willing to help anyone who might not have every qualification as long as they have a great attitude joining our team!! To apply to the job listed below, please click the following link!

https://marinersmuseum.atsondemand.com/index.cfm?

Purpose:

Reporting to the Data Analyst, the Database & Data Integrity Manager is a key member of the Technology department that ensures data integrity and proper use of all patron and donor databases at the museum.  These databases contain tens of thousands of records and support the success of the several departments, primarily Visitor Services and Development. This is a critical role that ensures continuity of the museum’s business and enforces best-practices with respect to data records management. Maintaining reliable, accurate, and consistent data is also crucial to efforts by the Data Analyst to perform analysis, forecasting, and reporting to help the museum make informed business decisions.

The Database & Data Integrity Manager is primarily responsible for the integrity of patron data records and the oversight of point-of-sale and patron database systems. These systems contain sales and donor records, financial reports and queries, and donor and member communications. His/her position makes sure those systems are configured optimally and that staff are trained to use them properly and enter all data correctly, according to documented standards and procedures.  Records not conforming to standards (e.g., missing information, incorrect formats, misspellings, etc.) need to be cleaned and corrected on an on-going basis to ensure data integrity.

The primary system and database of use, where he/she works extensively, is Altru by Blackbaud, a company-wide, browser-based system used by dozens of staff for everything from ticket sales to donor prospecting. He/she serves as the main point of contact for questions or problems with the use of Altru and is the lead Altru trainer for system users. He/she also stays involved in the online Altru community discussion board to contribute to the body of knowledge regarding Altru’s best-practices (e.g., providing questions and answers). He/she also works collaboratively with other department managers to monitor and ensure the integrity of patron data going into other CRM and POS systems, such as BBMS web payment terminal (Accounting), MailChimp email communications (Marketing), Lightspeed POS (Visitor Services), Volgistics (Volunteers), and our Redframe photography site (Digital Services).

He/she creates, maintains, and distributes written Altru and patron database policies and procedures based on museum and industry best practices and compliance demands. Working with other staff, he/she helps create, update, and deliver queries, metrics, reports, visuals, and other reporting tools.

The Database & Data Integrity Manager is accountable as the lead expert for answering questions about the museum’s database systems and importing and exporting data for reporting purposes. He/she needs to stay current on vendor-installed updates and upgrades and inform and train staff as needed when new features are released. He/she also needs to know how the museum’s other POS and CRM systems are used and provide support and training as needed. He/she is personally responsible for the monitoring and maintenance of data integrity and conducts regular audits to report errors or inconsistencies and leads clean up efforts. He/she handles the security of the database systems including adding and removing users, assigning permissions/roles, and monitoring appropriate use.

Duties:

  • Works from a perspective of support and service
  • Is a key member of the team that bridges user needs with system capabilities for reporting
  • Helps frontline gift officers with complex and intricate reporting and data needs using Altru
  • Implements a plan to proactively audit and monitor integrity of data across constituent systems with a focus on Altru
  • Advises departments on opportunities to make improvements and modifications
  • Drives ongoing refinements to data integrity in Altru, including large and small-scale clean up and maintenance projects, in keeping with best practices and in response to evolving user needs
  • Leads training and documentation for CRM users
  • Helps the Data Analyst design, build and maintain reports, dashboards, and other strategic information portals for Museum teams
  • Resolves daily issues pertaining to functions within Altru
  • Identifies opportunities to streamline departmental processes and procedures
  • Updates accounting GL codes in Altru as necessary
  • Fixes unresolved or incomplete sales orders
  • Maintains Altru user accounts and security
  • Manages tasks and assignments using departmental project tracking system
  • Contributes to and/or creates a feedback system for internal customers requesting data cleanup
  • Creates policies and procedures for Altru use and maintenance, based on best practices and consistent with department policies
  • Assist with other departments as directed and perform other duties as assigned

Knowledge

  • Must have working knowledge of Microsoft Windows 7 or newer
  • Must have working knowledge or Microsoft Office (2010 or 2013), especially Excel
  • Must have some experience with back-office, bookkeeping, or fundraising operations
  • Must have some experience with Google Suite (G Suite, formerly Google Apps), specifically Google Mail (Gmail), Google Drive, Google Docs/Sheets/Slides
  • Must understand and value honesty, integrity, consistency, and accuracy and the risks associated with compromise in those areas
  • Must be aware of and keep track of relevant compliance demands regarding data/records retention
  • Knowledge or experience with Blackbaud Altru or Raiser’s Edge is desirable
  • Experience with Lightspeed POS or other browser-based or desktop POS systems like Ticketmaster VISTA or CounterPoint is desirable
  • Knowledge of database queries is desirable
  • Knowledge of macOS is desirable

Skills

  • Must be self-driven and independently motivated, able to independently set daily goals
  • Must be able to create and work through assigned projects and tasks
  • Must be able to handle competing requests and priorities from other staff
  • Must be trustworthy, due to the sensitive, confidential nature of personal and financial recordkeeping
  • Excellent attention to detail and organization skills
  • Excellent presentation and communication skills
  • Must be personable and motivated to succeed
  • Must possess a sense of humor and work well within teams from different departments
  • Demonstrated teaching skills is preferred

Abilities:

  • Able to translate and describe technical information to non-technical audiences
  • Able to teach others or troubleshoot issues in-person, over the phone, or via email
  • Able to perform work accurately and thoroughly
  • Requires strong ability to follow instructions, manage time, remember details, organize, multi-task, research, communicate verbally and in writing.

Education, Licensure, Certifications:

  • At minimum, an Associate degree is required, Bachelor’s degree preferred.
  • Blackbaud certifications or training is desirable

Experience:

  • Must have a minimum 2 years’ experience in a non-profit or office environment
  • Must have some experience working with sensitive personnel or customer data or files
  • Must have experience with data entry procedures
  • Experience training others to use computer software is highly desirable
  • Experience working in a cultural institution is highly desirable
  • Customer service experience is highly desirable