[Remote] Business Intelligence Analyst (System Application Analyst, Sr)

Note: The job is a remote job and is open to candidates in USA. Oregon Health & Science University (OHSU) is a leading academic health center focused on health and science innovation. They are seeking a Business Intelligence Analyst to leverage data analysis and development skills to enhance decision-making in patient care, particularly supporting oncology service lines with reporting and analytics needs.ResponsibilitiesUse business requirements to develop BI solutions, including ad hoc operational and analytical reports, dashboard applications, and scheduled reportsTranslate clinical and operational requirements into standardized metrics, KPIs, and dashboard designs that support care delivery, quality improvement, and performance monitoringDevelops 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 BIIdentifies opportunities for optimizing solutions and leveraging existing reporting assets to meet business requirementsStandardizes metric definitions and ensures alignment with organizational, regulatory, and oncology-specific reporting frameworksWorks closely with other KCI Data Operations and OHSU IT staff to meet expectations for design reviews and coding standardsProvides issue resolution during Quality Assurance / User testingTroubleshoot and analyze data processing failures and data issues using Chart review, Record Viewer, Clarity Data dictionary, and Caboodle Data DictionaryWork through established processes to resolve system or data problems, and communicate updates and status to affected groupsRecommend changes to data models and metadata models to improve existing structures and code to increase performance, reliability, and efficiencyProvides clinical informatics and technical expertise to departmental analysts, engineers and clinical customers, including guidance on metric interpretation, dashboard utilization, and data-driven decision-makingRequest migration of solution object through the SDLCValidating and testing with the customer as frequently as necessary to get sign-off that the solution meets the requirementsEnsures that validated outputs accurately reflect clinical workflows, operational definitions, and intended use in decision-makingDelivers end-user training on dashboards, reports, and metrics, including education on appropriate interpretation and limitations of the dataConduct discovery sessions with KCI/KCG 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 solutionsFacilitate discussions to define clinical and operational metrics, ensuring alignment with institutional standards, quality programs, and oncology-specific initiativesWorkflow and Data analysis for incoming requestsAssess current-state vs. future-state workflows to ensure proposed reporting solutions align with clinical practice and operational goalsProfiling of source data to identify data lineage, source tables, data definitions and business rulesDesign intuitive, user-centered dashboards and reporting solutions that support clinical workflows and enable actionable insightsReview Epic Userweb, Epic hosted foundation, and TS support to leverage Epic foundation and Epic integrated solutions when possibleIncorporate clinical best practices and benchmark metrics when available to ensure consistency with industry standardsServe as a clinical informatics and analytics content expert, ensuring that data, metrics, and reporting outputs align with clinical intent and organizational prioritiesPrimary 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 leadershipLeading the creation, maintenance, and improvement of standard work and process documentation. This includes all reference documentation categorized as a responsibility of a joint KCI-BIAA analyst in the BIAA RACI Matrix. This documentation will serve as the knowledgebase for all junior staffExpert level understanding of BIAA toolset, serving as the go-to technical expert in an ETL or BI applicationProvides training/mentor assistance to lower-level analysts in support of Knight Data Operations effortsRespond to requests from KCI/KCG customers, to fix issues or apply enhancements to existing production reportsEvaluate enhancement requests for alignment with existing metric definitions, dashboard standards, and clinical prioritiesCommunication with the customer to get clarification on support needsPerform high level data analysis and initial sizing of the work to be done. Assess impact to existing metrics, dashboards, and downstream reportingFacilitate and coordinate the solution with other groups, e.g. Workflow, BIAA and other IT groups, as neededDesign, develop and test the solutionWork with the Customer to validate the solution and close the TicketCoordinate the migration of the changed report objectsContinually work to improve existing processes and daily workIdentify opportunities to improve metric standardization, dashboard usability, and data accessibility for clinical usersLog improvement opportunities for department or systemFacilitate the prioritization of improvement opportunities with organizational leadershipOther duties as assignedSkillsMaster'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; ORBachelor'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; ORAssociate'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; OREight years work related experience in the information technology field or a combination of clinical or operational healthcare environments; OREquivalent 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 degreeEpic Clarity/Caboodle Certifications within 6 months of hireMinimum three years paid work experience as Data Analyst, Data Engineer, or BI Developer (or equivalent classification)Demonstrated experience with developing reports and dashboards in Business Objects Web Intelligence or equivalent toolsetExperience with facilitating and documenting system requirements sessionsExperience creating technical documentation of reports and data/report modelsMinimum three years working with relational databasesExperience with utilizing star schema data stores as the basis for report developmentProven communication, analytical, and problem solving skillsExperience with Systems Development Life Cycle (SDLC) processes and proceduresAbility to read and explain a data modelAbility to read, write and maintain SQL CodeExperience gathering and documenting business requirementsExperience planning and managing small projectsKnowledge of data warehousing architecture and dimensional modeling conceptsExceptional interpersonal skills - able to resolve conflicts and to problem solve between partiesDemonstrated evidence of strong written and verbal communication skillsAbility to manage competing prioritiesAbility to work independently; willingness to serve as a positive and professional role modelMust have demonstrated record of reliable attendance, punctuality and proven successful performance in past and presentEpic Clarity CertificationEpic Caboodle CertificationEpic RWB CertificationEpic Radar CertificationBusiness ObjectsMicrosoft SQL Server CertificationData modeling CertificationAzure Data Analyst or Data EngineerFour or more years of current experience with Epic applications and/or the Epic Clarity environmentFour years of experience developing Epic Radar DashboardsFour years of experience developing Epic Reporting Workbench reports and templatesTwo or more years of experience with Epic SlicerDicerTwo or more years of experience with Epic Caboodle Data WarehouseAnalytics experience at an academic medical center cancer center or healthcare related organizationExperience with utilizing star schema data stores as the basis for report developmentTwo years of experience with developing Business Objects Universes using the Information Design Tool (IDT)Two years of experience with developing in TableauExperience with clinical quality metrics, registry reporting, or oncology-specific performance measures is strongly preferredExperience processing and analyzing oncology/ cancer care datasetsExperience with the following clinical care and operational data sets: Referrals, appointment scheduling, physician capacity, room capacity, etcFour years of experience with T-SQL coding and tuningBenefitsHealthcare 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.Company OverviewOHSU is a health and research university provides patient care, research, education of the next generation of health care. It was founded in 1887, and is headquartered in Portland, Oregon, USA, with a workforce of 10001+ employees. Its website is http://www.ohsu.edu/.