Oregon Health & Science University

Business Intelligence Engineer (Application Engineer)

Job Locations US-OR-Portland
Requisition ID
Position Category
Information Systems
Position Type
Regular Full-Time
Job Type
AFSCME union represented
Information Technology Group (ITG)
Salary Range
$90,685 - $125,663 Annually
HR Mission
Central Services
Drug Testable

Department Overview

Positioned at the confluence of critical patient care, hospital resource optimization, and data driven decisions, this role provides the opportunity to use data analysis and data engineering skills to improve the health and well-being of Oregonians and beyond.  OHSU’s Mission Control department has been an industry leader in the use of real-time streaming data to make a difference for patients and the teams charged with their care.  A chief goal of OHSU’s Mission Control department is to place more patients efficiently in order to provide more access to more patients across the region.
As a part of the OHSU Business Intelligence & Advanced Analytics (BIAA) division, this position is responsible for developing comprehensive data and analytics toolsets and interactive solutions for the OHSU Mission Control unit. This includes operational reporting and dashboards, real-time data flow creation and management, providing data and analysis in support of clinical quality and research initiatives, and related project efforts as prioritized by OHSU Mission Control leadership.
This person will be responsible for designing, developing, testing, implementing, and maintaining data and analytics solutions, including:
  • SAP Business Objects Web Intelligence for departmental reporting;
  • Dashboard and data visualization development in Azure BI Analytics and/or Tableau
  • ETL development using Epic’s Caboodle Data Warehouse and SQL Server Integration Services (SSIS);
  • SQL data extracts using T-SQL stored procedures and SSIS;
  • Views and stored procedures for reporting using Microsoft SQL Server and the Epic Clarity and Caboodle data models;
This position will be developing solutions primarily with Epic’s Cogito platform (Clarity and Caboodle), Microsoft SQL Server tools, and BusinessObjects. However, duties may extend to include exploration of new solutions leveraging Microsoft’s Azure DataFactoty, DataBricks, PowerBI, and additional analytics tools. Azure DevOps will be used for version control, code management, and code deployment. All development will observe the OHSU BIAA data governance policies and SDLC practices.
Candidates must be able to excel in a collaborative environment, where open and honest communication drives innovation and process improvement. The ideal candidate will seek out opportunities to lead and lift others by offering consulting and providing technical expertise to assist clinical BI end users and fellow team members

Function/Duties of Position

Data and Systems Engineering
  • Contribute to the growth of the OHSU Caboodle Data Warehouse architecture by designing, developing, testing, and implementing ETL.
  • Work with BI architects, developers, analysts, and customers to design, create, and publish data models, ETL processes, and metadata using the Epic Caboodle Console, SSIS, as well as third party ETL tools. 
  • Provide complete and consistent documentation of data warehouse content in the Caboodle Console to ensure that users can determine what data is available in the warehouse, how this data is defined, and lineage to Epic Clarity.
  • Document assets in the appropriate BI asset library.
  • Develop Epic Clarity and Caboodle data feeds using SSIS, ensuring data feeds have undergone appropriate security review, and are transported abiding by the guidelines of the information privacy and security office, as well as any further security requirements outlined in a business associates' agreement or data use agreement.
  • Explore new data flow solutions and opportunities using Microsoft Azure technologies (DataFactory, DataBricks, DataFlows, and Data Marts) and propose projects and solutions that leverage these technologies.
  • Troubleshoot and analyze ETL process failures, data anomalies and other ETL or data warehouse issues identified by automated monitoring, other developers, and end users. 
  • Work through established processes to resolve any system or data problems and communicate updates and status to affected groups.
  • Recommend improvements to ETL processes, tool sets, data models, and monitoring techniques to improve existing structures and code to increase reliability and efficiency.
  • Coordinate data integration projects with system architects, DBAs, and vendors.
  • Deploy data warehouse content using approved Azure DevOps systems and processes
Analysis and Reporting
  • Conduct discovery sessions with customers to gather and document detailed requirements that inform the design and development of new or modifications to existing BI solutions.
  • Data Analysis, data profiling and solution design.
  • Develop BusinessObjects BI solutions including scheduled reports, publications and ad hoc assets.
  • Dashboard and data visualization development in Azure BI Analytics and/or Tableau
  • Create and maintain metadata models (e.g., BusinessObjects Universes using Information Design tool - IDT).
  • Develop key metrics as prioritized by service line leadership
  • Develop roll up dashboards to provide insight into operational metric performance.
  • Provide datasets and advanced analysis.
  • Provide technical expertise to support end users developing ad-hoc queries and departmental reports. 
  • Work with customers to improve user interfaces for improved reporting.
  • Works closely with other BIAA staff to meet expectations for design reviews and coding standards. 
Production Support & Systems Management/Maintenance
  • Understand and utilize approved System Development Life Cycle (SDLC) systems, processes, and procedures. 
  • Respond to and track issues using Jira Service Desk
  • Manage projects by creating timelines, identifying risks and milestones, and provide status reporting to others as defined. 
  • Provide support to data warehouse developers, line-of-business analysts, and users to validate data in the data warehouse.
  • Investigate reported incidents and work to ensure the validity of the data warehouse.
  • Schedule and oversee the schedules and publications of report distributions to ensure that data are delivered only to the intended recipients at the intended time.
  • Maintain assets through system upgrades.
  • Provide documentation of delivered solutions to enable downstream support.
This position is currently 100% telework/remote and may include remote work long-term. Candidate must be able to work from home full-time initially.

Required Qualifications

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
  • Two or more years of paid work experience as a Systems/Application Analyst or Application Administrator.
Job Related Knowledge, Skills and Abilities (Competencies):
  • Knowledge of data warehousing architecture and dimensional modeling concepts. 
  • Ability to read, write and maintain SQL code at an advanced skill level.
  • Proven communication, analytical, and problem-solving skills.
  • Ability to manage multiple projects on an ongoing basis with excellent attention to detail.
  • Ability to accurately document system technical artifacts at a level of detail sufficient for ongoing production support.
Registrations, Certifications and/or Licenses:
  • Epic Clarity Data Model Certifications and Epic Caboodle Developer Certification within 6 months of hire.

Preferred Qualifications

  • Minimum of three (3) years SQL Server Experience, including SSIS and T-SQL, coding, performance tuning, and system optimization.       
  • Minimum of three (3) years with Microsoft SQL Server T-SQL
  • Minimum of five (5) years developing reports and dashboards.
  • Minimum of two (2) years of experience in a data warehouse environment

Additional Details

Please note: Effective Oct. 18, 2021, all OHSU employees are required to be fully vaccinated against COVID-19 unless they have an approved medical or religious exception. If you are hired by OHSU after Oct. 18, you will need to be fully vaccinated (or obtain an approved exception) prior to starting work, and need to provide proof of vaccination (or approved exception) within 10 days of starting work.

All are welcome

Oregon Health & Science University values a diverse and culturally competent workforce. We are proud of our commitment to being an equal opportunity, affirmative action organization that does not discriminate against applicants on the basis of any protected class status, including disability status and protected veteran status. Individuals with diverse backgrounds and those who promote diversity and a culture of inclusion are encouraged to apply. To request reasonable accommodation contact the Affirmative Action and Equal Opportunity Department at 503-494-5148 or aaeo@ohsu.edu.

As an organization devoted to the health and well-being of people in Oregon and beyond, OHSU requires its employees to be fully vaccinated against COVID-19.


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed