Business Intelligence Analyst

John Gore Organization•New York, NY

7d•$95,000

About The Position

THE JOHN GORE ORGANIZATION is the leading presenter, 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 48 North American markets. It has won Tonys in every producing category as well as numerous other Drama League, Drama Desk and Olivier awards. We are committed to developing an inclusive and supportive culture, where employees have equal opportunity for growth. $95,000.00/ annually FLSA Status: Exempt 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.

Requirements

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
Bachelor's degree in Business, Data Analytics, or a related field.
2+ years of experience in data analysis, business intelligence, or a related role.
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
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

Nice To Haves

Passion for the arts and understanding of the theater industry is a plus.

Responsibilities

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