Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

The Business Intelligence Analyst manages Broadway Across America’s data warehouse and reporting ecosystem, collaborating with team members to develop data solutions from stakeholder discovery to ongoing iteration. This role builds and maintains scalable data pipelines and dynamic reporting tools using data modeling, ETL processes, and dashboard development to support business needs, conduct ad hoc analyses, and present insights.

Responsibilities

Monitor, maintain, and troubleshoot automated data pipelines for the Snowflake data warehouse and Domo reporting ecosystem.
Build, optimize, and maintain scalable SQL data models for efficient front-end reporting.
Structure and maintain ETL processes to transform and integrate data from multiple sources.
Design, develop, and manage interactive dashboards, reports, and applications in Domo.
Work directly with internal teams and external partners to understand business needs and define data 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 and follow-through.
Ensure data accuracy, consistency, and reliability through quality assurance processes.
Provide ad hoc analyses, data extracts, and reporting to support strategic decision making.
Identify opportunities to standardize recurring needs into scalable solutions.
Maintain awareness of business priorities and proactively enhance reporting.
Present dashboards, data insights, and reporting tools to stakeholders clearly and in a business-relevant manner.
Provide training and ongoing support for users to effectively leverage BI tools.
Maintain thorough and detailed documentation of data models, logic, and reporting structures.
Continuously develop technical and analytical skills.
Maintain awareness of emerging technologies and contribute to evaluating and adopting improvements to the data stack.
Contribute to project planning and execution for departmental changes affecting data architecture, tools, or processes.

Requirements

Strong analytical and problem-solving skills.
Proficiency in SQL (PostgreSQL, Snowflake).
Proficiency in 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.
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.
Applicants for employment in the U.S. must possess work authorization which does not require sponsorship by the employer for a visa.

Skills

Data modeling
ETL processes
Dashboard development
SQL
Snowflake
Domo
DBT
Visual Studio Code
GitHub
Salesforce
Tessitura
Data analysis
Business intelligence
Data visualization
Reporting
Communication
Presentation

Location

Work Type

Full-time

Experience Level

2+ years of experience in data analysis, business intelligence, or a related role.

Education Level

Bachelor's degree in Business, Data Analytics, or a related field.

Salary/Compensations

$95,000.00/ annually

Benefits

Vacation and Holiday Pay
Health & welfare benefits
401(k) retirement plan

About the Company

THE JOHN GORE ORGANIZATION is the leading presenter, distributor, and marketer of Broadway theatre worldwide.
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.
Working at The John Gore Organization means doing what you love.
We hire trailblazers, theater-lovers, and pioneers.
We welcome, embrace, and respect diversity of people, identities, and cultures.
We want people who can solve challenging problems, make a real impact, and, together, build something big.

Equal Opportunity

The John Gore Organization is an equal opportunity employer and affords equal employment opportunity to all applicants regardless of race, color, religion, gender, creed, national origin, age, disability, sexual orientation, veteran status or any other legally protected classification under local, state or federal laws.