Associate Data Analyst

About the position

The Philadelphia Museum of Art is seeking an Associate Data Analyst to join the department of Systems and Analysis. This role is crucial in establishing the structure to collect information about our audiences, understanding their interactions with the Museum, and providing data to evaluate the effectiveness of our programs, exhibitions, and marketing initiatives. The Associate Data Analyst will assist in data collection, standardization, maintaining data storage systems, and producing reports and dashboards for the Membership and Visitor Services department. The position requires collaboration with the Director of Systems and Analysis and the Assistant Manager of Strategic Analytics to ensure data integrity and compliance with various guidelines.

Responsibilities

• Develop an understanding of how data in various systems are utilized and can be joined to create useful information for decision making.
• Assist with the oversight of primary and secondary databases to maintain data integrity and hygiene.
• Assist in developing and maintaining systems and tools for tracking performance, including analysis of attendance, membership, and admission initiatives.
• Stay updated on best practices in data stewardship and reporting.
• Attend interdepartmental business systems meetings to ensure consistency and identify collaboration opportunities.
• Ensure data integrity and compliance with business rules, Museum policies, IRS, PCI, and GDPR guidelines.
• Develop technical training documentation for systems supporting the department.
• Interpret data, analyze results, and provide comprehensive dashboards with clear visualizations.
• Work with a team to design, build, test, and maintain dashboards in Excel and Tableau.
• Identify and recommend process improvements to reduce workloads or improve quality.
• Ensure general admission, membership, and programmatic offerings are available for reservation and purchase through Museum platforms.
• Develop and maintain systems for segmenting audiences for communication.
• Assist in identifying and implementing tools to increase efficiency and accuracy.
• Provide information to support data-informed decision-making within the Membership and Visitor Services department.
• Perform other duties as assigned.

Requirements

• 4+ years of data analytics and/or reporting experience that aligns with the responsibilities of this position.
• Strong analytical skills with attention to detail and accuracy.
• Experience with data manipulation and reporting tools such as Excel, Access, and Tableau.
• Ability to work with data from multiple systems and generate competitive intelligence for decision making.
• Excellent organizational, problem-solving, and communication skills.
• Ability to handle confidential information discreetly.
• Successful in a collaborative, team-oriented environment.
• Ability to identify and recommend process improvements.
• Working knowledge and experience in the museum industry and customer relationship management software solutions.

Nice-to-haves

• Experience with Accesso Siriusware, Accesso Passport, Raiser’s Edge, Google Analytics, MS Access, MS Excel, SQL/Transact-SQL, Tableau, and Import-OMATIC.

Benefits

• Free general admission to the museum for you and your immediate family.
• Discounted guest tickets for admission.
• Discounts on gift memberships.
• Special staff tours and presentations from curatorial and conservation teams.
• Discounts at the museum restaurant, cafés, and retail stores.
• Medical, dental, and vision benefits.
• Fully paid short-term and long-term disability insurance, and life insurance.
• Health savings or flexible spending account program.
• Retirement savings program with museum match.
• Paid vacation, personal days, sick days, and holidays.