Business Intel Data Analyst II

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

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.

• 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.

• 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 COG
  220, Revenue COG
  230, or Clinical COG
  240; 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, Slicer Dicer).

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

Salem Health Hospitals and Clinics is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, gender, gender identity, sexual orientation, age, national origin, disability, veteran status, genetic information, or any other status or condition protected by law.

Salem Health Hospitals and Clinics is committed to providing access, equal opportunity, and reasonable accommodation for applicants. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact my.recruiter.