Associate Data Analyst

At the Philadelphia Museum of Art, we actively seek to employ a diverse group of people who embody our organizational values. We welcome and encourage individuals of all backgrounds to apply, especially those from marginalized and underrepresented groups in the museum field, who are inspired by our shared purpose and enjoy working collaboratively with others.

We are proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, ancestry, citizenship or immigration status, color, disability, ethnicity, familial status, gender identity and/or expression, genetic information, marital status, national origin, race, religion, sex, sexual orientation, veteran status, or any other protected status.

How You Will Contribute

The department of Systems and Analysis establishes the structure to collect information about our audiences, who they are and how they choose to interact with the Museum. We provide data to help evaluate the effectiveness of our programs, exhibitions, and marketing initiatives by measuring the results against established metrics and goals and forecast for the future. Knowing where we have been, where we are now and provide the analytical tools necessary to forecast what is possible for the future.

The Associate Data Analyst assists the Director of Systems and Analysis and the Assistant Manager of Strategic Analytics with data collection and data standardization, maintaining systems of data storage, and producing reports and dashboards for the Membership and Visitor Services department.

Specifically, you will:

• With support of the Director and Assistant Manager, develop an understanding of how the data contained in various systems are utilized and can be joined to create useful information to support decision making
• 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 d evelop ing and maintain systems and tools for tracking performance including analysis on the performance of attendance, membership, and admission initiatives
• Remain up to date on best practices in data stewardship and reporting
• Attend the interdepartmental business systems meetings to ensure consistency of use across database and identify opportunities for increased collaboration and sharing best practices

• 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
• Identify and recommend process improvements that significantly reduce workloads or improve quality for assigned areas of responsibility.

• As part of a team, ensure general admission, membership and programmatic offerings are available for reservation and purchase through Museum ticketing and membership platforms and maintain a coding structure that allows for comprehensive reporting across systems and databases

• 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
• Assist in the identification and implementation of tools to increase efficiency and accuracy
• Provide other information as needed to support data-informed decision-making within the Membership and Visitor Services department
• Perform other duties as assigned

Your background and experience include:

• 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
• 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.
• 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.
• Ability to identify and recommend processes improvements.
• Working knowledge and experience in museum industry and customer relationship management software solutions, focused experience in a museum environment or similar preferred
• 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

Position and Compensation Details

• The hourly rate for this position is $27.47.
• This position is Full-Time, Non-Exempt, and 35 hours per week.
• This position is part of the AFSCME Local 397 bargaining unit.
• This position reports to the Director of Systems and Analysis.
• Physical requirements:
  • Able to remain stationary for extended periods of time, to utilize computers and other office equipment required of this job, to perform physically administrative duties in a typical interior office environment, gallery, or exhibit space, and to access most public and staff areas of the museum campus
• Background check required after a conditional job offer is made. Consideration of the background check will be tailored to the requirements of the job.

Institutional Requirements

• Upholds the professional standards of the field, always acts in a manner that is consistent with the best interests of the museum and protects and enhances its reputation and standing within the community of museums.
• Adheres to the museum’s code of ethics and Employee Handbook and avoids any real or perceived conflicts of interest.
• Shows respect for co-workers and visitors and an understanding of and appreciation for the diversity of the museum’s staff, volunteers, and audiences.
• Maintains confidentiality.
• Adheres to all museum protocols, procedures, rules, and policies.

Application Timeline

Applications will be reviewed on a rolling basis. We encourage candidates to apply early as the position will close once we have a robust applicant pool or a candidate has been selected.

What We Offer

Our employees are at the center of the museum. As an employee, you will have access to numerous museum perks including, but not limited to:

• Discounted guest tickets for admission
• Discounts on gift memberships
• Special staff tours and presentations from our curatorial and conservation teams
• Discounts at the museum restaurant, museum cafés, and museum retail and online stores

We offer a comprehensive benefits package for employees including:

• Medical, dental, and vision benefits
• Fully paid short-term disability insurance, 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

*Eligibility for certain benefits is based on a variety of factors including the employee’s regular schedule and tenure.