Database Manager

JOB SUMMARY The Database Manager's primary responsibility is to coordinate the organization's database systems, keep the data clean, the system up to date, and to use a variety of tools to compile and present data for tracking and analysis. The Database Manager utilizes Tessitura products (Tessitura, TNEW, Analytics) to build Education offerings, streamline organization processes and procedures, maintain clean records, create and manage custom reports for other departments, prepare analytics dashboards, and support daily processes including updating and importing data and records. The Database Manager reports directly to the Director of Administration. ESSENTIAL DUTIES AND RESPONSIBILITIES Provide database support to assure that the Tessitura database fulfills the transactional and informational needs of the organization. Monitor daily actions in the database and provide any daily database cleanup that is needed (updating addresses, merging records, etc.). Supervise the Registrar who oversees student enrollment and student data collection and management. Establish and maintain organizational protocols for all data entry and configurations. Work with the Education Department to gather information and build out class and camp offerings within Tessitura. Oversee annual season build and package creation. Monitor and manage the performance of the database to assure efficient operation. Keep all database users up-to-date, informed, and confident of data issues and processes. Provide foundational Tessitura setup and training for new users across the organization and higher level Tessitura training for power users in Registration, Marketing, Education, Patron Services, and Development. Responsible for managing all aspects of Tessitura and related hardware - TNEW, Hosting Services Management, Ticket Scanners, BOCA Printers, Credit Card Readers, and tablets. Provide support for Tessitura integrated partners such as Wordfly, Wordpress, CampDocs, Queue-It and GoFundMePro. Document standard procedures for Tessitura best processes and provide support for other internal users. Stay up to date and keep users informed about Tessitura developments including patches, outages, updates, and upgrades. Serve as the Tessitura knowledge expert on staff by providing advice and instruction on best practices for colleagues as well as troubleshooting small technical issues as they arise. Work with Tesitura Network to coordinate upgrades and seek resolutions for errors or answers for questions on behalf of the organization through Tessitura Support. Create Campaigns, Funds, Appeals and Sources for the Development Department. Oversee and implement new Fiscal Year turnovers including new defaults, campaigns, seasons, batch periods, etc. Provide backend support in System Tables, References, Ticketing Setup, Facility Manager, and occasionally SQL Server Management Studio. Prepare End-Of-Year Audit Reports and data for Finance and Accounting teams upon request. Prepare reports and dashboards for the annual report, grants, and other external reporting. Assist other departments in gathering and analyzing information from the database to further department goals. Pull lists and extractions for Education, Marketing, and Development departments as needed Maintain security and integrity of the database. Oversee data imports of mass contribution entries and data from NCOA updates. Serve as a technical liaison for outside contractors such as website developers, finance representatives, and fundraising consultants to provide insight and recommendations based on Tessitura configuration. QUALIFICATIONS Bachelor's Degree in relevant field OR equivalent experience in database support. One to three years relevant work experience in database management in a nonprofit, marketing, or fundraising environment. Must have experience with administration of Tessitura or similar ticketing and client relationship systems (such as Spektrix, Blackbaud, AudienceView, or Vendini) and have a thorough understanding of database importing/exporting especially across different platforms. Preference given to candidates with Analytics and/or SQL experience. Demonstrated ability to learn new systems. Experience developing, implementing, and improving processes/procedures. Outstanding organizational skills, including managing multiple tasks simultaneously. Ability to prioritize work, be proactive, take initiative, and resolve problems. Excellent communication skills; ability to interact collaboratively with staff in an organization with diverse concerns and needs as well as outside partners with different backgrounds and expertise. Ability to work under pressure and meet deadlines. Ability to work independently and collaboratively. Solid analytical and project management skills. Proficiency with Microsoft Office and Google Workspace. Commitment to Inclusion, Diversity, Equity, and Accessibility (IDEA) initiatives and values. COMPENSATION AND BENEFITS 75% coverage for HMO individual health insurance Generous Paid Time Off Generous free and reduced priced tickets, classes, and summer camps Imagination Stage celebrates diversity and is committed to creating an inclusive workplace that values members of our whole community. Imagination Stage is an Equal Opportunity Employer. It does not tolerate discrimination against applicants or employees on the basis of gender, race, color, religion, national origin, age, sexual orientation, disability, citizenship, or any other characteristic protected by law. Candidates from diverse backgrounds are strongly encouraged to apply. Imagination Stage is committed to providing an inclusive interview process. If you need accommodations to participate in an interview, please let us know in advance and we will do our best to meet your needs. #J-18808-Ljbffr