Business Intelligence Analyst - Department of Medicine (System Applications at Oregon Health & Science University

, , United States -

Full Time

Start Date

Immediate

Expiry Date

29 Jul, 26

Salary

157454.0

Posted On

30 Apr, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Business intelligence, Data analysis, SQL, Epic Clarity, Epic Caboodle, Business Objects, Power BI, Azure, Data warehousing, Dimensional modeling, Requirements gathering, Project management, SDLC, Technical documentation, Mentorship, Report development

Industry

Higher Education

Description

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 Solution Development, Testing, and Training Use business requirements to develop BI solutions, including ad hoc operational and analytical reports, dashboards, and scheduled reports. Develops BI solutions using the following tools: Business Objects: BOBJ Web Intelligence and Crystal Epic: Reporting Workbench reports & templates, Radar dashboards, SlicerDicer analyses, Column Editor, PAF creation, CER rules. Clarity and Caboodle data warehouses Azure and Power BI Identifies opportunities for leveraging existing reporting assets to meet business requirements. Works closely with other OHSU IT staff to meet expectations for design reviews and coding standards. Provides issue resolution during Quality Assurance / User testing. Troubleshoot and analyze data processing failures and data issues using Chart review, Record Viewer, Clarity Data dictionary, and Caboodle Data Dictionary. Work through established processes to resolve system or data problems, and communicate updates and status to affected groups. Recommend changes to data models and metadata models to improve existing structures and code to increase performance, reliability, and efficiency. Provides technical expertise departmental analysts and clinical customers to improve user experience. Request migration of solution object through the SDLC. Validating and testing with the customer as frequently as necessary to get sign-off that the solution meets the requirements. Business Analysis Conduct discovery sessions with end users, front line staff, leadership, Workflow Analysts, and Informaticians to gather and document detailed requirements that inform the design and development of new or modifications to existing BI solutions. Workflow and Data analysis for incoming requests. Profiling of source data to identify data lineage, source tables, data definitions and business rules. Solution design: Taking into consideration options of existing assets, tools and report structure/format that best meet the customer requirements, department direction, and policy. Review Epic Userweb, Epic hosted foundation, and TS support to leverage Epic foundation and Epic integrated solutions when possible. Project Management, Tool Leadership, and Mentorship Serve as clinical BI content experts for cross-department projects such as new developments, upgrades or migration efforts. Primary representation for Clinical BI in division and department level projects; will include impact analysis of Clinical BI stewarded content, the development of project plans, assignment and/or ownership of project tasks, oversight of project task executions, status reporting to leadership. Leading the creation, maintenance, and improvement of standard work and process documentation. This includes all reference documentation categorized as a responsibility of a BIAA analyst in the BIAA RACI Matrix. This documentation will serve as the knowledgebase for all junior staff. Expert level understanding of BIAA toolset, serving as the go-to technical expert in an ETL or BI application. Mentorship of junior staff, division managers, medical directors, and other department leadership on BI tools, analytics, and development processes. Production Support and Continuous Improvement Respond to requests from Department of Medicine customers, to fix issues or apply enhancements to existing production reports. Communication with the customer to get clarification on support needs. Perform high level data analysis and initial sizing of the work to be done. Facilitate and coordinate the solution with other groups, e.g. Workflow, BIAA and other IT groups, as needed. Design, develop and test the solution. Work with the Customer to validate the solution and close the Ticket. Coordinate the migration of the changed report objects. Continually work to improve existing processes and daily work. Log improvement opportunities for department or system. Facilitate the prioritization of improvement opportunities with organizational leadership. Propose improvement plans to leadership. Other duties as assigned. Required Qualifications Education and Experience Master’s degree in computer science, a related field, or a clinical field and four years of 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 of 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 of 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. Minimum four years paid work experience as Data Analyst, Data Engineer, or BI Developer (or equivalent classification). Four years of 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. 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 present. Experience mentoring and training junior team members and customers. Certifications Epic Clarity/Caboodle Certifications within 6 months of hire. Preferred Qualifications Four or more years of current experience with Epic applications and/or the Epic Clarity environment. Four years experience developing Epic Radar Dashboards. Four years experience developing Epic Reporting Workbench reports and templates. Two or more years experience with Epic SlicerDicer. Two or more years of experience with Epic Caboodle Data Warehouse. Analytics experience at an academic medical center or healthcare related organization. Experience with utilizing star schema data stores as the basis for report development. Two years experience with developing Business Objects Universes using the Information Design Tool (IDT). Two years experience with developing in Tableau. Business Objects. Microsoft SQL Server Certification. Data modeling Certification. Azure Data Analyst or Data Engineer. Epic Clarity Certification. Epic Caboodle Certification. Epic RWB Certification. Epic Radar Certification. Additional Details Benefits Healthcare for full-time employees covered 100% and 88% for dependents. $50K of term life insurance provided at no cost to the employee. Two separate above market pension plans to choose from. Vacation - up to 200 hours per year dependent on length of service. Sick Leave - up to 96 hours per year. 9 paid holidays per year. Substantial Tri-Met and C-Tran discounts. Employee Assistance Program. Childcare service discounts. Tuition reimbursement. Employee discounts to local and national businesses. Why apply to OHSU? We are Oregon's only public academic health center. In addition to caring for patients, we lead groundbreaking research. We also train the next generation of health care professionals. As Portland's largest employer, we give you opportunities to learn and advance in a system of hospitals and clinics across Oregon and Southwest Washington. All are welcome. OHSU welcomes people of all ages, ethnicities, genders, national origins, religions and sexual orientations. We are striving to build an anti-racist, multicultural institution and encourage people with diverse backgrounds to apply. To request reasonable accommodation, contact askhr@ohsu.edu

Responsibilities

Develop and maintain business intelligence solutions, including reports and dashboards, to support clinical and operational decision-making. Provide technical expertise, mentorship to staff, and lead cross-departmental projects while ensuring data integrity and system performance.