St. Charles Health System

Compensation

Full Description

Pay range: $83,096 - $124,675 annually. This exempt position comes with a comprehensive benefits package that includes medical, dental, vision, a 403(b) retirement plan, and a generous Earned Time Off (ETO) program. ST. CHARLES HEALTH SYSTEM JOB DESCRIPTION TITLE: Business Intelligence Developer II REPORTS TO POSITION: Business Intelligence Manager or Epic Connect Workstream Manager DEPARTMENT: Information Technology (IT) DATE LAST REVIEWED: October 2022 OUR VISION: Creating America’s healthiest community, together OUR MISSION: In the spirit of love and compassion, better health, better care, better value OUR VALUES: Accountability, Caring and Teamwork DEPARTMENT SUMMARY: The IT Decision Support department provides reporting, data mining, data analysis and metric definition assistance for all departments at St. Charles Health System (SCHS). These services include operational reports, dashboards including trending data and KPIs, analytical reports, and predictive modeling among others. The Epic Connect program evaluates, establishes, and maintains partnerships with physician practices and hospital organizations by sharing the use of SCHS’ Epic integrated EHR for the purpose of establishing a regional shared patient record. The Epic Connect Program provides better care for the collective patients we serve, strengthens our collective ability to serve the community and the region and manages costs by sharing resources and creating common practice standards across SCHS’ Epic Connect community. POSITION OVERVIEW: The Business Intelligence Developer II at St. Charles Health System performs analysis, designs, develops, deploys, supports, and maintains reporting and analytical or business intelligence applications for the various business units and clinical stakeholders serviced by the Enterprise Data Warehouse (EDW). This position requires strong technical skills in SQL, Power BI (including DAX and Power Query), ETL/ELT development, and data modeling, as well as the ability to translate data into measurable KPIs and metrics. Success in this role also depends on effective communication, critical thinking, adaptability, and the ability to collaborate with both technical and non-technical teams. The BI Developer II provides consultation and support in the development, analysis, design, and management of a variety of complex data sources to meet organizational reporting and analytics needs across multiple domains. This position does not directly manage any other caregivers. ESSENTIAL FUNCTIONS AND DUTIES: Assesses the analytic needs of St. Charles through discovery, analysis, and evaluation to create necessary artifacts, demonstrating critical thinking and customer service orientation to ensure relevance and usability. Receives and documents requests from end-users, including specifications, and ensures analytic requests are completed as appropriate, collaborating effectively with stakeholders across clinical, financial, and operational domains. Maintains existing analytics assets and evaluates requirements for enhancements to data models or visualizations. Analyzes, designs, documents, develops, tests, implements, and maintains reporting user interfaces including alerts, prompts, screens, dashboards, and templates, leveraging tools such as Power BI, DAX, and ETL frameworks to deliver interactive, scalable solutions. Collaborate on developing guidelines, standards, methodologies, and conventions for analytical needs of the organization. Provides documentation and training to transfer knowledge and operational support, demonstrating strong communication and data storytelling skills. Participates in Data Governance. Prepares detailed specifications, technical and user documentation from which reports, downloads and extracts will be written. Ensures complete and accurate logical definition of data. Responsible for maintaining data integrity and the ongoing quality control of delivered analytics. Validates system builds and analytics solution designs, and audits security configurations and data control processes to ensure compliance and integrity. Assists with quality assurance (testing) and documentation of testing results thorough standard procedures and processes. Safeguards protected health information from any intentional or unintentional disclosure in compliance with applicable rules and regulations. Maintains professional growth and development through seminars, workshops, and professional affiliations. Participates in on-call after hours support. Supports the vision, mission, and values of the organization in all respects. Supports Lean principles of continuous improvement with energy and enthusiasm, functioning as a champion of change. Provides and maintains a safe environment for caregivers, patients, and guests. Conducts all activities with the highest standards of professionalism and confidentiality. Complies with all applicable laws, regulations, policies, and procedures, supporting the organization’s corporate integrity efforts by acting in an ethical and appropriate manner, reporting known or suspected violation of applicable rules, and cooperating fully with all organizational investigations and proceedings. Delivers customer service and/or patient care in a manner that promotes goodwill, is timely, efficient, and accurate. May perform additional duties of similar complexity within the organization, as required or assigned. EDUCATION: Required: Bachelor’s degree in Information Technology. Four (4) years of relevant work experience may be substituted in lieu of a degree. Preferred: N/A LICENSURE/CERTIFICATION/REGISTRATION: Required: Must complete Epic certification training; if not already Epic certified in the most recent version of the Epic EHR product. Must pass an assessment exam prior to qualifying for an interview, unless already Epic certified. Must pass Epic certification exam within 3 months of completing Epic certification training courses. Valid Oregon driver’s license and ability to meet SCHS driving requirements. Ability to travel to business functions/trainings/meetings and all SCHS worksites. Preferred: N/A EXPERIENCE: Required: Two (2) years of experience in programming, data modeling, analytics, or report writing in addition to the educational requirements. Four (4) years of relevant work experience in programming, and analytics may be substituted in lieu of educational requirements. Experience with SQL, Power BI (including DAX and Power Query), ETL/ELT processes. Preferred: Experience with BI concepts and tools such as Microsoft Analysis Services. Experience with the healthcare industry, preferably with exposure to Epic EMR Cogito within the revenue and financial domains. Experience with Data Lakes and Data Governance (Python, Notebooks, Databricks). PERSONAL PROTECTIVE EQUIPMENT: Must be able to wear appropriate Personal Protective Equipment (PPE) required to perform the job safely. PHYSICAL REQUIREMENTS: Continually (75% or more): Sitting, keyboard operation, use of clear and audible speaking voice and the ability to hear normal speech level. Frequently (50%): Standing, lifting 1-10 pounds, grasping/squeezing. Occasionally (25%): Bending, reaching overhead, carrying/pushing, or pulling 1-10 pounds. Rarely (10%): Walking, stooping/kneeling/crouching, climbing stairs. Never (0%): Climbing ladder/stepstool, lifting/carrying/pushing, or pulling 11-50 pounds, operation of a motor vehicle, ability to hear whispered speech level. Exposure to Elemental Factors Never (0%): Heat, cold, wet/slippery area, noise, dust, vibration, chemical solution, uneven surface. Blood-Borne Pathogen (BBP) Exposure Category No Risk for Exposure to BBP . Schedule Weekly Hours: 40 Caregiver Type: Regular Shift: Is Exempt Position? Yes Job Family: ANALYST INFORMATION TECHNOLOGY Scheduled Days of the Week: Monday-Friday Shift Start & End Time: Flexible within core working hours St. Charles Health System is a private, nonprofit organization, dedicated to providing high-quality care and the latest in health care technology to the communities it serves. Headquartered in Bend, Ore., St. Charles is an integrated delivery system, with a strong focus on population health, that provides a full range of evidence-based health care services within a 32,000-square-mile area in Central and Eastern Oregon. The health system owns and operates a trauma level II, tertiary referral center in Bend, a trauma level III, type B rural hospital in Redmond, and trauma level IV critical access hospitals in both Prineville and Madras. As the largest employer in Central Oregon, St. Charles Health System and St. Charles Medical Group care for our communities in more than two dozen outpatient clinics and in more than 20 specialty areas of medicine. For additional information, such as Career FAQ's, benefits, and why your dream job awaits, please visit our Careers site. With a variety of nursing positions available, you can choose a career path that fits both your interests AND your lifestyle. Please click on the link for additional help on navigating the candidate site and features of the candidate home page. Candidate Home User Guide