Reporting to the Senior Director, Strategic Services, the Senior Analyst, Data & Reporting is a key member of the team that helps LACMA achieve its long-term strategic fundraising and membership objectives. This person is an individual contributor who executes reporting and analytics projects as assigned/approved by Sr. Director of Strategic Services. The Senior Analyst focuses on donor and patron data, as well as financial information, supporting the needs of key stakeholders across the LACMA campus – including Development, Finance, On-Site Services, Membership, Marketing, Events, Education, and others as needed. The primary focus for the Senior Analyst is to seek out and deliver actionable insights on fundraising and operational metrics, such as donor, member and visitor engagement, and trending information, in order to help inform communications and fundraising strategies. The Senior Analyst actively collaborates with colleagues across LACMA to improve the data integrity of its CRMs and Accounting systems, while also helping to implement the enterprise-wide reporting infrastructure. Key partnerships for this position include Development Data Management, Membership & On-Site, Information Systems, as well as the Systems Strategy team.
Some duties include: develops, maintains, and enhances dynamic reports, ad-hoc queries, and other analytics solutions as requested by the Sr. Director of Strategic Services and other senior LACMA staff; collaborates with Sr. Director on defining criteria and parameters, as well as refining design and ensuring accuracy of reporting products & solutions; advises on reporting tool capabilities and industry best practices for data presentation and visualization; plays a key role in training users on how to access and interpret reports and dashboards made available for them; works closely with users to ensure all new reports are accurate; identifies data sources necessary to build the requested reports and performs thorough analysis of these data sets to ensure information integrity and consistency; works closely with the Database Manager to proactively address any data quality issues or variances and helps to define clean-up strategies; collaborates closely with the Systems Strategist on use of Tessitura and other donor and patron applications as it relates to data gathering and input, as well as reporting efforts; supports fundraising and special campaign efforts by offering analytical support and seeking new insights through data – including the development and maintenance of fundraising pipeline and progress reports, as well as forecasting tools; plays a key role in performing data analysis as part of problem solving for critical operational functions, such as monthly financial reconciliation; collaborates closely with colleagues in Information Systems on designing, building, and testing the comprehensive LACMA reporting solution; provides hands-on testing assistance to the Systems Strategy group during database conversions and upgrades, including help with mapping and data integrity audits; supports On-Site Services and Membership teams by developing trend analysis, segmentation and modeling to improve attendance, ticketing revenue, and customer satisfaction and loyalty; prepares presentation slides, Board Report figures, and other materials as requested; identifies trends in and opportunities for increasing annual giving and membership income; creates and maintains a documentation library for all reporting and analytics products; manages a Requests Queue and carefully monitors deliverables, proactively communicating project status to management and internal clients; performs other duties or special projects as assigned.
The qualified candidate will have a Bachelor’s degree in Business Administration, Analytics, or a related field and at least five years of related experience. Experience in the following areas is required: mastery of Excel and Microsoft Access, including pivot tables and data visualization; strong SQL skills and familiarity with VBA or other programming languages, such as Python; working knowledge of SQL Server Management Studio and Microsoft Visual Studio; proficiency with reporting tools such as Crystal Reports and SQL Server Reporting Services; experience using Google Analytics and 3rd-party revenue reporting instruments; and user-level experience with development CRMs such as Raiser’s Edge and Tessitura. The ideal candidate will have the ability to consistently deliver projects on time and on target while prioritizing across projects and perform self-guided data retrieval from CRMs’ front end, as well as through the backend. A fundamental understanding of relational databases, data management strategies and protocols, a successful track record of creating effective visualizations of complex analytical information, and an exposure to Financial Edge or other accounting software and to the nonprofit sector and fundraising operations is highly preferred.
Please follow this link to apply.