Business Intelligence Developer, Sr

OU Medicine • Denver, CO

288d

About The Position

The Senior Business Intelligence (BI) Reporting Developer is responsible for the strategic design and implementation of highly complex report libraries and universes used by all departments within the enterprise. The Senior BI Developer creates analytics content based upon input from BI Analysts and company leadership to enhance business decision making capabilities. The Sr. BI Developer will develop and enhance the underlying data models used by BI Analysts, including a data warehouse or multi-dimensional system and is skillful in aggregating large data from multiple systems. The Sr. BI Developer is responsible for aggregating data from multiple sources into an efficient data solution. Provides leadership and mentoring to BI team and end users.

Requirements

• Bachelor's degree in engineering, physics, computer sciences, math, information systems, statistics, or related field.
• 5 or more years of experience developing with MS SQL and developing with BI Software.
• Demonstrated experience managing and administering enterprise level BI systems.

Nice To Haves

• Master's degree in above fields or MBA preferred.
• Healthcare experience preferred.

Responsibilities

• Leads the analysis, design, implementation, and maintenance of enterprise reporting applications and reporting libraries/universes.
• Develops cubes, complex reports, interactive dashboards, and report libraries/universes.
• Creates standard SQL stored procedures, views and functions using best practices and efficient code.
• Performs performance tuning on reports and database objects.
• Provides oversight for enterprise EHR report library based out of Reporting Workbench.
• Manages EHR databases by providing support for ETL related issues, errors and both scheduled / emergency related maintenance requests.
• Administrative responsibilities for BI servers.
• Plans scalability, redundancy and disaster recovery for BI services.
• Provides leadership, mentoring and guidance to other developers and IT staff.
• Meets with Business Intelligence Analysts and report requesters to understand their data needs.
• Identifies and reviews the appropriate technological solutions for various reporting needs.
• Understands the key business metrics for assigned service lines.
• Creates reports and dashboards using third‐party report writing tools such as Crystal reports, SSRS, PowerBI or Tableau.
• Modifies and optimizes existing reports, as necessary.
• Reviews peer reports for validity.
• Tests report build in a specified testing environment and performs volume testing in live environments.
• Remains abreast of vendor-specific upgrades and documentation, and determining how to implement the changes.
• Remains abreast of industry best practices.

Benefits

• PTO
• 401(k)
• medical and dental plans

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Industry: Ambulatory Health Care Services
• Education Level: Bachelor's degree