Business Intel Data Analyst II

Salem Health; Salem (OR); On-site; USD 80,000 - 110,000; Full time

Job summary

Salem Health in Salem, Oregon, is seeking a Business Intelligence Data Analyst II to turn complex data into clarity for caregivers and leaders.

You’ll work with MS SQL, SAP Crystal, Power BI, and Epic Cogito, partnering across departments to deliver accurate, actionable reports and help improve patient care and operations.

Join a collaborative team that supports growth, training, and innovative analytics to empower clinical and administrative decision-making.

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

Responsibilities

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

Skills

Data visualization

Stakeholder engagement

Analytical thinking

Mentorship

Education

Bachelor’s degree in IT/CS/Healthcare

Eight years of related experience (education-equivalent)

Tools

MS SQL

SAP Crystal

Power BI

Epic Clarity

Epic Caboodle

Epic Cogito

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.

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 [e-mail].