Business Intel Data Analyst II
Salem, OR, US
Information Services
Full Time
Job ID: #17049
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.
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 my.recruiter@salemhealth.org.
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.
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 my.recruiter@salemhealth.org.
Share this job:
Career exploration program
Whatever your background or career aspirations, there’s a place for you at Salem Health. And our Career Exploration Program can help you identify the ideal opportunity to pursue. The Program allows you to work alongside a healthcare professional as you gain insight into a fulfilling hospital career.
Nursing
Since 2010, Salem Hospital has continuously achieved Magnet™-designation – the gold standard for nursing excellence. Only eight percent of all hospitals achieve this prestigious distinction.
We’ve been able to do this by maintaining a nursing culture that is defined by:
- Consistent teamwork and collaboration
- Exemplary resources to support clinical nurses
- Engaged and inspiring leadership
- A focus on well-being, resilience, diversity, equity, and inclusion
- Strong professional development opportunities
- Pride in delivering quality-of-care that exceeds national norms
- An empowering professional governance structure and professional practice model
- New grad residency support, preceptorship, and mentoring
- Open and transparent strategy alignment
- Feedback is encouraged, valued and incorporated from the staff at all levels.
- Partnerships with community organizations that support improved patient outcomes
If you’re looking for a setting where you can achieve your highest potential as a nurse, we invite you to join us. We welcome all nurses, including those from outside of the United States. At Salem Health, you can experience an inclusive culture that values and rewards your unique qualities and background.
RN residency program
Begin your journey from student nurse to confident practitioner with our RN Residency Program. The program features a combination of didactic lessons, simulation, and track-specific class options. It begins with orientation and training and proceeds to preceptorship and mentorship. Through the program, you will gain clinical expertise as well as valuable professional skills such as communication and critical thinking.
Certified nursing assistants
As a certified nursing assistant (CNA), your contributions are absolutely crucial. You will provide compassionate reassurance and vital patient support in order to ensure our patients receive the highest quality care possible. You will receive competitive compensation as you provide patients with physical care and emotional support. We seek empathetic, and non-judgmental individuals with a sincere passion for elevating others’ lives.
Postgraduate year 1 pharmacy residency program
The Salem Health Postgraduate Year 1 (PGY1) Residency Program enhances your PharmD education as you develop your clinical expertise in the medication-related care of patients with a wide range of conditions. The program will be eligible for board certification, and eligible for postgraduate year 2 (PGY2) pharmacy residency training. Upon completion of the Salem Health PGY1 residency, we believe you will be a confident and highly capable general practitioner, and well-prepared for the next step in your career.
We will meet you wherever you are on your career journey, and walk with you to your destination
There are over 900 unique positions to choose from at Salem Health. Whatever your background or your professional and personal aspirations, we offer an inclusive learning environment where you can achieve your highest potential in a career that grows with you. And, we’ll help you along the way with perks like tuition reimbursement and certification bonuses.
With so many options, why work anywhere else?
