Business Intelligence Analyst (Systems/Applications Analyst)

OHSU School of Dentistry is an academic institution focused on advancing healthcare through technology. The Business Intelligence Analyst role involves developing business intelligence solutions, conducting data analysis, and providing training to users, all aimed at enhancing decision-making processes within the university.

Responsibilities:

• Gathering requirements and acquiring business process knowledge to translate the data needs of the customer
• Design, develop, and maintain a variety of business intelligence solutions for analyzing, reporting, and providing access to university consumers
• Provide training/mentor assistance to lower-level analysts
• Identify opportunities for leveraging existing reporting assets to meet business requirements
• Work closely with other OHSU IT staff to meet expectations for design reviews and coding standards
• Provide 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
• Provide technical expertise to 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

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