This position is a remote position where the analyst resides in the United States. As part of the Business Intelligence & Advanced Analysts (BIAA) division of the Information Technology Group (ITG), this position supports the mission of ITG to develop, implement and maintain technology-based services and solutions enabling Oregon Health and Science University (OHSU) to effectively manage information to accomplish its missions.

 

This position collaborates with customers to lead the analysis, design, development, and support of complex computer applications and systems, as well as clinical and operational workflows related to Hospital Billing, Professional Billing, and Epic Integrated Reporting. The analyst gathers requests for new reports and coordinates with customers to identify and document detailed requirements. The analyst designs and develops reporting solutions that meet customer needs while adhering to OHSU Finance and BIAA standards.

Solution Development and Management

• 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.

Planning, Analysis, Design and Development

• 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.

Report Generation

• 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.
• Participates with Information Technology Group staff in planning, designing, and implementing new or enhanced information systems.

Account Management/Project Coordination

• 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.

Education and Experience

• 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.

Knowledge, Skills, and Abilities

• 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 3^rd 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.

Certifications

• Certification or Proficiency within 9 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.

Monday - Friday, 8:00am - 5:00pm (PST). Must be available during ITG core hours of 9 am – 3 pm and work a full standard workday.

Location: Remote.

 

Benefits AFSCME

• 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.

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