Job Description:

04-Apr-2024

Tessitura Database Administrator

American Repertory Theater

65522BR

Position Description

The American Repertory Theater (A.R.T.) at Harvard University is a leading force in the American theater, producing groundbreaking work that is driven by risk-taking and passionate inquiry. Reporting to the Director of Marketing and Communications, the Tessitura Database Administrator is responsible for monitoring, maintaining, and administering the A.R.T.’s robust customer relationship management (CRM) database. The position’s primary responsibility is to administer and manage the A.R.T.’s use of Tessitura—the premier arts and cultural enterprise application designed to fully integrate all aspects of an arts organization into one database, including: ticketing, fundraising, memberships, marketing, reporting, customer relationship management, and web functionality. This person independently executes work and facilitates the collaborative effort of these cross-functional teams across the organization. The role will be responsible for supporting, developing, implementing routine and custom functions for the databases that comprise Tessitura and other applications in the A.R.T.’s environment, while ensuring data integrity. The ideal candidate will have a working knowledge of Tessitura and its dynamic uses by a busy arts organization, understanding not only the inner workings of Tessitura and its applications, but also how it relates to the end user, both internal and public facing.

Primary responsibilities:

• Serve as the primary source of information and advanced troubleshooter regarding Tessitura and other database schemas, structures, and objects; this position serves as the primary liaison with the Tessitura Network staff and is a member of the A.R.T.’s Tessitura Power User group.
• Manage user needs analysis, evaluation of new functionality, customization, testing, implementation, and support; ensure that upgrades and new services deliver the value users expect
• Provide technical expertise and direction in developing and supporting system level programs while optimizing the databases configuration and performance.
• Create documentation for specific systems and processes and troubleshoot advanced problems and recommend appropriate action
• Build performances and other sellable items into the database; create houses for various venues and configurations, purchase add-ons including donations and supplemental products
• Assist the Marketing and Development departments to maintain the functionality of digital products, such as website, email, and mobile app components, that interact with Tessitura.
• Independently analyze, identify, develop and communicate technical solutions to existing and new issues, including but not limited to those with reports, analytics, and design.
• Devise and/or modify procedures to solve complex technical problems
• Work with A.R.T. leadership, marketing and fundraising departments to provide strategic input and create new ways to analyze data, communicate with the public, solicit donations, and sell tickets. Collaborate with key stakeholders to translate management needs into systems requirements; scope and identify solutions that meet defined business/service objectives. Contribute to the establishment of key performance indicators and service quality measures
• Manage specialized data output requests using SQL queries/procedures, Tessitura Analytics dashboards, and customized SSRS reports where necessary
• Independently develop own project schedules and meet all project deadlines; provide regular updates and progress reports, and work with all A.R.T. departments to fulfill requests and complete assigned projects. Work at a high level within a cross-departmental team and consider the business implications of technology applications to the current and future business environment.
• Maintain updated test environment for the database to provide non-production environment for training and programming implementation purposes

Basic Qualifications

• Minimum of two years’ post-secondary education or relevant work experience

Additional Qualifications and Skills

A successful candidate will have:

• Previous working experience with other database/inventory management systems is helpful for reference.
• A minimum of three years' experience working with and advanced knowledge of Tessitura productions is preferred
• Computer programming and development experience, working knowledge of and fluency is SQL is a plus.
• Commitment to leading and advocating for Anti-Racism, Equity, Diversity and Inclusion principles in their practice
• Advanced communication, technical and project management skills
• Demonstrated team performance skills, service mindset approach, and the ability to act as a trusted advisor. Excellent interpersonal skills; able to collaborate with and motivate a wide range of people across the department and organization, responding favorably and quickly to constructive feedback and input
• Demonstrated leadership and independent problem-solving skills; able to set clear direction
• Strong organizational skills with ability to prioritize multiple tasks in a creative, fast-paced, service-oriented environment
• Analytic mind with ability to interpret data to help inform business development decisions
• Impeccable attention to detail
• Excellent documentation skills
• Interest in the theater and experience working in the non-profit arts is a plus

Certificates and Licenses

• Completion of Harvard IT Academy specified foundational courses (or external equivalent) preferred

Working Conditions

• Work is performed in an office setting

Additional Information

The health of our workforce is a priority for Harvard University. With that in mind, we strongly encourage all employees to be up to date on CDC-recommended vaccines.

Work Format Details

This is a hybrid position that is based in Massachusetts. Additional details will be discussed during the interview process. All remote work must be performed within one of the Harvard Registered Payroll States, which currently includes Massachusetts, Connecticut, Maine, New Hampshire, Rhode Island, Vermont, Georgia, Illinois, Maryland, New Jersey, New York, Virginia, Washington, and California (CA for exempt positions only). Certain visa types and funding sources may limit work location. Individuals must meet work location sponsorship requirements prior to employment.

Benefits

We invite you to visit Harvard's Total Rewards website (https://hr.harvard.edu/totalrewards) to learn more about our outstanding benefits package, which may include:

• Paid Time Off: 3-4 weeks of accrued vacation time per year (3 weeks for support staff and 4 weeks for administrative/professional staff), 12 accrued sick days per year, 12.5 holidays plus a Winter Recess in December/January, 3 personal days per year (prorated based on date of hire), and up to 12 weeks of paid leave for new parents who are primary care givers.
• Health and Welfare: Comprehensive medical, dental, and vision benefits, disability and life insurance programs, along with voluntary benefits. Most coverage begins as of your start date.
• Work/Life and Wellness: Child and elder/adult care resources including on campus childcare centers, Employee Assistance Program, and wellness programs related to stress management, nutrition, meditation, and more.
• Retirement: University-funded retirement plan with contributions from 5% to 15% of eligible compensation, based on age and earnings with full vesting after 3 years of service.
• Tuition Assistance Program: Competitive program including $40 per class at the Harvard Extension School and reduced tuition through other participating Harvard graduate schools.
• Tuition Reimbursement: Program that provides 75% to 90% reimbursement up to $5,250 per calendar year for eligible courses taken at other accredited institutions.
• Professional Development: Programs and classes at little or no cost, including through the Harvard Center for Workplace Development and LinkedIn Learning.
• Commuting and Transportation: Various commuter options handled through the Parking Office, including discounted parking, half-priced public transportation passes and pre-tax transit passes, biking benefits, and more.
• Harvard Facilities Access, Discounts and Perks: Access to Harvard athletic and fitness facilities, libraries, campus events, credit union, and more, as well as discounts to various types of services (legal, financial, etc.) and cultural and leisure activities throughout metro-Boston.

Job Function

Information Technology

Department Office Location

USA - MA - Cambridge

Job Code

I0856P IT Business Analysis PrfsslI

Work Format

Hybrid (partially on-site, partially remote)

Sub-Unit

------------

Salary Grade

056

Department

Marketing and Communications

Union

00 - Non Union, Exempt or Temporary

Time Status

Full-time

Pre-Employment Screening

Identity

Schedule

Full time. Monday through Friday 35 hours per week.

Commitment to Equity, Diversity, Inclusion, and Belonging

Harvard University views equity, diversity, inclusion, and belonging as the pathway to achieving inclusive excellence and fostering a campus culture where everyone can thrive. We strive to create a community that draws upon the widest possible pool of talent to unify excellence and diversity while fully embracing individuals from varied backgrounds, cultures, races, identities, life experiences, perspectives, beliefs, and values.

EEO Statement

We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, gender identity, sexual orientation, pregnancy and pregnancy-related conditions, or any other characteristic protected by law.

LinkedIn Recruiter Tag (for internal use only)

#LI-CS1

PI239161855