Business Intel Data Analyst II

Salem Health Hospitals & Clinics; Salem (OR); On-site; USD 85,000 - 110,000; Full time

Job summary

Salem Health Hospitals and Clinics is seeking a Business Intelligence Data Analyst II to join Information Services in Salem, Oregon. You will transform complex datasets into actionable insights, building reports and dashboards with MS SQL, SAP Crystal, Power BI, and Epic Cogito.

You will collaborate with care teams and leaders to turn data into decisions that improve patient care and operational performance, while maintaining robust documentation and contributing to a collaborative,

Qualifications

• Bachelor’s degree in IT, CS, business, health care, or related field; or equivalent combination of education and experience.
• Epic Data Model Certification - Access COG220/COG230/COG240; or completed within 1 year.
• Minimum three years of IT, healthcare, or related experience.
• Minimum three years MS SQL programming and data visualization experience (Power BI, Epic Clarity, Epic Caboodle).
• Minimum one year of progressive experience using Epic Cogito tools (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

MS SQL programming

Data visualization

SQL

Education

Bachelor’s degree in IT/CS/health care/business

Tools

Power BI

SAP Crystal

Epic Clarity

Epic Caboodle

Epic Cogito

Cogito SQL

Radar SQL

SlicerDicer

Job description

US:OR:Salem | Information Services | Full Time

Posted 0 weeks ago

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.
• T roubleshoot 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; oreight years of related work experience; or anequivalent 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).

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

Why Salem Health?

Salem Health is a Top Workplace in Oregon, known for fostering a supportive culture where your contributions truly matter. As an award-winning, independent health care system, we serve our region through Salem Hospital, multiple community clinics and West Valley Hospital, ensuring broad access to high-quality care.

We believe in empowering our teams. Through Lean principles, staff help drive innovation and solve real problems. We also invest in your growth with professional development, tuition assistance, and clear career pathways. At Salem Health, you\’ll find more than a job, you\’ll find purpose, connection, and room to thrive.

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