Director of Analytics & Insights

Pittsburgh Symphony Orchestra; Pittsburgh (Allegheny County); On-site; USD 115,000 - 123,000; Full time

Job summary

The Pittsburgh Symphony Orchestra is seeking a Director of Analytics and Insights to lead our BI function and drive data-driven decision making across departments. In this role you will translate business goals into measurable KPIs, define data definitions, and deliver dashboards and analyses that inform strategic initiatives while growing the analytics team as the function evolves.

You will partner with department heads, promote data literacy, and ensure governance and security standards while

Qualifications

• Bachelor's degree in Analytics, Data Science, Information Systems or related field.
• 10+ years of progressive BI, analytics, or related experience.
• Experience leading stakeholder engagements and translating business language.
• Experience defining and stewarding KPIs across functions.
• Hands-on with modern BI and dashboarding platforms.
• Proficient in SQL for exploratory analysis.
• Excellent written and verbal communication.
• Ability to manage multiple workstreams with minimal supervision.

Responsibilities

• Serve as the primary BI liaison between the function and business departments.
• Run intake conversations to translate objectives into BI work.
• Facilitate KPI definitions with owners and establish clear definitions.
• Translate business requests into technical specifications for the BI team.
• Maintain and enhance dashboards, reports, and segmentation logic.
• Provide proactive analysis on patron behavior, ticket sales, and fundraising.
• Mentor staff and contribute to the growth of the BI function.
• Ensure governance, privacy, and security standards are met.

Skills

Stakeholder engagement

KPI definitions

SQL

Data visualization

Communication

Team leadership

Education

Bachelor's degree in Analytics/related field

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, includingMarketing, Development, Programming, Guest Experience, Finance, Education, and Operations.
• Run structured intake conversations that translate departmentobjectivesand milestones into scoped, actionable BI work.
• Facilitate metric definition sessions with metric owners toestablishclear, 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 languageappropriate tothe audience.
• Lead data literacy initiatives that strengthen the organization's ability to interpret and act on analytical outputs.

KPI & Metric Stewardship

• Own the organization-widemetric definition practice, ensuring terms like "new patron," "active donor," "revenue," and "engagement" have a single agreed-upon definition across the organization.
• Maintain theMetric Registryas thesingle sourceof truth for KPI definitions, including formula, grain, owner, cadence, source, and sensitivity classification.
• Apply the "So What?" test to every proposed KPI, and enforceOCS 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 needschange.

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.
• Identifytrends, 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, ora related field. Equivalent professional experience may substitute.
• Tenor more years of progressive experiencein business intelligence, data analytics, business analysis, or a related discipline, withdemonstratedgrowth in scope and responsibility.
• Demonstrated experience leading stakeholder engagements— runningrequirementsgathering sessions and translating business language into technical specifications.
• Demonstrated experience defining and stewarding KPIs or metric definitionsacross multiple business functions, including bringing agreement across competing definitions.
• Strong hands-on experience withmodern BI and dashboarding platforms, including semantic modeling, data visualization design, and communicating with business users about report design.
• WorkingproficiencywithSQLfor 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.
• Strongcustomer-serviceorientation and comfort in ambiguous, evolving business conversations.
• Interestin and aptitude for eventually leading a small team of analytical professionals as the function grows.
• Ability to manage multiple concurrent workstreams anddeliver oncommitments with minimal supervision.

Preferred Skills and Experience:

• Experience withmodern cloud data platformsand Lakehouse or warehouse architecture.
• Familiarity withdimensional modelingand 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 tooperate standard office equipment includingcomputer,copier, andscanner.

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.