Dayton Children's Hospital Dayton, OH Remote
2021-12-21

Business Intelligence Intern

4.1

Facility:

Work From Home - Dayton OH

Department:

IT

Schedule:

Full time

Hours:

32

Job Details:

This cooperative (co-op) education position will allow students pursuing a degree in science, technology, medicine, nursing or other applicable discipline to gain valuable experience in healthcare based research. Under supervision, the student will be complete a project as defined by the scope of work established between the student, his/her advisor and a DCH-based mentor. A copy of the scope of work will be included with this job description for each student. All students must be currently enrolled in a degree-seeking program at an accredited college, university, or technical school. All students participating in cooperative education at DCH will be expected to adhere to all DCH values, standards, and policies.

Department Specific Job Details:

Utilize Microsoft Power Platform best practices to:

  • Create and maintain PowerApps to interact with Microsoft Lists for data entry and to track processes
  • Extract data daily to Azure from a SQL Server using Power BI Dataflows
  • Create Power BI datasets in Azure to be leveraged by Business Analysts
  • Create Power BI reports based on customer requirements
  • Work with customers to define, create, and document Power BI measures
  • Troubleshoot Dataflow/Dataset issues when refreshes fail

Write SQL queries to get data out of on-prem SQL Server databases

Maintain data integrity and follow data governance policies

Education Requirements:

Bachelors: Information Technology

Certification/License Requirements: