The Museum of Fine Arts, Houston is seeking a CRM Data and Reporting Specialist to serve a key role in the institution’s constituent-based reporting from the Tessitura CRM platform. The CRM Data and Reporting Specialist will contribute significantly to the interdepartmental team which proactively moves the MFAH toward the best possible use of the application with the goal of providing a superior museum experience for our guests, members, and donors.
Working closely with Development; Marketing; Membership and Guest Services; and Information Technology to prioritize work, the CRM Data and Reporting Specialist utilizes SSRS to create reports, constituent lists, support data-driven projects, and provide ongoing data maintenance, customizations, and modifications. The Database Reporting Specialist is one of two roles at the MFAH that center on constituent reporting, analysis, and prospecting. These roles are the main points of contact for creating and troubleshooting Tessitura reports, lists, and extractions. They, therefore, work collaboratively to efficiently support institutional business needs and Tessitura end-users, all while keeping the museum’s constituents in mind.
Responsibilities

• Utilize Microsoft SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS) and/or Appeon Infomaker to build and/or edit, enhance, and/or design reports, troubleshoot problems, and test outputs.
• Create, maintain, and debug database objects in SSMS, including but not limited to tables, views, functions, triggers and stored procedures for reporting and other support processes, as needed.
• Acquire deep comprehension of the mission and operations of the Museum of Fine Arts, Houston; its CRM data, and its business needs.
• Develop a robust understanding of the various MFAH constituencies and how they interconnect with the museum and each other.
• Act promptly to resolve Tessitura support tickets requesting reports, exhibiting patience while finding solutions. Act as a user advocate, working across departments to understand business needs and how Tessitura data can help solve them. Help to fine tune ad-hoc report requests, explain what data is stored, and determine output solutions to best serve needs.
• Build and maintain a productivity strategy that supports organizational workflows and recognizes that some requests must be prioritized over others.
• Proactively participate in the interdepartmental team that plans, implements, and completes all Tessitura initiatives. Contribute to this team’s efforts to ensure stability and efficient operations.
• Contribute to documenting the museum’s policies and procedures around reporting, data use and governance, and constituent privacy. Enforce organizational standards regarding access to information.
• Utilize resources, such as the museum’s Tessitura team, data processors, the internal IT department, and the Tessitura Network support desk when necessary to meet organizational goals.
• Maintain relationships with the broader Tessitura community and monitor how other peer organizations use Tessitura and reporting to improve their organizations.
• Understand and/or recommend use of 3rd Party integrations related the operations of the museum and their relationship to the Tessitura software and database. Examples of integrations include Prospect2 (email marketing) and Experian (data quality).
• Assist the data quality team by participating in data audits to ensure accuracy and completeness of records, ensuring data integrity issues are identified and proactively addressed
• Troubleshoot, import/export data and assist as necessary with SQL-based queries of the database

Requirements

• Basic understanding of the Microsoft Windows Operating System (Server & Client)
• Expertise in T-SQL, Microsoft SQL Server Suite (SSMS, SSRS)
• Proficiency in Tessitura and its business intelligence solutions.
• Knowledge of Microsoft Office Products (Word, Excel, Outlook, Teams, etc.)
• Liaise closely with a wide variety of museum staff.
• Ability to effectively translate technical language to end-users.
• Strong analytic and organizational skills. Competency to tackle a problem using a logical and systematic approach.
• Ability to prioritize multiple projects with competing completion schedules.

About the MFAH
The MFAH is an organization comprised of 600+ employees and 1,000+ docents and volunteers. The museum is more than 100 years old and ranks nationally among the top 10 art museums in exhibition space, memberships, endowments, and attendance, with 1M visitors annually. Our multifaceted institution includes multiple gallery buildings, a sculpture garden, two art schools, three eateries and two house museums for decorative arts. The encyclopedic collection numbers more than 70,000 works of art in a wide range of media. As an employer, MFAH offers a supportive, collegial and inclusive work environment and a competitive benefits package.
Position Available:
Title: CRM Data and Reporting Specialist
Reports to: IT Application Manager
Classification: Exempt/Salaried
Schedule: Full Time – 35 Hour Work Week
Compensation: DOE
Work Location: Museum of Fine Arts, Houston or Remote
Working Conditions and Physical Demands
If working on campus, work will primarily be performed in an office environment. Work will vary and involve sitting, speaking, walking and computer use. With or without reasonable accommodation, the individual selected must have the capacity to perform effectively all essential functions. In addition to the other demands mentioned, the demands of the job may or will include:

