Business Intelligence Analyst, Emergency Medicine (Systems/Applications Analyst, Sr)

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. 

Function/Duties of Position

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.

 

Positioned at the confluence where the business of patient care meets the need for insights and data driven decisions, this role provides the opportunity to use data analysis and development skills to improve the health and well-being of Oregonians and beyond. 

 

This position will support the OHSU Emergency Medicine Department’s reporting and analytics needs across a variety of data domains, including: clinical, operational, revenue cycle, staffing, and compensation. 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 BIAA peers, OHSU Emergency Medicine Department 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.

 

Candidates must be able to excel in a collaborative environment, where open and honest communication drives innovation and process improvement. 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.

Preferred Qualifications

Education: 

Master’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

 

Bachelor’s degree in computer science, a related field, or a clinical field and six 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 seven years work related experience in the information technology field or a combination of clinical or operational healthcare environments; OR

 

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

 

Equivalent combination of education and experience where one year of experience will be substituted for an Associate’s degree and two years of experience will be substituted for a Bachelor’s degree.

 

Experience: 

• Minimum four years paid work experience as Data Analyst, Data Engineer, or BI Developer (or equivalent classification).
• Four years experience with developing reports an dashboards in Business Objects Web Intelligence or equivalent toolset.
• Experience with facilitating and documenting system requirements sessions.
• Experience creating technical documentation of reports and data/report models.
• Minimum five years working with relational databases.
• Experience with utilizing star schema data stores as the basis for report development.

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 interpersonal skills - able to resolve conflicts and to problem solve between parties.
• Demonstrated evidence of strong written and verbal communication skills.
• Ability to manage competing priorities.
• Ability to work independently; willingness to serve as a positive and professional role model.
• Must have demonstrated record of reliable attendance, punctuality and proven successful performance in past and presen