The Information Technology Group (ITG) at OHSU needs to develop, implement, and maintain technology-based services and solutions to effectively manage information and support decision-making across financial, clinical, operational, and research areas. This role specifically aims to enhance operational reporting and support executive-level strategic initiatives through advanced data analysis and business intelligence solutions.
Requirements
- Two years of experience developing reports with a BI reporting tool.
- Two years of experience working with relational databases.
- Ability to read, write and maintain SQL Code.
- Ability to test reporting for data quality.
- Knowledge of data warehousing architecture and dimensional modeling concepts.
- Experience with IBM Cognos Analytics.
- Two years of experience with Oracle PL/SQL coding and tuning.
Responsibilities
- Design, develop, and maintain a variety of business intelligence solutions for analyzing, reporting, and providing access to university consumers.
- Gathering requirements and acquiring business process knowledge to translate the data needs of the customer.
- Troubleshoot and analyze data processing failures and data issues.
- Recommend changes to data models and metadata models to improve existing structures and code to increase performance, reliability, and efficiency.
- Data analysis, interpretation, and profiling of source data to identify source tables, data definitions and business rules.
- Respond to requests from Healthcare customers, to fix issues or apply enhancements to existing production reports.
- Design, develop and test the solution.
Other
- Master’s degree in computer science, a related field, or a clinical field and two years work related experience in the information technology field or a combination of clinical or operational healthcare environments; OR Bachelor’s degree in computer science, a related field, or a clinical field and four 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 five years work related experience in the information technology field or a combination of clinical or operational healthcare environments; OR Six 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 Associates degree and two years of experience will be substituted for a Bachelors degree.
- Minimum two years paid work experience as Data Analyst, Data Engineer, or BI Developer (or equivalent classification).
- Experience with facilitating requirements gathering sessions and documenting requirements.
- Experience with authoring educational, user guides or leading group training sessions.
- Proven communication, analytical, and problem-solving skills.