• Must undergo and meet company standards for criminal background check and reference checks.
• Required ability to handle multiple tasks concurrently.
• Extensive computer usage.
• Seeing, hearing, speaking, and writing clearly in order to communicate with staff, and others.
• Frequent sitting, standing and walking, which may be required for extended periods of time.
• Good vision or corrected by use of glasses and/or contacts for reading and viewing abilities.

Equal Opportunities for All
At the MFAH, we believe that diversity, equity, accessibility, and inclusivity are fundamental to our organization. We welcome all candidates whose experience has prepared them to contribute to our organization and our pledge for workplace diversity, inclusion, and excellence.
Our commitment to our policy and practice of nondiscrimination represents more than good intentions. It provides for employment decisions that are made without regard to race, creed, color, age, gender, sexual orientation, religion, national origin, gender identity or expression, genetic information, disability, or veteran status, or any other protected characteristic as established by law or any other reason unrelated to your ability to join and contribute to our organization and support our mission to provide a museum experience for all.
Research shows that women and individuals from underrepresented backgrounds often apply to jobs only if they meet 100% of the qualifications. We recognize that it is highly unlikely that an applicant meets 100% of the qualifications for a given role. Therefore, if much of this job description describes you, then you are highly encouraged to apply for this role.
The MFAH is equally committed to the full inclusion of all qualified individuals interested in employment with the organization. As part of this commitment, we want to ensure that persons with disabilities are provided reasonable accommodation needed to 1) participate in the job application or 2) interview process; 3) perform essential job functions; and/or 4) participate in the benefits and privileges of employment with the MFAH. If reasonable accommodation is needed, please contact the human resources department: HR@mfah.org
Benefits:
The Museum of Fine Arts, Houston, offers an excellent benefits package that includes:

• Medical Insurance: Employee and dependent coverage through a choice of managed health care programs
• Dental Insurance: Employee and dependent coverage through two plan choices
• Vision Insurance: Employee and dependent coverage through a vision program
• Group health, dental and vision insurance coverage available and effective the first of the month following employment with the MFAH for this role.
• Life Insurance & AD&D: Employee coverage at no cost to the employee
• Long Term Disability: Employee coverage at no cost to the employee

The MFAH provides a generous schedule for time off under the following benefit categories:

• Paid Time Off - Used for absences from work such as vacation, illness of short duration, and personal reasons. Hours are accrued biweekly, based on employment status, length of service, and hours worked
• Reserve Time Off - Used for extended illnesses. Employees accrue up to 6 days per year, up to a maximum of 120 days
• Holidays - Full-time employees receive ten paid holidays per year
• Volunteer Time Off - The MFAH supports activities that enhance and serve the communities in which we live and work. Employees receive up to 40 hours of paid time off annually to give back and volunteer.

Other Benefits

• Staff may contribute to the MFAH Retirement Savings Plan. Eligible staff contributing to the plan may receive up to a 5% matching contribution from the MFAH after one year of service. (We also recognize prior nonprofit service which will provide for an accelerated employer match!)
• MFAH Membership – Staff receive a free Family-level membership
• Metro_ commuter cards subsidized by the MFAH!_
• Discounts – Staff receive discounts on purchases at the Museum shop and all on campus eateries and the Glassell School of Art.

Compensation:
Salary will be commensurate with the applicant's experience and the needs and requirements expressed in the job description.

Job Type: Full-time

Please Note :
bankofmontserrat.ms is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, bankofmontserrat.ms provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.