Oregon Health and Science University (OHSU) is Oregon's only public academic health center, dedicated to patient care, groundbreaking research, and training future healthcare professionals. The Business Intelligence Analyst role involves collaborating with customers to analyze, design, develop, and support complex computer applications and systems, particularly in relation to hospital billing and reporting solutions.

Responsibilities:

Development and monitoring of reporting using systems such as Power BI, Epic Reporting Workbench, SlicerDicer, and to a lesser extent, Business Objects Webi
Analize hospital & professional, along with clinical data to deliver robust data visualizations, dashboards, and reports to be leveraged by OHSU customers
Test and make needed changes when updates are implemented
Ensure data integrity in current system and when creating and moving to new systems
Provide recommendations for selection of systems for new programs and projects
Meet with customers to translate complex requests for reporting, system, and data needs and fulfill, validate, revise, deliver, and maintain the solution
Identify and advise on technical limitations, alternatives, data extraction methods, and create data collection tools as needed
Collaborate with analysts, developers, managers, and leadership to define requirements and inform priorities and needs
Perform complex research in complicated data environments and front-end systems to ensure correct data selection and validity
Interpret results and provide insights, consultation, and decision support for customers
Research and recommend improvements in workflow, documentation, or alternative solutions
Collaborate with Business Intelligence Architects for the development and/or maintenance of reporting solutions
Directly support the OHSU Finance team by helping to create on-demand detailed queries of financial and clinical data in Epic Clarity & Caboodle. This requires a comprehensive understanding of data tables structures and business processes at the lowest level of detail
Coordinate with finance and operations stakeholders to respond to organizational business analysis and understands the connect between operations and finance
Requires in depth/advanced knowledge of Epic Integrated Analytics (Reporting Workbench, Radar, SlicerDicer (i.e. components, template modification, filters, variable creation, formatting)
Create data visualizations and self-service solutions using Microsoft PowerBI
Write complex queries and run reports from the various OHSU data warehouses
Alternate and translate between different database platforms and languages
Optimize SQL code for efficient execution
Explore and explain outcomes, significant trends, and impact
Distribute monthly, special quarterly, and annual reports as requested
Manage confidentiality of highly sensitive subjects
Research and implement improved and/or automated distribution methods
Respond to report consumers to explain significance of reports and impact of results
Test and review with every Epic upgrade. Follow best practices and optimization to limit system impact
Identify workflows that would most benefit from embedded reporting and make recommendations on new methods and practices
Manage relations between customers and data teams
Document and delegate report requests, troubleshoot problems with reports or other aspects, collaborate with customers to determine needs and partnerships
Ensure timely communication and delivery of reports
Other duties as assigned

Requirements:

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
Prior work as a reporting, data, or business intelligence analyst, where responsibilities included: Interfacing directly with business staff, Experience gathering and documenting business requirements and planning and managing projects, Providing recommendations on appropriate use of data, Identify gaps or data quality issues
Proven communication, analytical, and problem-solving skills
Experience using relational databases as a source for reporting
Understand all phases of a system development lifecycle and data analysis
Ability to read, write and maintain SQL code
Experience gathering and documenting business requirements
Experience developing in 3rd party tools such as SAP Business Objects/Webi, IBM Cognos or MS PowerBI, with PowerBI preferred
Operational knowledge of Data Warehousing and Data Marts, including dimensional modeling concepts
Certification or Proficiency within 6 months of hiring in one of the following: Epic Clarity, Caboodle, Palette (Reporting Workbench, Radar, SlicerDicer)
Microsoft PowerBI Data Analyst Professional Certificate within 9 months of hire
Experience developing at an academic medical center or healthcare related organization
Two years' experience authoring reporting from Epic Clarity and Caboodle
Knowledge of healthcare ambulatory data, including clinical, financial and operational
Experience with developing in Epic Reporting tools such as Radar, SlicerDicer, Reporting Workbench
Ability to read and explain a relational data model
Three years of experience developing in Epic Integrated Analytics (Reporting Workbench, Radar, SlicerDicer)
Three years of experience developing in T-SQL
Three years of experience creating reports and dashboards in MS Power BI
Business Object Webi and Universe/IDT development knowledge
Experience with Epic applications and/or the Epic Clarity environment
Epic certification in: Cogito, Clarity Data Model, Caboodle Data Model, Revenue Data Model
Microsoft PowerBI Data Analyst Professional Certificate or equivalent

Senior Analyst, IS Business Intelligence

About this role