Business Intelligence Analyst (Systems/Applications Analyst)

Oregon Health & Science University is seeking a Business Intelligence Analyst to support its Information Technology Group. The role involves developing business intelligence solutions, conducting data analysis, and providing training to lower-level analysts to enhance decision-making processes within the organization.

Responsibilities:

• Identifies opportunities for leveraging existing reporting assets to meet business requirements
• Works closely with other OHSU IT staff to meet expectations for design reviews and coding standards
• Provides issue resolution during Quality Assurance / User testing
• Troubleshoot and analyze data processing failures and data issues
• Work through established processes to resolve system or data problems and communicate updates and status to affected groups
• Recommend changes to data models and metadata models to improve existing structures and code to increase performance, reliability, and efficiency
• Provides technical expertise departmental analysts and clinical customers to improve user experience
• Request migration of solution object through the SDLC process
• Validating and testing with the customer as frequently as necessary to get sign-off that the solution meets the requirements
• Provide training as necessary to the customer of the new report solution
• Data analysis, interpretation, and profiling of source data to identify source tables, data definitions and business rules
• Documentation. Ability to create clear, concise, and comprehensive documentation, including Business Requirements Documents (BRDs), use case documentation, user stories, process maps, and other project artifacts
• Excellent ability to identify root causes of business problems, think strategically, evaluate options of tools and report structure/format, and propose effective/actionable solutions that best meet customer requirements and aligns with business objectives
• Respond to requests from Healthcare customers, to fix issues or apply enhancements to existing production reports
• Communication with the customer to get clarification on support needs
• Perform high level data analysis and initial sizing of the work to be done
• Facilitate and coordinate the solution with other groups, e.g. workflow, BIAA and other IT groups, as needed
• Design, develop and test the solution
• Work with the customer to validate the solution and close the ticket
• Coordinate the migration of the changed report objects
• Other duties as assigned

Requirements:

• 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)
• Two years of experience developing reports with a BI reporting tool
• Two years of experience working with relational databases
• 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
• Experience translating business requirements into reporting solutions
• Ability to read and explain a data model
• Ability to read, write and maintain SQL Code
• Ability to test reporting for data quality
• Experience planning and managing small projects
• Knowledge of data warehousing architecture and dimensional modeling concepts
• Exceptional customer service skills - both in person and on the phone
• Exceptional interpersonal skills - able to resolve conflicts and to problem solve between parties
• Demonstrated evidence of strong written and verbal communication skills
• Ability to manage competing priorities
• Ability to work independently
• Experience with IBM Cognos Analytics
• Experience developing at an academic medical center or healthcare related organization preferred
• Two years of experience with Oracle PL/SQL coding and tuning
• Conceptual understanding of Data Warehousing and Data Marts
• Preferred Certification: Cognos BI Power BI or Microsoft Fabric