This a Full Remote job, the offer is available from: United States, Norway, Oregon (USA)
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 and Advanced Analytics (BIAA) Division ensures that the informational assets of the OHSU enterprise are leveraged to enhance financial, clinical, operational, and research decision-making.
This position functions as a Strategic Account BI Developer assigned to the Casey Eye Institute (CEI), supporting clinical analytics and operational reporting priorities under a collaborative MOU between CEI and BIAA.
Positioned at the confluence, where the business of patient care meets the need for insights and data driven decisions, this role provides the opportunity to use data analysis and development skills to improve the health and well-being of Oregonians and beyond.
Function/Duties of Position:
Solution Development, Testing, and Training
Use business requirements to develop BI solutions, including ad hoc operational and analytical reports, dashboards, scheduled reports.
• Microsoft Azure: PowerBI.
• Business Objects: BOBJ Universes, Web Intelligence and Crystal Reports.
• Epic Clarity and Caboodle data models.
• Epic: Reporting Workbench reports & templates, Radar dashboards, SlicerDicer analyses, Analytic Registries Column Editor, PAF creation, CER rules.
• 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 to departmental staff and customers to improve user experience.
• Facilitate the implementation and migration of the solution objects into production.
• Validating and testing with the customer as frequently as necessary to get sign-off that the solution meets the requirements.
• Provide training as necessary to the customer of the new report solution.
Business Analysis
Conduct discovery sessions with end users, front line staff, leadership, analysts, engineers and informaticians to gather and document detailed requirements that inform the design and development of new or modifications to existing BI solutions.
• Data analysis and profiling of source data to identify source tables, data definitions and business rules.
• Solution design. Taking into consideration options of tools and report structure/format that best meet the customer requirements, department direction, and policy.
• Leveraging Epic Userweb, Epic hosted foundation, and TS support to leverage Epic foundation and Epic integrated solutions when possible.
Production Support and Continuous Improvement
Respond to requests from 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.
• Identify improvement opportunities for department or system.
• Facilitate the prioritization of improvement opportunities with organizational leadership.
Project Management, Tool Leadership, and Mentorship
Serve as clinical BI content experts for cross-department projects such as Upgrades or Migration efforts. Mentorship of junior staff on Tools, subject matter and Process.
• Primary representation for Clinical BI in division level projects; will include impact analysis of Clinical BI stewarded content, the development of a mitigation plan, 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.