Business Intelligence Engineer (Application Engineer)
Oregon Health and Science University
April 14, 2018
The OHSU Business Intelligence & Advance Analytics (BIAA) division is embarking on a multi-year effort surrounding the operationalization of Epic\u2019s Caboodle Data Warehouse (CDW) on SQL Server. The operationalization of CDW will include OHSU\u2019s retirement of a legacy custom-built data warehouse known as OHSUDW that currently is housed on Oracle 12c. Within OHSUDW is essential reporting for our Clinical Transplant Services organization. This position will serve in an analyst/developer role to assure a successful transition of this reporting to CDW and relevant Epic-delivered solutions. In addition, this position is responsible for supporting Clinical Transplant Services reporting and related project efforts as directed by senior leadership of our Transplant organization.
This position is responsible for metadata, report, dashboard design and development utilizing SAP Business Objects and IBM Cognos software. Strong collaboration with Transplant in order to capture requirements and execute these through iterative development approaches such as Agile are hallmarks of this position. The ideal candidate will also possess a good understanding of healthcare terminology, the data model of Epic Caboodle Data Warehouse, Epic Clarity, and ETL tools such as SQL Server SSIS.
This position will work closely with Clinical Transplant Services, IT staff and project managers, gathering customer requirements using standard processes, and will develop, validate, test and maintain data and report documentation, contribute to security architecture design, report scheduling, framework/universe development, and implementation support. The person will facilitate communication upward and across project teams. Solution development will follow the OHSU software development methodology and adhere to data governance, data security, change management, and report standards. Interactions will include working directly with customers and team members on project and support issues, as well as facilitation of communication upward and across project teams.
This position is also responsible for detailed technical analysis to assure the availability and accuracy of data contained in the BIAA supported data warehouses and systems. This will include availability for rotation through an after-hours on-call support model as needed for upgrades, project go lives or to provide ongoing support of new systems that may have 24x7 support agreements. This will require a broad knowledge of OHSU BI systems and workflows.
Internal Number: IRC68690
About Oregon Health and Science University
As the state's only health and research university, OHSU brings together patient care, research, education of the next generation of health care providers and scientists and community service to improve the health and well-being of all Oregonians.The university is a conduit for learning for more than 2,800 students, providing training to interns, residents and fellows in postgraduate medical and research. It is the only place in Oregon that grants doctoral degrees in medicine, dentistry and nursing. OHSU cares for more than 251,000 patients each year from around the region and takes a leadership role in contributing to solutions involving the health of the state and the nation, such as health care access and transparency, ethics and workforce shortage. Beyond providing critical health care services, quality education and cutting-edge research, OHSU also is a key economic and social force in the Northwest. With an annual operating budget of $2.06 billion and more than 14,000 employees, OHSU is Portland?s largest employer. Its size contributes to its ability to provide... many services and community support activities not found anywhere else in Oregon. For more information visit http://www.ohsu.edu/xd/about/index.cfm