Collaborate 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.
Gather requests for new reports and coordinate with customers to identify and document detailed requirements.
Design and develop reporting solutions that meet customer needs while adhering to OHSU Finance and BIAA standards.
Develop and monitor reporting using systems such as Power BI, Epic Reporting Workbench, SlicerDicer, and to a lesser extent, Business Objects Webi.
Analyze hospital & professional, along with clinical data to deliver robust data visualizations, dashboards, and reports to be leveraged by OHSU customers.
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.
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.
Research and recommend improvements in workflow, documentation, or alternative solutions.
Create data visualizations and self-service solutions using Microsoft PowerBI.
Write complex queries and run reports from the various OHSU data warehouses.
Optimize SQL code for efficient execution.
Distribute monthly, special quarterly, and annual reports as requested.

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

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.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLdata visualizationreporting solutionsdata analysisdata extractiondata integritydata qualitydimensional modelingcomplex queriesworkflow improvement

Soft Skills

communicationanalytical skillsproblem-solvingcollaborationcustomer engagementrequirements gatheringproject managementrecommendation skillstechnical advisingresearch skills

Certifications

Epic Clarity Caboodle PaletteMicrosoft PowerBI Data Analyst Professional Certificate