Share Email Opening Title Database Administrator and Analyst  About the Organization Strathmore is a multidimensional creative anchor in the community, where everyone can connect with the arts and artists can explore their full potential. We present nearly 400 performances, exhibitions, and education programs annually for diverse audiences on our Montgomery County Maryland campus and throughout the community. Based one-half mile outside the Capital Beltway in North Bethesda, Maryland, we serve the entire Washington, DC region and the state of Maryland with exceptional artistic experiences and opportunities to learn and connect. Our work is based on our mission to amplify distinctive and diverse artistic voices and curate experiences to enrich every life and shape stronger communities. We are actively assessing how systemic inequities impact our organization's work at all levels and how best to address those inequities in a way that is consistent with our mission. This commitment is made within the broad context of Strathmore's Inclusion, Diversity, Equity and Access (IDEA) goals to expand access and diversity, promote inclusion, and build equity for all. With these daily actions, Strathmore intends to become an actively anti-racist, anti-discrimination, and inclusive organization. You can read more about Strathmore on our website, including information about our mission and values.   Position Tessitura Application and Database Administrator   Open Date 9/20/2022   Close Date 4/30/2023   Description Database Administrator and Analyst Strathmore seeks a Database Administrator and Analyst to oversee all aspects and management of the Tessitura CRM system and related reporting tools and third-party integrations. Tessitura is the premier fully integrated CRM software system for arts and cultural organizations. Reporting to the Chief Financial Officer, this position is responsible for maintaining advanced knowledge of Tessitura and related software. As a key collaborator, the DA partners institution-wide with teams such as Marketing and Communications, Advancement, Ticketing and Patron Services, and Finance to optimize data operations while maintaining a holistic view of how each area relates to and impacts the other. The DA is responsible for providing technical expertise, convening, training, and strategic customization for all users (2) in the consortium environment, of which Strathmore is lead. The DA will also help the institution design and refine data analysis processes that allow stakeholders to measure return on investment, progress towards goals, and leads to more strategic decisions about viability and effectiveness.   ESSENTIAL DUTIES AND RESPONSIBILITIES May include, but are not limited to:   Data Management, Integrity, and Hygiene Serve as the main point of contact in troubleshooting, assisting, and educating end-users on the Tessitura platform. Manage system upgrades and maintenance. Work with all departments to leverage existing Tessitura functionality and develop customizations accordingly to serve stakeholder needs. Support and understand all Tessitura platform integrations and recommend beneficial changes and modifications when identified. Partner with the Technical Lead, Senior Product Manager from Tessitura, as well as website Communications Manager on the development and testing of new TNEW functionality, ensuring its successful integration with Tessitura. In coordination with Marketing / Communications and Advancement, manage and improve constituent communication protocols using Wordfly and Tessitura Contact Permissions. Assist in the generation of complex lists and extractions. Regularly import and organize data from programs that are not fully managed within Tessitura. Implement, maintain, and evaluate a training program for all Tessitura users. Lead organization-wide effort to establish and uphold data entry standards, integrity, and privacy. Perform quality control audits regularly to identify issues proactively, monitor accuracy and ensure system users follow procedures. Manage data cleanup, including careful oversight and management of duplicate records. Run regular NCOA updates. Create and maintain Tessitura technical documentation. Interface with the Tessitura Network to facilitate problem solving and consultation on system questions and issues. Lead the Tessitura Power User group in leveraging existing tools and developing customizations according to stakeholder needs, including analysis tools, reporting requirements, automation, and data usability. Research and implement ideas to keep Strathmore at the forefront of Tessitura System Technology, including best practices in consortium management. Provide after-hours support when needed for critical issues.   Analytics and Reporting Lead projects with a data driven approach by assisting with research, analysis, and custom reporting using business intelligence tools such as Tessitura Analytics and Microsoft SQL 2016 queries. Collaborate with all departments to conceptualize, develop, and manage custom solutions on Tessitura such as modifying existing reports, creating custom reports and outputs, and analytical dashboards. Collect, track, and analyze institutional data, including attendance figures, numbers and types of programs, and demographics, so that the organization can better measure return on investment and progress towards goals, and can make more effective decisions. Strategize with the Advancement and Marketing teams by developing predictive models based on behavior patterns and providing analysis support to help teams reach their goals.   Consortium Management Act as the lead of the Strathmore consortium by serving as the first point-of-contact for member organizations, executing consortium-based projects, reinforcing data hygiene protocols related to shared data. Run weekly queries to ensure control groups are in place and review the daily Constituent Audit Report. Liaise between member organizations on complex constituent record changes including inactivating records. Develop shared procedures and create “How To Guides” and upload to Tessitura’s Help System. Manage consortium bi-weekly meetings and setting the agenda.   Administrative Other duties as assigned. 40 hours per week, including some evenings and weekends.   A COMPETITIVE CANDIDATE IS A collaborative thinker who anticipates needs, contributes creative ideas, and maintains a holistic view of how each piece may impact another. Resourceful problem solver who takes initiative to investigate and resolve questions. Confident communicator with interpersonal skills to effectively communicate and coordinate with Strathmore staff and consortium partner. Conscientious, organized, and attentive project manager with the ability to prioritize competing deadlines. Flexible and friendly in approach and demeanor with the willingness to undertake all position tasks, from high level strategy to day-to-day duties. Energized by a fast-paced environment working well under pressure and shifting demands. Adaptable to new technologies and has a curiosity to continue learning and keep up on best practices. Able to perform with a high-level of discretion, professionalism, and integrity with the ability to safeguard confidential information.   ACCOUNTABILITIES Sense of ownership over Tessitura database system including the appropriate handling of customization and utilization requests. Perform meticulous oversight of database integrity. Troubleshoot challenges by listening carefully, utilizing resources, and providing the best possible solution. Maintain excellent system documentation. Team player who builds and maintains good working relationships with various department teams, vendors, and consortium members. Operate within the Strathmore-approved budget.   Position Requirements ACCOUNTABILITIES Sense of ownership over Tessitura database system including the appropriate handling of customization and utilization requests. Perform meticulous oversight of database integrity. Troubleshoot challenges by listening carefully, utilizing resources, and providing the best possible solution. Maintain excellent system documentation. Team player who builds and maintains good working relationships with various department teams, vendors, and consortium members. Operate within the Strathmore-approved budget. QUALIFICATIONS Minimum requirements: Bachelor’s degree (Information Systems, Technology preferred) or equivalent work experience in information technology or arts administration. Expert in Tessitura database operations, or comparable CRM, ideally with TNEW / Wordfly integrations, complex membership structures, advanced ticketing set-up and Tessitura Analytics. Proficiency in Microsoft SQL is required to maintain the Tessitura custom reports and utilities. Experience with Microsoft SQL Server Management Studio (SSMS) and SQL Server Reporting Services (SSRS). Experience successfully managing CRM upgrades in complex environments with multiple stakeholders. Knowledge of control groups and past work in a consortium setting preferred. Technically skilled and able to troubleshoot issues with Tessitura, TNEW, Wordfly, and other related areas, in partnership with IT, Advancement, and Marketing and Communications. Knowledge of or ability to learn other systems as necessary (Blackbaud Financial Edge, Event Booking)   STATUS AND SALARY This is an exempt, salaried position. Salary is commensurate with experience with a competitive benefits package including opportunities to attend a wide range of performances and events at The Music Center, The Mansion, and AMP. Flexible work options exist (hybrid and majority-remote) for this position. Please include your salary expectation with application.   Exempt/Non-Exempt Exempt   Full-Time/Part-Time Full-Time   Salary   Location Strathmore   EOE Statement Strathmore is committed to providing equal employment opportunities to all employees and applicants for employment. Accordingly, Strathmore provides employment opportunities without regard to race, color, religion, creed, ethnicity, sex, pregnancy, national origin or ancestry, age, physical or mental disability, citizenship status, marital status, sexual orientation, gender identity, family responsibilities, genetic status or information, military or veteran status or status in any status protected by federal, state, or local law. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training. Strathmore will not tolerate unlawful discrimination, harassment, or retaliation under any circumstances. We are eager to cultivate a broad and inclusive field of applicants. Strathmore is committed to building a diverse community of staff, volunteers, and interns. Individuals from underrepresented groups are encouraged to apply.   This position is currently not accepting applications. To search for an open position, please go to http://StrathmoreHallFoundationInc.appone.com WE ALSO RECOMMEND Other Jobs Within Same Category -- None found -- Other Jobs Within 60 Miles Director of Individual Giving in North Bethesda, MD Posted on: 12/11/2023 [Apply Now]

AppOne.comTM   ©1999-2021 HR Services, Inc. Click here for technical assistance.