BI Analytics Engineer Power BI & SQL Dashboards (Hybrid)

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process. Business Intelligence Developer Full Time Professional Denver, CO, US 6 days ago Requisition ID: 1613 Salary Range: $75,000.00 To $85,000.00 Annually The application window for this position has an anticipated end date of 06/01/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, musical, 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 theatre 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, and 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. 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. 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. 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. Compensation $75,000.00 - $85,000.00 annually 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. #J-18808-Ljbffr