St. Charles Health System
Business Intelligence Developer 2
St. Charles Health System, Myrtle Point, Oregon, United States, 97458
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
Assess analytic needs of St. Charles through discovery, analysis, and evaluation to create necessary artifacts, demonstrating critical thinking and customer service orientation.
Receive and document requests from end‑users, including specifications, and ensure analytic requests are completed as appropriate, collaborating with stakeholders across clinical, financial, and operational domains.
Maintain existing analytics assets and evaluate requirements for enhancements to data models or visualizations.
Analyze, design, document, develop, test, implement, and maintain 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.
Provide documentation and training to transfer knowledge and operational support, demonstrating strong communication and data storytelling skills.
Participate in Data Governance.
Prepare detailed specifications and technical/user documentation from which reports, downloads, and extracts will be written.
Ensure complete and accurate logical definition of data.
Maintain data integrity and ongoing quality control of delivered analytics.
Validate system builds and analytics solution designs, audit security configurations and data control processes to ensure compliance and integrity.
Assist with quality assurance (testing) and documentation of testing results following standard procedures and processes.
Safeguard protected health information from any intentional or unintentional disclosure in compliance with applicable rules and regulations.
Maintain professional growth and development through seminars, workshops, and professional affiliations.
Participate in on‑call after‑hours support.
Support the vision, mission, and values of the organization in all respects.
Support Lean principles of continuous improvement with enthusiasm, functioning as a champion of change.
Provide and maintain a safe environment for caregivers, patients, and guests.
Conduct all activities with the highest standards of professionalism and confidentiality, complying with all applicable laws, regulations, policies, and procedures, and supporting the organization’s corporate integrity efforts by acting ethically.
Deliver customer service and/or patient care in a manner that promotes goodwill, efficiency, and accuracy.
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.
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.
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).
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 FACTORS Never: Heat, cold, wet/slippery area, noise, dust, vibration, chemical solution, uneven surface.
Blood‑Borne Pathogen Exposure Category No Risk for Exposure to BBP
SCHEDULE & SHIFT Schedule: Weekly Hours – 40, Monday ‑ Friday, Flexible within core working hours. Shift: Regular. Exempt Position: Yes.
Job Family: ANALYST INFORMATION TECHNOLOGY
#J-18808-Ljbffr
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
Assess analytic needs of St. Charles through discovery, analysis, and evaluation to create necessary artifacts, demonstrating critical thinking and customer service orientation.
Receive and document requests from end‑users, including specifications, and ensure analytic requests are completed as appropriate, collaborating with stakeholders across clinical, financial, and operational domains.
Maintain existing analytics assets and evaluate requirements for enhancements to data models or visualizations.
Analyze, design, document, develop, test, implement, and maintain 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.
Provide documentation and training to transfer knowledge and operational support, demonstrating strong communication and data storytelling skills.
Participate in Data Governance.
Prepare detailed specifications and technical/user documentation from which reports, downloads, and extracts will be written.
Ensure complete and accurate logical definition of data.
Maintain data integrity and ongoing quality control of delivered analytics.
Validate system builds and analytics solution designs, audit security configurations and data control processes to ensure compliance and integrity.
Assist with quality assurance (testing) and documentation of testing results following standard procedures and processes.
Safeguard protected health information from any intentional or unintentional disclosure in compliance with applicable rules and regulations.
Maintain professional growth and development through seminars, workshops, and professional affiliations.
Participate in on‑call after‑hours support.
Support the vision, mission, and values of the organization in all respects.
Support Lean principles of continuous improvement with enthusiasm, functioning as a champion of change.
Provide and maintain a safe environment for caregivers, patients, and guests.
Conduct all activities with the highest standards of professionalism and confidentiality, complying with all applicable laws, regulations, policies, and procedures, and supporting the organization’s corporate integrity efforts by acting ethically.
Deliver customer service and/or patient care in a manner that promotes goodwill, efficiency, and accuracy.
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.
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.
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).
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 FACTORS Never: Heat, cold, wet/slippery area, noise, dust, vibration, chemical solution, uneven surface.
Blood‑Borne Pathogen Exposure Category No Risk for Exposure to BBP
SCHEDULE & SHIFT Schedule: Weekly Hours – 40, Monday ‑ Friday, Flexible within core working hours. Shift: Regular. Exempt Position: Yes.
Job Family: ANALYST INFORMATION TECHNOLOGY
#J-18808-Ljbffr