Business Intelligence Analyst (Systems/Applications Analyst, Sr.)

Oregon Health & Science University is a public academic health center that focuses on caring for patients while leading groundbreaking research and training healthcare professionals. The Business Intelligence Analyst will support the organization in utilizing data and information to further its mission by analyzing enterprise data, ensuring data integrity, and providing ongoing support for BI tools and applications.

Responsibilities:

• Propose, facilitate and document modifications to existing business processes and operational workflows
• Use the knowledge gained by working with business partners and through prior experience to analyze data in enterprise applications including Oracle EBS, Epic and Banner in order to meet reporting requirements
• Conducts customer meetings to obtain system definition and design approvals or develop system or workflow interfaces, and requirements gathering
• Designs, develops and documents new applications and systems or clinical/operational workflows
• Analyzes present and future system needs of customers and makes recommendations on options and alternatives for implementing applications and systems or processes
• Designs, develops and documents modifications to existing applications and systems
• Assumes project coordination responsibilities for small projects or sub-projects within a larger project
• Ensure data integrity and validity of applications and systems
• Ensure that proper quality assurance standards are applied throughout the software development process
• Work with assigned departments to document user-friendly testing of system/interface requirements, make design recommendations to meet quality assurance requirements and project schedule
• Assist and/or develop test cases and scripts and thoroughly test fixes, enhancements, and patches prior to release into user testing
• Document and communicate preliminary testing results
• Develops test plans and conducts testing
• Translate technical specifications and requirements into informative, user-friendly test plans for end-user acceptance testing
• Tests vendor upgrades and new releases
• Provide ongoing support, follow up and maintenance to existing applications and systems or workflows
• Triage and address issues as they arise based on customer incidents and change requests
• Assist in the development and design of system interfaces and data integration to support BI Reporting, Analysis and Application needs
• Provides training/mentor assistance to analysts and/or end users with less experience
• Coordinates the escalation and resolution of software processing problems with vendor support specialists
• A strong advocate and representative for the end-user; which may include providing support for operationalized products and iterating on the information received from end users
• Participate in appropriate activities that enhance general knowledge of or ability to do assigned work

Requirements:

• Master's degree in business or computer science or related field and four years of work-related experience in the information technology field; OR
• Bachelor's degree in business or computer science or related field and six years of work-related experience in the information technology field; OR
• Associate's degree in business or computer science or related field and seven years of work-related experience in the information technology field; OR
• Eight years work related experience in the information technology field; 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
• Minimum three years of business analyst experience
• Experience leading requirements gathering sessions and documenting associated business requirements for large-scale IT projects
• Experience planning and managing large-scale IT projects
• Experience with Cognos, Oracle, Power BI or other BI tool
• Knowledge of data warehousing architecture
• Proven communication, analytical and problem-solving skills
• Excellent presentation/facilitation skills
• Ability to manage multiple projects on an ongoing basis with excellent attention to detail
• Demonstrate skilled problem-solving capabilities to determine solutions and options to resolve problems
• Ability to read, write and maintain basic SQL code
• Two or more years of experience with Power BI products
• Experience with Oracle EBS or other ERP financial modules
• Knowledge of Oracle EBS or other ERP financial data and related databases and processes
• Project Management Professional (PMP) certification from the Project Management Institute
• IBM Cognos Certified Professional