Summary

The Business Intelligence department manages Broadway Across America’s data warehouse and reporting ecosystem on behalf of internal national and regional teams and external regional venue partners. The Business Intelligence Analyst, in collaboration with team members, will manage the end-to-end development of data solutions including stakeholder discovery, data modeling, quality assurance, reporting design, user training, and ongoing iteration. This role is responsible for building and maintaining scalable data pipelines and dynamic reporting tools, leveraging data modeling, ETL processes, and dashboard development to support a wide range of business needs. Additional responsibilities include conducting ad hoc analyses for internal teams and external partners and presenting insights and delivering tools for stakeholder use. The ideal candidate is a highly organized and proactive problem solver with a technical background in database tools, a strong curiosity for data, a collaborative mindset, and excellent communication and presentation skills.

Duties and Responsibilities

Technical Development and Data Engineering:

• Monitor, maintain, and troubleshoot automated data pipelines that support Broadway Across America’s centralized Snowflake data warehouse and Domo reporting ecosystem.
• Build, optimize, and maintain scalable data models in SQL that enable dynamic and efficient front-end reporting across a variety of business use cases.
• Structure and maintain ETL processes to transform and integrate data from multiple operational and third-party sources.
• Design, develop, and manage interactive dashboards, reports, and applications in Domo for internal teams and external venue partners.

Stakeholder Partnership and Solution Delivery:

• Work directly with internal teams and external partners to understand business needs and define data and reporting requirements.
• Translate business questions into data models, analyses, and reporting solutions.
• Deliver actionable insights related to performance, trends, and operational outcomes.
• Serve as a primary point of contact for assigned projects, ensuring clarity, responsiveness, and follow-through for stakeholders.

Reporting and Quality Assurance:

• Ensure data accuracy, consistency, and reliability through quality assurance processes and proactive validation and monitoring.
• Provide ad hoc analyses, data extracts, and reporting to support strategic decision making while identifying opportunities to standardize recurring needs into scalable solutions.
• Maintain continual awareness of business priorities at Broadway Across America and proactively enhance reporting to support evolving needs.

Communication and Presentation:

• Present dashboards, data insights, and reporting tools to internal and external stakeholder in a clear, business-relevant manner.
• Provide training and ongoing support for front-end users to effectively leverage BI tools and reporting solutions.
• Maintain thorough and detailed documentation of data models, logic, and reporting structures to ensure consistency, transparency, and long-term sustainability.

Process Improvement and Strategic Development

• Continuously develop technical and analytical skills to expand capabilities.
• Maintain awareness of emerging technologies and contribute to evaluating and adopting improvements to the data stack.
• Contribute to project planning and execution when departmental changes lead to evolving data architecture, tools, or processes.

Competencies

To perform the job successfully, an individual should demonstrate the following competencies:

• Cooperation
  • Establishes and maintains effective relationships
  • Active listener
  • Offers assistance and support to co-workers
  • Works cooperatively in group situations
• Adaptability
  • Able to work around unexpected changes of circumstance or workload
  • Modifies a planned course of action based on new circumstances
  • Changes communication style to achieve the best results, effectively bridging the gap between technical data and non-technical stakeholders.
• Functional Competencies
  • Looks for ways to improve and promote quality
  • Demonstrates accuracy and thoroughness
  • Understands the broader business objectives and tailors data solutions to align with strategic goals
  • Anticipates stakeholder needs and translates technical findings into business-relevant insights
  • Strong technical skills in database querying, data modeling, data transformation, data visualization, and reporting.
• Team Orientation
  • Fosters team cooperation
  • Understands team roles and responsibilities
  • Supports group problem solving

Qualifications aka KSAOs

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily, the requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Strong analytical and problem-solving skills
• Proficiency in SQL (PostgreSQL, Snowflake) and data visualization tools (e.g. Tableau, PowerBI, Alteryx), preferably Domo
• Experience with DBT, Visual Studio Code, and GitHub
• Familiarity with CRM systems such as Salesforce or Tessitura
• Ability to manage multiple projects and meet deadlines
• Excellent communication and presentation skills

Education and/or Experience

• Bachelor's degree in Business, Data Analytics, or a related field.
• 2+ years of experience in data analysis, business intelligence, or a related role.
• Passion for the arts and understanding of the theater industry is a plus.

Communication Skills

• Ability to interpret and analyze complex data sets
• Ability to respond to inquiries from partners and internal stakeholders
• Ability to write clear, concise reports and documentation
• Ability to present technical information to non-technical audiences

Critical Thinking

• Ability to identify data quality or pipeline issues and propose effective solutions
• Ability to design optimal data models prioritizing efficiency and structural needs for flexible front-end reporting
• Ability to evaluate and improve existing processes
• Ability to adapt tools and reports to meet diverse user needs
• Ability to identify skill and knowledge gaps and identify opportunities to fill them independently or with coaching from leadership

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to talk or hear.

Work Environment

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is occasionally exposed to:

• Participation in video conference calls
• Travel by plane to visit partner teams (brief trips a few times per year)