Oregon Health & Science University

Business Intelligence Engineer (Application Engineer, Sr)

Job Locations US-OR-Portland
Requisition ID
2022-20751
Position Category
Information Systems
Position Type
Regular Full-Time
Job Type
AFSCME union represented
Department
Information Technology Group (ITG))
Salary Range
$99,979 - $138,543 (Salary Commensurate with qualifications, experience, and internal equity)
FTE
1.00
Schedule
Monday - Friday
Hours
8:00am -5:00pm
HR Mission
Central Services
Drug Testable
No

Department Overview

The mission of the Information Technology Group (ITG) is to develop, implement and maintain technology-based services and solutions enabling OHSU to effectively manage information to accomplish its missions. 


This position will be part of a dynamic, energetic and collaborative team that supports the organization in the use of data and information to further OHSU’s mission to strive for excellence in education, research and scholarship, clinical practice and community service. Members of the Business Intelligence and Advanced Analytics (BIAA) team work to apply knowledge and best practices to assist end users in leveraging BI Tools (Power BI, Cognos, Tableau, etc.) to analyze enterprise data for informed decision making throughout the organization. 

Function/Duties of Position

This position is responsible for providing BI System Engineering, Power BI Reporting / Analytic Development, and System Analysis/Support in the delivery of the CANDID project.  This will include working with business partners to collect and integrate information across the clinical, research, and educational mission areas and combining that with key administrative information (HR, Payroll, Grants Accounting, etc.).


The BI System Engineering responsibilities of this position include working closely with other ITG and BIAA team members to apply advanced technical experience and knowledge to coordinate the development, maintenance and monitoring of complex and critical BI applications.  Throughout these efforts a high degree of attention will be required to ensure new applications, code and updates are tested and applied accurately, that security and access are maintained as expected, and that all components of the system perform efficiently and with minimal downtimes.


The system engineering responsibilities will be applied to performing Power BI Reporting / Analytic Development tasks by leveraging extensive experience with Microsoft analytic tools (Power BI, Visual Studio, DAX) to develop solutions and project deliverables.  These items will enable members of the organization to efficiently access and analyze integration information for decision making and planning related to critical institutional resources.  Throughout the development efforts team collaboration and joint development and knowledge sharing will be critical to the long term success of these efforts.


The System Analysis/Support components of the role will include applying effective communication and presentation skills to collaborate with business partners to understand business processes and how the BI systems will support those processes.  Ongoing support efforts will work collaboratively with business partners to support the efficient use of the BI systems and to continue to maintain and update these systems to ensure they remain aligned with the evolving organizational needs.


Where necessary this will include responding to support requests as well as 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.

Required Qualifications

Education:



Bachelor’s degree in computer science or related field and eight years of work related experience in the information technology field or a combination of clinical or operational healthcare environments; OR Associate’s degree in computer science or related field and nine years of work related experience in the information technology field or a combination of clinical or operational healthcare environments; OR Ten 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.



Experience:




  • Minimum two years paid work experience as an Application Engineer (or equivalent classification) using an Enterprise BI tool (Power BI, Cognos, Tableau, Business Objects, etc.)

  • Three or more years of experience developing Power BI reports, dashboards and analytic solutions

  • Minimum three years working with relational databases

  • Experience with DAX to create aggregate measures and complex formulas in Power BI

  • Strong knowledge of data modeling concepts and ETL processes

  • Experience creating technical documentation of reports and data/report models

  • Experience with utilizing star schema data stores as the basis for report development 

  • Knowledge of data visualization best practices



Job Related Knowledge, Skills, and Abilities: 




  • Proven communication, analytical, and problem solving skills

  • Ability to read and explain a data model

  • Ability to read, write and maintain SQL Code

  • Experience gathering and documenting business requirements

  • Experience planning and managing small projects

  • Knowledge of data warehousing architecture and dimensional modeling concepts

  • Ability to read, write and maintain SQL code at an advanced skill level

  • Exceptional interpersonal skills - able to resolve conflicts and to problem solve between parties. 

  • Ability to manage competing priorities. 

  • Ability to work independently;

  • Willingness to serve as a positive and professional role model. 

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.

Options

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