Tessitura Systems Analyst (Technologist)

Exercising broad general knowledge of technology, strong analytical thinking and excellent communication skills, work within the framework of the CSOA Information Technology department to contribute to the successful realization of the department’s primary objective: Supporting the achievement of the CSOA mission through the management of information that is clear and comprehensible; allowing for sophisticated analysis leading to knowledge that informs leadership in ways that enable them to make appropriate choices for the business. As a technology enabler, you will apply design to information; organize, emphasize and visualize; and assist the organization in moving through stages that transform data into information, information into knowledge, and knowledge into action.

PRINCIPLE DUTIES AND RESPONSIBILITIES With a primary focus on the Tessitura environment:

1. Develop, test, implement, maintain and/or document components of solutions, in part or in whole, that serve to deliver positive business outcomes as identified in various department and organization business plans.

2. Document processes, procedures and policies utilized in the fulfillment of department objectives.

3. Maintain accurate logs of time spent on various tasks and objectives as required to ensure the department’s ability to measure achievement and effectiveness.

4. Other specific tasks that could be assigned; including but not limited to: a. Design, development, implementation and maintenance of custom data-based applications, procedures or automated scripts. b. Design, development, implementation and maintenance of data-based web applications, web pages, content management systems and other related web technologies. c. Troubleshooting and resolution of issues involving the application and/or use of technical solutions at CSOA. d. Implementation of standards, procedures and conventions needed to maintain data integrity while meeting the needs of organization wide use of technical systems. e. Maintain awareness of industry trends and practices as related to the use of technology at CSOA.

5. Other duties and responsibilities as assigned.

REPORTING RELATIONSHIPS 1. Reports to the Director of Information Technology 2. Collaborates with other members of the Information Technology Department 3. Interacts with all levels of staff with regards to the Tessitura system

KNOWLEDGE, SKILLS AND EXPERIENCE REQUIRED Practical understanding and experience working with relational databases and structured query languages. (SQL)

STRONGLY DESIRED Understanding, working knowledge and experience with the following: 1. The Tessitura system and all its component modules and parts 2. Tessitura SOAP and REST API 3. Coding/scripting/programming using Microsoft T-SQL 4. Experience with Microsoft SQL Server Management Services (SSMS) 5. Experience with Report development on a Microsoft SQL Server Reporting Services (SSRS) platform

DESIRABLE Familiarity and understanding in the following areas… 1. Microsoft SQL Server Reporting Services (SSRS) and Analysis Services (SSAS) 2. One or more industry leading BI environments 3. Development of stand alone and/or web based applications using high-level object oriented programming languages (such as C++, C#, PHP, Python, Visual Basic .NET, VBScript), and prototype based languages (such as JavaScript, Jscript) 4. Understanding of design methodologies utilized for application design in distributed computing environments 5. Common IT Service Management and Software Development Life Cycle methodologies 6. Ticketing and/or fund-raising business systems in the performing arts industry 7. Strong analytical abilities contributing to the ability to independently solve complex problems 8. Bachelor’s degree in Business, Data Processing, Computer Science, or other equivalent education or experience 9. Strong and demonstrated interpersonal, communications and relationship-building skills 10. Ability to work calmly, effectively and flexibly with many staff, interns and other professionals 11. Ability to grasp new technical material quickly and explain it to non-technical audiences 12. Ability to work on and prioritize a wide variety of complicated tasks simultaneously 13. Team player with excellent customer service skills