Business Intelligence Developer 2

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.

.

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