Director of Analytics & Insights

pittsburghsymphonyorchestra; Pittsburgh (Allegheny County); Hybrid; USD 115,000 - 123,000; Full time

Job summary

The Pittsburgh Symphony Orchestra (PSO) is seeking a Director of Analytics and Insights to lead the BI function, translating department needs into KPI definitions, dashboards, and analyses to drive organization-wide performance monitoring.

This senior role partners with Marketing, Development, Finance, Education, and Operations, mentoring analysts and shaping the data-driven future of PSO. Hybrid schedule in Pittsburgh with growth opportunities.

Qualifications

• Bachelor's degree in Analytics, Data Science, Information Systems, Statistics, Business, Economics, or related field.
• Ten+ years of progressive experience in BI, data analytics, business analysis, or related discipline.
• Experience leading stakeholder engagements—translating business language into technical specifications.
• Experience defining and stewarding KPIs across multiple functions.
• Hands-on experience with BI dashboards, semantic modeling, and data visualization.
• Proficiency with SQL for exploratory analysis and reporting design.
• Excellent written and verbal communication; strong customer-service orientation.
• Interest in leading a small analytic team as the function grows.

Responsibilities

• Serve as the primary liaison between the BI function and departments (Marketing, Development, Programming, Guest Experience, Finance, Education, Operations).
• Lead intake conversations to translate objectives into scoped BI work.
• Define KPI definitions and maintain the KPI Registry as truth.
• Reconcile data across sources to deliver reliable analytics outputs.
• Translate business needs into technical specifications for BI/engineering.
• Maintain dashboards, reports, and segmentation logic with timely refresh.

Skills

SQL

BI dashboards

Data visualization

Stakeholder engagement

Communication

Education

Bachelor's degree in Analytics, Data Science, Information Systems, Statistics, Business, Economics, or related field

Tools

Tessitura

Python

R

Snowflake

Job description

Who is the Pittsburgh Symphony Orchestra?

Known for its artistic excellence for more than 130 years, today the PSO is the region’s national and international cultural ambassador. A two‑time 2018 GRAMMY® Award-winning orchestral ensemble credited with a rich history of concerts, performances, and recordings with the world’s finest conductors and musicians, the PSO consistently demonstrates a genuine commitment to Pittsburgh’s citizens, regional communities, and vibrant cultural scene.The internationally acclaimed Pittsburgh Symphony Orchestra (PSO) engages audiences of all ages through unparalleled live musical experiences, community collaborations, and educational programming that enrich every life with great music.

Job Purpose:

The Director of Analytics and Insights is the primary business‑facing member of the Pittsburgh Symphony Orchestra's BI function and the senior analytical voice within the team.

This role is the primary support to departments while they translate organizational goals, department needs, and business language into consistent, well‑defined KPIs, dashboards, and analyses across all departments. The Director runs intake conversations with department heads, facilitates metric definition sessions, proactively surfaces insights, and translates business requirements into technical specifications the BI team can act on.

As PSO transitions from foundational data infrastructure into an era of trusted, organization‑wide performance monitoring, the Director sets the standard for the practice; ensuring every KPI has a single agreed‑upon definition, every dashboard answers a real business question, and the function matures with clarity and discipline.

As the BI function grows in scope and staff, this role will grow with it, with the potential to lead a small team of analytical and data professionals and to expand in scope and title as the function matures.

Essential Duties and Responsibilities:

Business Partnership & Stakeholder Engagement (Primary Focus)

• Serve as the primary point of contact between the BI function and business departments, including Marketing, Development, Programming, Guest Experience, Finance, Education, and Operations.
• Run structured intake conversations that translate department objectives and milestones into scoped, actionable BI work.
• Facilitate metric definition sessions with metric owners to establish clear, agreed‑upon KPI definitions before development begins.
• Help non‑technical stakeholders articulate what they need from data, reframing vague requests into answerable ones.
• Present dashboards, findings, and a BI portfolio review at a regular cadence to departments and leadership in language appropriate to the audience.
• Lead data literacy initiatives that strengthen the organization’s ability to interpret and act on analytical outputs.

KPI & Metric Stewardship

• Own the organization-wide metric definition practice, ensuring terms like “new patron,” “active donor,” “revenue,” and “engagement” have a single agreed‑upon definition across the organization.
• Maintain the Metric Registry as the single source of truth for KPI definitions, including formula, grain, owner, cadence, source, and sensitivity classification.
• Apply the “So What?” test to every proposed KPI, and enforce OCS discipline (Owner, Cadence, Source) before metrics enter the plan.
• Classify metrics by type (Input, Output, Performance, Financial Driver) to ensure each department has a healthy mix of leading and lagging visibility.
• Steward the ongoing evolution of KPIs; retiring, refining, or proposing metrics as business needs change.

