Oregon Health & Science University Foundation

Business Intelligence Analyst – Systems/Applications Analyst

Oregon Health & Science University Foundation

full-time

Posted on:

Origin:  • 🇺🇸 United States

Visit company website
✨ AI Apply
Manual Apply

Salary

💰 $90,686 - $125,663 per year

Job Level

JuniorMid-Level

Tech Stack

CognosOracleSDLCSQL

About the role

  • Under mentorship of senior team members, gather requirements and acquire 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.
  • Solution Development, Testing, and Training including Cognos Analytics and Power BI.
  • 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 departmental analysts and clinical customers to improve user experience.
  • Request migration of solution object through the SDLC process and validate and test with the customer to get sign-off.
  • Provide training as necessary to the customer of the new report solution.
  • Business Analysis: Data analysis, interpretation, and profiling of source data to identify source tables, data definitions and business rules.
  • Create clear, concise, and comprehensive documentation, including Business Requirements Documents (BRDs), use case documentation, user stories, process maps, and other project artifacts.
  • Production Support: Respond to requests from Healthcare customers, fix issues or apply enhancements to existing production reports, perform high level data analysis, coordinate solution with other groups, and coordinate migration of 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 preferred.
  • Experience developing at an academic medical center or healthcare related organization preferred.
  • Two years of experience with Oracle PL/SQL coding and tuning preferred.
  • Conceptual understanding of Data Warehousing and Data Marts preferred.
  • Preferred Certification: Cognos BI Power BI or Microsoft Fabric.