Business Intelligence Developer 2

St. Charles Health System • OR

67d • $83,096 - $124,675

About The Position

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.

Requirements

• Bachelor’s degree in Information Technology or four (4) years of relevant work experience may be substituted in lieu of a degree.
• Two (2) years of experience in programming, data modeling, analytics, or report writing.
• Experience with SQL, Power BI (including DAX and Power Query), ETL/ELT processes.

Nice To Haves

• 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).

Responsibilities

• Assesses the analytic needs of St. Charles through discovery, analysis, and evaluation to create necessary artifacts.
• Receives and documents requests from end-users, including specifications, and ensures analytic requests are completed as appropriate.
• 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.
• Collaborate on developing guidelines, standards, methodologies, and conventions for analytical needs of the organization.
• Provides documentation and training to transfer knowledge and operational support.
• 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.
• Assists with quality assurance (testing) and documentation of testing results.
• Safeguards protected health information from any intentional or unintentional disclosure.
• Maintains professional growth and development through seminars, workshops, and professional affiliations.
• Participates in on-call after hours support.
• Supports Lean principles of continuous improvement.
• Provides and maintains a safe environment for caregivers, patients, and guests.
• Conducts all activities with the highest standards of professionalism and confidentiality.
• Delivers customer service and/or patient care in a manner that promotes goodwill, is timely, efficient, and accurate.

Benefits

• Medical insurance
• Dental insurance
• Vision insurance
• 403(b) retirement plan
• Generous Earned Time Off (ETO) program

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Bachelor's degree