Requirements Translation & BI Delivery

• Convert business requirements into clear, well‑specified technical requirements that the Data Engineer and BI team can act on.
• Reconcile data across multiple source systems to produce consistent, trustworthy analytical outputs.
• Partner with the Data Engineer on data model decisions that support business needs.
• Maintain and enhance the existing portfolio of dashboards, reports, and segmentation logic, ensuring outputs remain accurate, documented, and refreshed on schedule.
• Triage incoming BI requests, apply scoring criteria and quality gates, and ensure outputs comply with data governance, privacy, and security standards.

Proactive Analysis & Insight Delivery

• Perform hypothesis‑driven analyses of patron behavior, ticket sales, fundraising, membership dynamics, marketing effectiveness, and organizational health.
• Identify trends, anomalies, and opportunities that departments have not surfaced themselves, and communicate findings on a regular cadence.
• Frame insights in terms of the decision they inform, the recommended action, and the level of confidence; not raw data dumps.
• Partner with department heads to help them use BI outputs to change how their work is done.

Team & Practice Development

• Mentor department staff who perform analyses, elevating analytical capability across the organization.
• Contribute to the design and eventual staffing of the growing BI function.
• Provide informal technical guidance to peers and cross‑functional collaborators.

Required Education and Experience:

• Bachelor's degree in Analytics, Data Science, Information Systems, Statistics, Business, Economics, or related field. Equivalent professional experience may substitute.
• Ten or more years of progressive experience in business intelligence, data analytics, business analysis, or a related discipline, with demonstrated growth in scope and responsibility.
• Demonstrated experience leading stakeholder engagements—running requirements gathering sessions and translating business language into technical specifications.
• Demonstrated experience defining and stewarding KPIs or metric definitions across multiple business functions, including bringing agreement across competing definitions.
• Strong hands‑on experience with modern BI and dashboarding platforms, including semantic modeling, data visualization design, and communicating with business users about report design.
• Working proficiency with SQL for exploratory analysis, validation, and specification.
• Excellent written and verbal communication skills, with a proven ability to explain data and findings clearly to non‑technical audiences.
• Strong customer‑service orientation and comfort in ambiguous, evolving business conversations.
• Interest in and aptitude for eventually leading a small team of analytical professionals as the function grows.
• Ability to manage multiple concurrent workstreams and deliver on commitments with minimal supervision.

Preferred Skills and Experience:

• Experience with modern cloud data platforms and Lakehouse or warehouse architecture.
• Familiarity with dimensional modeling and metric registry design.
• Familiarity with CRM, ticketing, or fundraising platforms (Tessitura experience is a plus).
• Experience supervising, mentoring, or coaching analysts or other technical practitioners.
• Working knowledge of a scripting language (such as Python or R) for analytical prototyping.
• Experience supporting marketing analytics, fundraising analytics, or executive KPI frameworks.
• Familiarity with data governance and stewardship practices.
• Experience in a nonprofit, arts, cultural, or mission‑driven organization.
• Demonstrated curiosity — an inclination to investigate the “why” behind numbers, not just report them.

Physical Requirements:

• Ability to work at a computer for extended periods of time.
• Ability to operate standard office equipment including computer, copier, and scanner.

Compensation and Location:

This is a full‑time exempt position with an annual salary between $115,000 - $123,000 depending upon experience. We also offer a comprehensive benefits package which includes paid holidays, paid time off, employer paid health benefits, as well as retirement savings options with an employer match. Heinz Hall in downtown Pittsburgh is the work location for this position. The PSO supports a flexible, hybrid work environment, which currently includes three days per week in‑person work, including occasional work on weekends and evenings during PSO and Heinz Hall concerts or events.

Pittsburgh Symphony, Inc. (PSI) provides equal opportunity to all qualified employees and applicants for employment without regard to race, color, religion, sex, gender, pregnancy, sexual orientation, gender identity, genetic information, ancestry, national origin, age, physical or mental disability, marital status, veteran status, or any other class or category protected by local, state, or federal law. The specific statements shown in each section of the description are not intended to be all-inclusive. They represent typical elements and criteria considered necessary to perform the job successfully. The PSI recognizes that an individual with a disability may require a job modification/accommodation to enable them to successfully perform a job function. Consideration will be given to such requests. Such requests should be directed to Human Resources.