Oregon Health & Science University

Business Intelligence Engineer (Application Engineer Sr)

Job Locations US-OR-Portland
Requisition ID
2021-10185
Position Category
Information Systems
Position Type
Regular Full-Time
Job Type
AFSCME union represented
Department
Information Technology Group (ITG)
Salary Range
$93,438 - $129,480 Annually
FTE
1.00
Schedule
Monday - Friday
Hours
8:00am - 5:00pm
HR Mission
Central Services
Drug Testable
No

Function/Duties of Position

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 in the development of integrated data warehouse and analytic systems to support analytic tools and efforts to analyze enterprise data for informed decision making throughout the organization. 
This position is responsible for providing BI System Engineering, Azure Modern Data Warehouse Development, and System Analysis/Support in the delivery of the CANDID project.  This will include working with ITG staff and business partners to collect and integrate information across the clinical, research, and educational mission areas and combine 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 data sources and integration processes.  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 Azure Modern Data Warehouse Development tasks by leveraging extensive experience with Microsoft Azure Services and functionality (Azure Data Factory, Azure Data Lake Storage, Azure Databricks, Azure Synapse Analytics, and Azure Analysis Services, etc.) to develop solutions and project deliverables.  These items will enable members of the organization to efficiently access and analyze integrated 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 IT and business partners to understand data structures, and BI reporting and analytic needs.  Ongoing support efforts will include working collaboratively with technical and functional team members to maintain and update the BI 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.
 

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

Education:
Bachelor’s degree in computer science, a related field, or a clinical field and eight 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 nine years 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 integration tools (Data Factory, SSIS, IBM Infosphere, etc.)
  • Three or more years of experience developing processes to maintain data in a dimensional data warehouse using Microsoft tools
  • More than two years of experience working with an Azure Modern Data Warehouse using Azure Data Factory, Azure Data Lake Storage, Azure Data Bricks, Azure Synapse Analytics, or Azure Analysis Services, etc.  Including experience developing using T-SQL, Python, Scala, Spark SQL or .Net
Job Related Knowledge, Skills, and Abilities:
  • Proven communication, analytical, and problem solving skills
  • Ability to read and explain a data model
  • Experience gathering and documenting business requirements
  • Experience planning and managing small projects
  • Demonstrate Core Competencies as established for your position (Leading Self, Leading Others, Leading Leaders, Leading Function)
  • 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. 

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.

Options

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