The Philadelphia Museum of Art's Systems and Analysis department needs to establish a structure for collecting audience information, evaluating program effectiveness, and forecasting future possibilities. The Associate Data Analyst will support this by assisting with data collection, standardization, storage, and reporting to aid decision-making within the Membership and Visitor Services department.
Requirements
- Experience with data manipulation and reporting tools such as Excel, Access, and Tableau
- Ability to work with and rationalize data from multiple systems and generate competitive intelligence and knowledge for decision making
- Experience with Accesso Siriusware, Accesso Passport, Raiser’s Edge, Google Analytics, MS Access, MS Excel, SQL/Transact-SQL and Tableau and Import-OMATIC a plus
Responsibilities
- Assist with the oversite of primary and secondary databases to maintain data integrity and data hygiene by reviewing input, output, and performance indicators to locate and correct problems, assist with data analysis, improve productivity, reduce redundancies, and optimize efficiency and quality
- Assist with developing and maintain systems and tools for tracking performance including analysis on the performance of attendance, membership, and admission initiatives
- Ensure data integrity and compliance with business rules, Museum policies, IRS, PCI and GDPR guidelines are maintained at the highest level within databases and outputs including reporting and dashboards
- Develop technical training documentation for systems supporting the department
- Interpret data, analyze results using proven techniques and provide comprehensive and accurate dashboards with clear data visualizations and ongoing reports
- Work with a team to design, build, test, and maintain dashboards in Excel and Tableau and reports in Excel that reveal data driven insights in a compelling manner
- Develop and maintain systems for segmenting audiences for communication including, but not limited to, visitation emails, acquisition, acknowledging membership transactions and donations; solicitations for renewal, donation, or acquisition; and general information about Membership and museum activity
Other
- 4+ Years of data analytics and/or reporting experience that directly aligns with the responsibilities of this position
- Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
- Excellent organizational, problem-solving, and oral and written communication skills
- Ability to handle confidential information in a discreet manner
- Successful in a collaborative, team-oriented environment
