Business Intelligence Developer Senior Professional through Principal

Business Intelligence Developer - Senior Professional through Principal - 39367 University Staff

University of Colorado Anschutz Medical Campus

Department: Psychiatry

Job Title: Business Intelligence Developer - Senior Professional through Principal Professional

Position #: 00846219 - Requisition #: 39367

Job Summary:

The BI Developer is the Department of Psychiatry's Business Intelligence professional and is responsible for analyzing, reporting, visualization & dashboarding in key domains including finance, revenue cycle, clinical operations, quality & productivity, human resources, clinical research. The BI Developer works under the supervision of the BI Manager to create and maintain databases, database objects, reports, Epic artifacts, and dashboards and performs analyses using these functions.

The BI Developer collaborates closely with key stakeholders in the Department to ensure the intelligence and analyses are accurate, user-friendly, and impactful. To be able to work independently, BI Developer must have an intimate knowledge of finance (including but not limited to sponsored projects, clinical, and auxiliary enterprise finance), accounting, revenue cycle, clinical operations, and human resources. The overall goal of this position is to advance the Department's capacity for data-driven decision making in key domains to achieve the vision of Brain Health for All, For Life.

Key Responsibilities:

• Achieve and maintain Epic certifications that enable access to data and dashboarding capabilities at hospital partners (e.g., Children's Hospital Colorado and UCHealth).
• Maintain and improve unified system for FTE planning and clinical FTE reporting.
• Develop research project-specific reports and dashboards with PI and stakeholders as prioritized by Data Governance Committee
• Create and maintain end user documentation that defines fields, metrics, business rules, and best practices to allow users to use reporting and analytics efficiently and effectively.
• The BI Developer may have other duties and responsibilities as assigned such as user training, change management, presentations, and professional development.

Work Location:

Hybrid - This role is eligible for hybrid status. Some work will be in-person at the Anschutz Medical Campus in Aurora, Colorado. The employee must be in the United States.

Why Join Us:

The Department of Psychiatry is one of the largest units in the UCD-SOM and is comprised of 5 Divisions. The CU Department of Psychiatry sets the standard for Education and Training of leaders in psychiatry and mental health care, conducts ground-breaking research that aims to eradicate suffering due to psychiatric and substance use disorders, provides ready access to state-of-the-art mental health preventions and interventions across the continuum of care, and collaborates with the community and other key stakeholders to promote well-being among all Coloradans. We accomplish this vision in a manner that respects, values and advocates for the dignity and worth of each individual and family. Please see website for additional information: https://medschool.cuanschutz.edu/psychiatry/PatientCare/colorado-center-for-women's-behavioral-health-wellness

Qualifications:

Minimum Qualifications:

Intermediate Professional:

• A bachelor's degree in business intelligence, information technology, data analysis, statistics, finance, public health, or a directly related field from an accredited institution.
• 1+ year of experience creating reports, visualizations, and/or analytics within a large organization (serving over 100 employees).

Senior Professional:

• A bachelor's degree in intelligence, information technology, data analysis, statistics, finance, public health, or a directly related field from an accredited institution.
• 2+ years of experience creating reports, visualizations, and/or analytics within a large organization (serving over 100 employees).
• A combination of education and related technical/paraprofessional experience may be substituted for the bachelor's degree on a year for year basis.
• An advanced degree (Masters or Doctorate) may be substituted for experience on a year for year basis if the degree is in a field of study directly related to the work assignment.

Applicants must meet minimum qualifications at the time of hire.

Preferred Qualifications:

• Currently possesses all required certifications listed within the Conditions of Employment: Epic Cogito, Clarity, Caboodle, and one of Clinical Data Model or Revenue Cycle Data Model.
• Experience with business intelligence tools such as PowerBI or Tableau. With experience integrating such tools with various database technologies.
• Experience utilizing SQL, DAX, or some other language in relational databases in a healthcare context.
• Experience with Epic Caboodle data warehouse and extending Caboodle.
• Experience with Epic Clarity and creating custom tables enriched by Clarity data using scheduler and stored procedures.
• Experience with non-Epic enterprise data warehouses using various database technologies such as Microsoft and Oracle.
• Experience creating and maintaining stored procedures, tables, scheduled jobs, and other database artifacts.
• Experience using PeopleSoft Finance and HR, Microsoft AX, or other systems used by CU Anschutz or its affiliates.
• Experience in behavioral health.
• Experience with Power Automate, DAX, VBA, Python, and/or R.
• Experience in finance, revenue cycle management, clinical operations, and human resources practices at CU Anschutz or its affiliates.
• Experience in academic medicine or healthcare.
• Experience in mental health and knowledge of mental health billing.

Knowledge, Skills and Abilities:

• Advanced level knowledge of Structured Query Language (SQL) and Power Automate, DAX, VBA, Python, and/or R.
• Expert level knowledge of Microsoft Access, Power BI, and Microsoft Excel.
• Knowledge of Microsoft 365 suite including Outlook, Word, Power Point, and Teams.
• Proficiency with Epic Cogito, Clarity, and Caboodle.
• High level of analytical ability.
• Experience with or knowledge of research methods, data gathering and dissemination.
• Ability to communicate effectively, both in writing and orally.
• Ability to work independently and under minimal supervision.
• Ability to establish and maintain effective working relationships with employees at all levels throughout the institution.
• Outstanding customer service skills and ability to navigate competing priorities and demands from stakeholders.