Business Intelligence Analyst (System Application Analyst)

Department Overview

The mission of the Information Technology Group (ITG) is to provide and support technology and information services that enable OHSU to be a national leader in health and science innovation. The work of the Business Intelligence Management Division (BIAA) ensures that the informational assets of the OHSU enterprise are leveraged to enhance financial, clinical, operational, and research decision-making.

Function/Duties of Position

This position will support reporting and analytics needs for OHSU's Primary Care and Family Medicine practices, focusing on key data domains that inform clinical operations, access, and quality improvement.

 

This position is responsible for developing, implementing, and maintaining a variety of business intelligence solutions for reporting on and accessing healthcare information.  These solutions will be focused in Epic Cogito Analytics, Microsoft Azure, and SAP Business Objects.  Epic Cogito Analytics development includes: Reporting Workbench, CER Rules, PAF Column Creation, Radar Dashboards, Analytic Registries and SlicerDicer.  Microsoft Azure development includes: PowerBI.  SAP Business Objects development includes: BOBJ Universes, Webi Reports and Crystal Reports.  The ideal candidate will possess a good understanding of healthcare terminology, strong SQL skills, experience navigating Epic and using Record Viewer for Analysis, and experience developing reports using the Epic Caboodle Data Warehouse and Epic Clarity Data model.

 

The position will work closely with OHSU Health leadership, clinical and operational partners, vendors, IT staff, and project managers to document scope and requirements, as well as develop, validate, test, and maintain BI solutions.  This work will require leveraging existing OHSU BI assets and standard content when appropriate.  New Solution development will follow the OHSU software development methodology and adhere to data governance, data security, change management, and report standards.  The incumbent will be required to facilitate communication to stakeholders horizontally and vertically through the organizations. 

 

The Clinical Analytics and reporting team values a collaborative environment, where open and honest communication lends to creative solutions to complex business problems.  The ideal candidate will seek out opportunities to lead and lift others by offering consulting and providing technical expertise to assist clinical BI end users and fellow team members.

 

This position is also responsible for detailed technical analysis to assure the availability and accuracy of data contained in the BIAA supported data warehouses or accessed through BIAA supported BI systems. This will include availability for rotation through support required for operational process improvement, software upgrades, and project go lives.

Required Qualifications

Education:

Master’s degree in computer science, a related field, or a clinical field and two years work related experience in the information technology field or a combination of clinical or operational healthcare environments; OR

 

Bachelor’s degree in computer science, a related field, or a clinical field and four years work related experience in the information technology field or a combination of clinical or operational healthcare environments; OR

 

Associate’s degree in computer science, a related field, or a clinical field and five years work related experience in the information technology field or a combination of clinical or operational healthcare environments; OR

 

Six years work related experience in the information technology field or a combination of clinical or operational healthcare environments

 

Experience:

• Minimum two years paid work experience as Report developer (or equivalent classification).
• Two or more years of current experience with Epic applications and/or the Epic Clarity environment.
• Two years experience with facilitating and documenting system requirements sessions.
• Experience creating technical documentation of reports and data/report models.
• Experience with querying relational databases and star schema data stores.

Job Related Knowledge, Skills, and Abilities:

• Proven communication, analytical, and problem solving skills
• Experience with Systems Development Life Cycle (SDLC) processes and procedures
• Ability to read and explain a data model
• Ability to read, write and maintain SQL Code
• Experience gathering and documenting business requirements
• Experience planning and managing small projects
• Knowledge of data warehousing architecture and dimensional modeling concepts
• Exceptional customer service skills - both in person and on the phone.
• Exceptional