Director of Analytics & Insights

Pittsburgh Symphony Orchestra•Pittsburgh, PA

1d•$115,000 - $123,000•Hybrid

About The Position

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.

Requirements

Bachelor's degree in Analytics, Data Science, Information Systems, Statistics, Business, Economics, or a 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.

Nice To Haves

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.

Responsibilities

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.
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.
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.
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.
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.