BUSINESS INTELLIGENCE DEVELOPER

Riverside Healthcare in Kankakee, Illinois, is seeking a talented and detail-oriented Business Intelligence (BI) Developer to join our growing team. The BI Developer will be responsible for designing, developing, and maintaining data solutions that support strategic decision-making and enhance operational efficiency across the organization. This role involves collaborating with various departments to understand their data needs, creating intuitive reports from a number of information systems, and ensuring the accuracy and accessibility of critical business information, and serving as a consultant to committees requiring expertise with decision support solutions.

Essential Duties

• Data Analysis and Requirements Gathering: Collaborate with stakeholders to understand their data needs and business requirements. Translate these requirements into technical specifications for BI solutions.
• Report Development: Manage report request queue for assigned reporting domains and design and develop timely and high-quality reports. Ensure these deliverables meet user requirements and provide actionable insights.
• Tool/Environment Utilization: Maintain expertise with the following BI tools and development environments: SQL Server Management Studio, Visual Studio or Report Builder, SQL Server Reporting Services, Microsoft Excel, Manage Engine, Git and Gitlab. 
• Data Integration and Management: Integrate data from various sources, including databases, spreadsheets, and external systems. Work with vendors to develop custom data extracts and manage automated data exchange.
• Performance Monitoring: Monitor the performance of BI solutions and the report library and make necessary adjustments to optimize speed and efficiency. Address any issues related to data integrity or system performance.
• Quality Assurance: Actively participate in team code review process and quality assurance projects to ensure good data quality.
• Documentation and Training: Create comprehensive documentation for BI solutions, including user guides and technical specifications. 
• Collaboration and Support: Work closely with IT and business teams to troubleshoot issues, implement enhancements, and ensure alignment of BI solutions with organizational goals. 
• Flexibility: Demonstrate flexibility with assignments within professional scope/duties/licensure. As a salaried professional, you may be expected to work above your FTE on occasion.

Non-essential Duties

• Special Projects: Assist with special projects related to data analytics and business intelligence as needed.
• Research and Development: Stay current with industry trends and advancements in BI technologies. Propose innovative solutions to enhance data reporting and analysis capabilities. Assist in the strategic planning of department initiatives.
• Cross-Functional Support: Occasionally support other departments with data-related needs or ad-hoc reporting requests.
• Training: Provide training and support to end-users to ensure effective utilization of BI tools.

Required Experience

• Programming experience (prefer Python, C#, R)
• Understanding of relational databases fundamentals
• SQL proficiency
• Strong oral and written communication skills

Preferred Experience

• 2-3 years of experience with data or financial analysis, healthcare setting preferred
• Web Development Framework knowledge a plus
• Power BI/SSRS/SSAS/SSIS experience preferred

Required Licensure/Education

• Epic Clarity Data Model certifications expected within 6 months of hire

Preferred Education

• Bachelors degree in Health, Information Technology, or quantitative field (or equivalent experience) preferred

Employee Health Requirements

Exposure/Sensory Requirements:

• Exposure to:
• Chemicals: None
• Video Display Terminals: Extreme
• Blood and Body Fluids: None
• TB or Airborne Pathogens: The only risk is that associated with contact with the general public.

Sensory requirements (speech, vision, smell, hearing, touch):

• Speech: Needed for presentations/training, telephone communications, facilitate meetings.
• Vision: Needed to read memos and literature, computer entry.
• Smell: Helpful to note presence of electrical/fire hazard.
• Hearing: Needed for telephone communications, meetings, and listening to employee concerns.
• Touch: Needed to write, computer entry, filing.

Activity/Lifting Requirements:

Percentage of time during the normal workday the employee is required to:

• Sit: 89%
• Twist: 0%
• Stand: 5%
• Crawl: 0%
• Walk: 5%
• Kneel: 0%
• Lift: 1%
• Drive: 0%
• Squat: 0%
• Climb: 0%
• Bend: 0%
• Reach above shoulders: 0%

The weight required to be lifted each normal workday according to the continuum described below:

• Up to 10 lbs: Occasionally
• Up to 20 lbs: Occasionally
• Up to 35 lbs: Not Required
• Up to 50 lbs: Not Required
• Up to 75 lbs: Not Required
• Up to 100 lbs: Not Required
• Over 100 lbs: Not Required

Describe and explain the lifting and carrying requirements. (Example: the distance material is carried; how high material is lifted, etc.): Brief case, notebook, computer, printed material--transported from one location/meeting to another.

Maximum consecutive time (minutes) during the normal workday for each activity:

• Sit: 180
• Twist: 0
• Stand: 15
• Crawl: 0
• Walk: 10
• Kneel: 0
• Lift: 2
• Drive: 0
• Squat: 0
• Climb: 0
• Bend: 0
• Reach above shoulders: 0

Repetitive use of hands (Frequency indicated):

• Simple grasp up to 10 lbs. Normal weight: 5-10# frequent
• Pushing &pulling Normal weight:<50#>
• Fine Manipulation: Excessive computer entry, phone dialing, writing, using calculator.

Repetitive use of foot or feet in operating machine control: None

Environmental Factors & Special Hazards:

• Environmental Factors (Time Spent):
• Inside hours: 8
• Outside hours : 0
• Temperature: Normal Range
• Lighting: Average
• Noise levels: Average
• Humidity: Normal Range
• Atmosphere:
• Special Hazards:
• Protective Clothing Required: None