TITLE: Tessitura Database Administrator
STATUS: Full-time, Exempt, Year-Round
LOCATION: Hybrid within 3-hour driving distance from Becket, MA
REPORTS TO: Director of Information Technology
DEPARTMENT: Information Technology
WORKS WITH: All departments
COMPENSATION: $65,000 - $75,000 (GRADE 5) (less applicable tax withholdings)
BENEFITS: (YEAR ROUND): Health, dental, and vision insurance, FSA, 403B contribution, paid time off, life insurance, short- and long-term disability, Employee Assistance Program.
BENEFITS: (SUMMER ONLY) three meals a day, free access to classes, performances, talks, and studio usage.
__________________________________________________________________________________________
POSITION OVERVIEW
The Tessitura Database Administrator Provides leadership for the organization in its use of the Tessitura CRM software. This position ensures the effective utilization of Tessitura across departments, spearheads data-driven initiatives, and provides system support to enhance operations and meet organizational goals. The role requires collaboration with all departments, offering guidance on best practices, troubleshooting, and staff training to optimize the use of Tessitura and its integrated applications.
RESPONSIBILITIES
-
Provides management and support for all Tessitura operations across departments.
-
Researches, plans, manages projects, and troubleshoots Tessitura upgrades, including leading planning for the use of new features, creating testing plans, and conducting staff training as needed.
-
Coordinates implementation and maintains documentation of third-party application integrations with Tessitura and ongoing maintenance and support, including accounting website, bulk email platforms, school applications, wealth screening applications such as WealthEngine, and others like Shopify as available from the Tessitura roadmap and suited to Pillow business needs.
-
Supports Marketing Staff in the administration of TN Express Web application and all web customizations, by being the main point of contact for support needs and maintenance of all system documentation.
-
Maintains awareness of industry trends and practices in the use of Tessitura and advises the organization regarding changes and enhancements that will improve operations.
-
Interfaces with external and internal user groups, to facilitate implementation of best practices and user training.
-
Works with Tessitura Support staff and consultants to troubleshoot database issues and maintain and update customizations to Jacob’s Pillow’s environment.
-
Creates custom reports and modifies existing reports according to business needs.
-
Coordinates planning, scheduling, and implementation of third-party data imports such as NCOA updates.
-
Consult with all departments, gathering user requirements for new initiatives and business processes, and recommending best use of Tessitura to support initiatives.
-
Oversees data entry and tracking, reports, list management, extractions, and other tasks as assigned for cross-departmental Tessitura use through coordination with lead system users.
-
Assists staff with the generation of lists, advanced data extractions, custom reports, and ad hoc queries.
-
Develops training programs for optimization in all departments.
-
Investigate and address support issues concerning the Tessitura RAMP application; submit RAMP tickets on behalf of staff, as needed.
-
Supervises NSCAN installation, maintenance, and support.
-
Updates system tables, as needed.
-
Manages users and security. Enhances security groups and assigns access rights to ensure confidentiality and system integrity.
-
Performs regular data integrity checks and promotes activities, including duplicate reduction across departments.
-
Helps departments enrich data through routine quality assurance and data imports.
-
Provides regular functional supervision and training to Tessitura users in each department.
-
Regularly convenes staff with primary use responsibilities in all departments.
-
Manages Google Shared Drive database implementation.
-
Creates and maintains documentation concerning system configuration, best practices, and data entry. and integrity, as well as procedures specific to Jacob’s Pillow.
HIRING PROCESS
-
Apply: Interested individuals are encouraged to send a cover letter, resume, and references by submitting an application using the “Apply” buttons below. Video and/or audio applications are welcome (though not required) in addition to written expressions of interest.
-
Interview: Pre-screening on Zoom, Hiring Manager Interview on Zoom, In-Person Interview with Panel, Hiring Manager, and Tour of Grounds.
-
Supplemental Materials: A writing sample, spreadsheet example, or other relevant materials may be requested from candidates should they be top candidates.
If you need accommodations to make this application process happen, please connect with us at hr@jacobspillow.org. We will work to support you through the application process via email, phone call, and/or video chat.
