Business Intel Data Analyst II

Salem Health Hospitals and Clinics

$70K — $95K *
Salem, OR 97301In-Person
Healthcare
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in IT, computer science, business administration, healthcare, or related field; or equivalent experience (8 years)
  • Epic Data Model Certification (COG220, COG230, or COG240) or must complete within one year
  • Minimum 3 years in IT, healthcare, or a related field
  • Minimum 3 years with MS SQL and data visualization tools (SAP Crystal, Power BI, Epic)
  • Minimum 1 year of experience with Epic Cogito tools (Cogito SQL, Radar SQL, SlicerDicer)

Responsibilities

  • Develop SQL and BI reports for clinical, financial, and operational decision-making
  • Collaborate with stakeholders to understand data needs and create reporting solutions
  • Validate and deploy reports ensuring they meet accuracy and usability standards
  • Troubleshoot complex data issues beyond Tier I support
  • Maintain documentation for transparency and knowledge sharing
  • Participate in meetings to provide updates and gather requirements
  • Support junior team members through knowledge sharing and guidance
  • Deploy and maintain BI software for reliable reporting environments

Benefits

  • Comprehensive benefits package prioritizing mental and physical health
  • Support for financial stability
  • Assistance with family obligations
  • Emphasis on professional growth and development opportunities
Full Job Description
Location: Salem Hospital, 890 Oak Street SE, Salem, Oregon 97301
Department: Information Services
Position Type: Full Time, 40 hours/week, Non-Exempt
Schedule: 8:00 am - 5:00 pm, Monday - Friday

Your role with us

As a business intelligence data analyst II at Salem Health, you'll be part of a team that turns complex data into clarity, helping caregivers and leaders make decisions that directly improve patient care and operational performance. You'll work with modern BI tools, rich clinical and operational datasets, and partners across the organization who rely on your expertise to illuminate trends, solve problems, and drive meaningful change. This role gives you the space to innovate, the support to grow, and the satisfaction of knowing your work strengthens the health of the communities we serve.

What you'll do

  • Develop SQL and BI reporting to support clinical, financial, and operational decision-making using MS SQL, SAP Crystal, Power BI, and Epic Cogito tools.
  • Collaborate with stakeholders across departments to understand data needs and translate them into actionable reporting solutions.
  • Validate and deploy reports that meet accuracy, performance, and usability standards.
  • Troubleshoot complex data issues escalated beyond Tier I support, ensuring timely resolution and minimal disruption.
  • Maintain documentation aligned with standards of work to support transparency, consistency, and knowledge sharing.
  • Participate in team and project meetings to provide updates, gather requirements, and contribute to planning.
  • Support junior team members through guidance, knowledge sharing, and development assistance.
  • Deploy and maintain BI software as needed to ensure stable and reliable reporting environments.

Required qualifications

  • Bachelor's degree in information technology, computer science, business administration, health care, or related field; or eight years of related work experience; or an equivalent combination of education and experience (each year of education equates to two years of experience).
  • Epic Data Model Certification- Access COG220, Revenue COG230, or Clinical COG240; OR must be completed within one year from initial course attendance.
  • Minimum three years of IT, healthcare, or related experience.
  • Minimum three years of hands-on MS SQL programming and data visualization experience (preferred tools: SAP Crystal, Power BI, Epic Clarity, Epic Caboodle).
  • Minimum one year of progressive experience using Epic Cogito tools (preferred: Cogito SQL, Radar SQL, SlicerDicer).


Total rewards package

Salem Health's comprehensive benefits package prioritizes your mental and physical health, financial stability, family obligations, and professional growth. Click here for details.

Similar Jobs

More Jobs at Salem Health Hospitals and Clinics

More Healthcare Jobs

Find similar Business Intel Data Analyst II jobs: