We offer competitive compensation including Vacation and Holiday Pay, health & welfare benefits, and a 401(k) retirement plan.
Required Education:
4 Year Degree
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)
THE JOHN GORE ORGANIZATION is the leading developer, producer, distributor and marketer of Broadway theatre worldwide. Under the leadership of theater producer and owner John Gore, its family of companies includes Broadway Across America, Broadway.com, The Broadway Channel, BroadwayBox.com and Group Sales Box Office. Its productions span Broadway, Off Broadway, London’s West End, Japan and 47 North American markets. It has won Tonys in every producing category as well as numerous other Drama League, Drama Desk and Olivier awards.
At The John Gore Organization, a diverse, inclusive, and equitable workplace is one where all employees feel valued and respected and all voices are valued and heard. We are committed to fostering, cultivating and preserving a culture of equity, diversity, access and inclusion.