Oregon Health & Science University Foundation

Business Intelligence Analyst / Senior System Application Analyst

Oregon Health & Science University Foundation

full-time

Posted on:

Origin:  • 🇺🇸 United States

Visit company website
✨ AI Apply
Manual Apply

Salary

💰 $99,981 - $138,544 per year

Job Level

Senior

Tech Stack

AzureETLSDLCSQLTypeScript

About the role

  • Solution Development, Testing, and Training: Microsoft Azure: PowerBI. Business Objects: BOBJ Universes, Web Intelligence and Crystal Reports. Epic Clarity and Caboodle data models. Epic: Reporting Workbench reports & templates, Radar dashboards, SlicerDicer analyses, Analytic Registries Column Editor, PAF creation, CER rules.
  • 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 using Chart review, Record Viewer, Clarity Data dictionary, and Caboodle Data Dictionary.
  • 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 staff and customers to improve user experience.
  • Facilitate the implementation and migration of the solution objects into production.
  • 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.
  • Business Analysis: Data analysis and profiling of source data to identify source tables, data definitions and business rules. Solution design.
  • Leverage Epic Userweb, Epic hosted foundation, and TS support to leverage Epic foundation and Epic integrated solutions when possible.
  • Production Support and Continuous Improvement: 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. Continually work to improve existing processes and daily work. Identify improvement opportunities for department or system. Facilitate the prioritization of improvement opportunities with organizational leadership.
  • Project Management, Tool Leadership, and Mentorship: Primary representation for Clinical BI in division level projects; will include impact analysis of Clinical BI stewarded content, the development of a mitigation plan, assignment and/or ownership of project tasks, oversight of project task executions, status reporting to leadership.
  • Leading the creation, maintenance, and improvement of standard work and process documentation. This includes all reference documentation categorized as a responsibility of a BIAA analyst in the BIAA RACI Matrix. This documentation will serve as the knowledgebase for all junior staff.
  • Expert level understanding of BIAA toolset, serving as the go-to technical expert in an ETL or BI application. Mentorship of junior staff for process, clinical subject matter, and department tools.
  • Other duties as assigned.

Requirements

  • Master’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 Bachelor’s degree in computer science, a related field, or a clinical field and six 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 seven years work related experience in the information technology field or a combination of clinical or operational healthcare environments; OR Eight 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.
  • Four years paid work experience as BI Developer (or equivalent classification).
  • Four years working with relational databases.
  • Four years experience with developing semantic layers for data preparation.
  • Experience with facilitating and documenting system requirements sessions.
  • Experience creating technical documentation of reports and data/report models.
  • Experience with utilizing star schema data stores as the basis for report development.
  • Experience planning and managing small projects.
  • Proven communication, analytical, and problem solving skills.
  • Experience with Systems Development Life Cycle (SDLC) processes and procedures.
  • Ability to read and explain a data model.
  • Ability to read, write and maintain SQL Code.
  • 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; willingness to serve as a positive and professional role model.
  • Must have demonstrated record of reliable attendance, punctuality and proven successful performance in past and present.
  • Epic Clarity/Caboodle Certifications within 6 months of hire.
  • Microsoft Power BI Data Analyst. Associate Certification within 6 months of hire.
  • Preferred: Four or more years of current experience with Epic applications and/or the Epic Clarity environment.
  • Preferred: Six or more years of experience with SQL coding and tuning.
  • Preferred Certifications: Epic Clarity Certification. Epic Caboodle Certification. Epic RWB Certification. Epic Radar Certification. Microsoft Power BI Data Analyst Associate Certification.