The Tessitura Systems Administrator is the primary person responsible for facilitating the development, implementation and support of the Tessitura CRM/Ticketing System across all UMS functions and providing back-up assistance to the UMS Information Technology Systems Administrator. Other duties include timely reporting and financial reconciliation of gifts to UMS as well as the setup and processing of UMS Special Events. This position reports to and works directly with the Chief Financial Officer.
UMS is currently using Tessitura v.12.5.1 and TNEW v. 6.5, with plans to upgrade to Tessiturav. 15 and TNEW v. 7.0 in the next six months.
Provide general database and application oversight and maintenance for the Tessitura CRM software; lead the setup of software/hardware maintenance, inclusive of financial structure setup, education and development processes and on-line sales
Manage upgrades, data conversion and secure access to the system; monitor new system functionality for application to UMS
Train new users on effective use of the system as well as continued training for staff on new functionality
Troubleshoot problems that arise internally or externally
Reporting: assist staff across the organization in developing reports that meet business and operational requirements
Data management: Develop, oversee, and execute data structure and standards, including regular cleanup of duplicate records, standardizing records, data appends, contact import, and integration with U-M donor and alumni database
Create and maintain print at home ticket designs, provide setup for print at home tickets, general maintenance and troubleshooting
NScan general support - training, troubleshooting, configuration
Create, manage and maintain UMS-specific Tessitura online documentation, including policies on data cleanliness and merging procedures
Provide support to the marketing staff on email marketing, assist in list management, functionality, Tessitura integration, and custom workflows
Work with development staff to maximize use of the Tessitura CRM, assist in list management and campaign set-up, integration with University systems
Maintain updated test system to provide environment for training and programming implementation purposes
Stay active within the Tessitura community to stay current on new features and opportunities, trends, and share knowledge
Gift Processing and Reconciliation – 20%
Process donations made to UMS by individuals, corporations, matching gifts, grants, and foundations in the Tessitura system, including processing credit cards and reconciling all payment types and batches; create gift processing forms to send with donations to U-M Office of University Development for deposit
Reconcile gifts and pledges on a monthly basis with information in Tessitura and University system, making sure that all gifts and pledges appear on the UM-OUD system (DART); fix any discrepancies that exist
Create and update extensive Development Income reporting that indicates, daily, monthly and yearly income; compare previous year income to current fiscal income
Process registrations for UMS patrons in Tessitura for various UMS special events; create reports for the Development Office to verify registered guests for these events
Act as liaison to the UM-OUD Data Management team to conduct data matching on Tessitura records vs DART records and add useful UMS information to DART
Reporting – 15%
Meet with department end users to determine their reporting needs
Produce specialized data output requests using SQL queries/procedures and customized SSRS reports where necessary
Provide training and guidance on how to use other software using Tessitura (e.g., T-Stats, Segmentation Engine, Revenue Management Application) to report on data in ways that meets the end user’s needs
General IT Systems and Office Support – 10%
Work with the Information Technology Systems Administrator to provide back-up support for UMS computer hardware, software and network; provide on-call help as needed for website, ticketing and other IT functions
Comply in all efforts with up-to-date PCI Compliance (credit card security); complete PCI certification process and update UMS policies on an annual basis
Backup for Board software system and provide support to staff, advise on setup, assist in setting up new users, troubleshoot issues as necessary
Process box office end of day reports and handle cash and check deposits
The University of Michigan is an equal opportunity/affirmative action employer.
Bachelor’s degree in Computer Science, a related field or equivalent experience
2-3 years related database design and implementation experience
Microsoft SQL server admin experience
Microsoft SSRS Reporting experience
Strong technical and communication skills, including a demonstrated ability to facilitate proactive collaboration with colleagues and partners
Tessitura CRM software experience
Previous experience working at a non-profit arts organization
Internal Number: 163557
UMS is an arts presenting organization housed on the campus of the University of Michigan in Ann Arbor. Celebrating our 140th season in 2018, UMS is one of the oldest performing arts presenters in the country, committed to connecting audiences with performing artists from around the world in uncommon and engaging experiences.
In 2014, UMS was a recipient of the National Medal of Arts, the nation’s highest public artistic honor, awarded annually by the president of the United States at the White House to those who have “demonstrated a lifetime of creative excellence,” according to the National Endowment for the Arts, which oversees the selection process.
With a program steeped in music, dance, and theater, UMS contributes to a vibrant cultural community by presenting approximately 60-75 performances and over 100 free educational activities each season. UMS also commissions new work, sponsors artist residencies, and organizes collaborative projects with local, national, and international partners.