Show Listing

Contact Human Resources
Visit Website

Job Title: Director, Tessitura Database
Department: Information Technology
Reports to: Chief Financial Officer
Status: Regular, Full-time Salary-Exempt

Houston Symphony is looking for an experienced and qualified Tessitura director who will be responsible for managing the analysis, development and integrity of our SQL server-based database. This position will support and provide information to the development, IT and marketing departments through the management of the patron/donor database information. She or he will be a champion of database integrity, training others within the organization to uphold data standards.

Essential Job Duties:
• Collaborate with departments to build new (or modify existing) financial, analytical, demographic and customized reports using MS SQL, SQL Server Reporting Services (SSRS) and SQL Integration Services (SSIS). Focus on user needs in defining user requirements and retrieving accurate information/reporting from data sources.
• Manage Tessitura release cycles, including planning and staging of beta versions and dissemination of new features to stakeholders
• Co-chair the Houston Symphony Tessitura Users Group—a cross-departmental team that collaborates on Tessitura priorities
• Develop cross-departmental understanding of business processes and data needs
• Provide technical support and information related to Tessitura and related applications, including T-Stats and Revenue Management Application (RMA)
• Apply creative and innovative solutions to work to maximize the capabilities of Tessitura
• Work independently to provide strategic solutions to given problems/requirements
• Provide training and support for Tessitura related applications for the organization. including but not limited to basic standards, list management, output sets, extractions
• Create Tessitura output set elements and list criteria

Database Integrity Duties:
• Maintain or create Houston Symphony specific documentation of the Tessitura infrastructure and data standards to promote optimal database integrity
• Train employees on database standards, including proper account set up
• Update patron address records based on returned mail from all departments
• Identify duplicate accounts within the database—complete account merges from duplicates, or convert households to individuals as needed (and vice versa)
• Administer National Change of Address (NCOA) and phone appends
• Ensure that CRM database processes are legally compliant

Duties in Conjunction with Development Staff:
• Monitor the creation of campaigns and appeals for the development team, in conjunction with the finance department
• Oversee the creation of Tessitura plans and custom tabs
• Import annual fund ask amounts into Tessitura for season ticket renewal and acquisition mailings

Duties in Conjunction with IT Staff:
• Work with the IT team to provide technical support, optimize data connectivity and application availabilty
• Monitor database performance; provactively recommend and develop custom monitoring scripts based on the Houston Symphony’s use of database
• Assist with database application upgrades and hotfixes as necessary
• Backup, restore, archive, create and maintain application test plans and document the process
• Plan and document procedures for disaster recovery and database administration specific to Houston Symphony

Duties in Conjunction with Marketing Staff:
• Prepare data output for season ticket renewal direct mail files and seat-back cards
• Work with Patron Services Center to uphold the highest level of data integrity
• Assist with complex extractions that require SQL queries

• Bachelor Degree in Computer Science, IT or a related field preferred
• 3-5 years of demonstrated expertise in developing reports using SQL Server Reporting Services (SSRS) and SQL Integration Services (SSIS), with at least 2 years of Tessitura report-writing experience
• Demonstrated experience in writing advanced SQL queries, stored procedures and functions
• Minimum 3 years’ experience in managing a database/relationship management software
• High level IT proficiency, specifically Access, Excel and SQL, SSRS and SSIS applications
• Non-profit experience preferred
• Excellent communicator, mentor and trainer—including the ability to communicate technical data in an effective manner with all levels of staff
• The ability to manage multiple tasks with competing priority in a fast-paced working environment
• Be detail-oriented while still having the ability to meet timeline goals and deadlines
• A willingness and ability to work outside standard business hours

    This Ad has been viewed 31 times.
    Print Friendly, PDF & Email
    Funding generously provided by: