Business Intelligence Developer

Job Description

Job Description

The application window for this position has an anticipated end date of 08/10/2026 .

Company Overview

The Denver Center for the Performing Arts (DCPA) is one of the largest non-profit theatre organizations in the nation, presenting Broadway tours and producing theatre, cabaret, musicals, and innovative, immersive experiences. Through these experiences and alongside our robust Education program, we engage hundreds of thousands of visitors each year.

The DCPA’s workforce includes more than 300 employed team members in non-union and union positions (in partnership with seven unions). In addition, we employ hundreds of artists and contractors annually. We have a strong volunteer program which includes more than 300 volunteers.

Our Mission: “We engage and inspire through the transformative power of live theatre.”

Culture Statement

For more than 40 years, creativity and community have been the foundation of the Denver Center for the Performing Arts’ success. As a leading cultural organization in the Rocky Mountain West, we are actively participating in a cultural evolution of belonging and anti-racism. Our commitment to reflect the diversity and priorities of our community — in our workplace, audience and programming — has never been more present.

We believe that the theater can transform us — and be transformed by us. We invite you to be part of our Team.

Job Purpose

This position is responsible for engaging in different IT projects across the organization. Engagement can include designing, developing, implementing, and supporting mission-critical enterprise Business Intelligence (BI) reports, dashboards, and data analysis. This position will work with cross-functional teams to gather and document reporting requirements to design, develop, test, and implement reports, lists, and dashboards that utilize underlying data stores/data warehouses/data marts. Additionally, this position will play a role in configuring, building, and testing BI reports and assisting in data needs within the ticketing platform. The teammate in this position will also play a role in developing standards, establishing guidelines and best practices for BI development and maintenance, as well as consult on new and ongoing analysis efforts.

Duties and responsibilities

Essential duties include but are not limited to:

• Create, test, and manage complex SQL queries to extract data from operational systems.

• Develop and maintain data reports to host on web- platforms such as CRM’s, Power BI, Financial systems, etc.

• Partner with end users to gather project requirements, analyze needs and process flow and develop user-oriented data solutions

• Design, develop, and deploy Power BI and Sisense dashboards to meet business needs.

• Release approved stored procedures, dashboards, and reports to production and assist in operational release cycles.

• Acquire and abstract primary or secondary data from existing internal or external data sources

• Under the guidance of department leadership, interpret data and develop recommendations based on findings

• Interact regularly with management and clients to constantly improve ETL processes, data marts, reporting and dashboard services

• Design, develop, test, and maintain BI reports within DCPA systems

• Assist with configuring, updating, and maintaining changes within ticketing system

• Develop, edit, and maintain documentation related to this role’s and the department’s workflows and processes.

• Collaborate with end-users and IT to ensure data integrity and data security.

• Be available for scheduled on-call rotation as needed

• Night and weekend work as needed

Qualifications

Must be detail oriented, with strong multi-tasking and troubleshooting abilities. Excellent communication, self-management, quality assurance and organizational skills.

Qualifications include:

• Bachelor’s degree in Business Intelligence or other data related field or equivalent data related professional experience required
• 2+ years of additional experience developing BI solutions built on the Microsoft SQL Server Business Intelligence stack such as SSIS, SSRS, and SSAS Proficient in SQL Server Integration Services (SSIS) and Transact SQL (T-SQL)
• Experience with data visualization tools such as Power BI or Sisense
• In-depth understanding of database management systems and extract, transform, load (ETL) framework
• Strong understanding of core schemas and data structures, including the ability to design and implement extract, load, transform (ELT) data pipelines
• Extensive knowledge of relational databases and building custom SQL queries
• Ability to communicate with project management team and department leadership throughout the project lifecycle and support development of BI dashboards and reports
• Ability to communicate complex technical information to non-technical users in a thorough and clear fashion.
• Strong understanding of complex stored procedures, views, data aggregation/manipulation through table joins/queries, database design, normalization and de-normalization techniques

Supervisor responsibilities

None

Working conditions

This position operates in a professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines.

Physical requirements

While performing the duties of this job, the employee is regularly required to talk or hear. The employee frequently is required to stand; walk; use hands to handle or feel; and reach with hands and arms.

Working conditions

Office or training room environment with occasional training in theatre show areas. Sitting, standing, working indoors and working on computers or at a desk. Sitting, standing, working indoors and working on computers and phones at a desk.

Duties are primarily performed in a general office setting.

Compensation

$75,000.00 - $85,000.00 annually

Benefits

Full time positions include the following benefits:

Medical, Dental, Vision, Disability, Flexible Spending Accounts, Life Insurance and Pet Insurance

401k Plan with employer contributions

Time off benefits including personal days, sick days, vacation days and 10 paid holidays.

The DCPA is located in Denver, CO and all roles are based at our on-site location: 1101 13th Street, Denver, CO 80204. Some roles at the DCPA may be eligible for hybrid work options. More information is available through the interview process.

The DCPA does not require applicants to disclose age, date of birth or dates of attendance and/or graduation from an educational institution in their application for employment. Applicants may redact these and other applicable dates from their resume, transcript, and any other material that they submit as part of their application for employment.

In order to provide high quality, culturally competent care to our patrons, students, guests and team members, it is of highest importance that our hiring practices reflect our values by offering an environment that celebrates diversity and embraces inclusion. All of our team members – regardless of race, ethnicity, sexual orientation, gender identity, age, language, abilities/disabilities, socioeconomic status, geographic region, or other defining characteristics – should feel welcome and valued.