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
- 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.
- 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 (KSAOs)
- 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 presenta