Junior Business Intelligence Developer

The application window for this position has an anticipated end date of02/07/2024.

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 and data analysis. This position will work with cross-functional teams to gather and document reporting requirements to design, develop, test, and implement reports 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.

Duties and responsibilities

Essential duties include but are not limited to:

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

• Develop ETL processes to import data into reporting and Business Intelligence architecture, in line with current data loading architecture or on an ad hoc basis.

• Develop and maintain data reports to host on web-based such as CRM systems and Power BI

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

• In collaboration with Senior Business Intelligence Developer, 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

• Performs independent audits and reviews and validates databases to ensure data integrity

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

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

• Be available for scheduled on-call rotation

• 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:

• 2+ years of experience as Business Intelligence Developer with a background in data concepts (e.g., dimensional modeling) and data mining
• 2+ years’ 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
• Understanding of data structures, including the ability to design and implement extract, transform, load (ETL) data pipelines.
• Ability to communicate with project management team and Senior Business Intelligence Developer throughout the project lifecycle and support development of BI dashboards and reports.
• Understanding of 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. Considerable evening work, attends many functions city-wide, some travel.

Duties are primarily performed in a general office setting.

If the job requires a person to work in special working conditions this should be stated in the job description. Special working conditions cover a range of circumstances from regular evening and weekend work, shift work, working outdoors, working with challenging clients, and so forth.

Physical requirements

While performing the duties of this position, the employee is regularly required to talk or hear. The employee frequently is required to use hands or finger, handle, or feel objects, tools, or controls. The employee is occasionally required to stand; walk; sit; reach with hands and arms; climb or balance; and stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this position include close vision, distance vision, color vision, peripheral vision, and the ability to adjust focus. The noise level in the work environment is usually moderate.

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.

Work from home options are available.

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.