Intern - Data & Outcomes (Spring) at State of… · Sioux…

Summary: The State of South Dakota Department of Social Services provides public behavioral health and social services across the state. The Data and Outcomes Intern will support the Division of Behavioral Health by collecting, transforming, analyzing, and reporting data, maintaining dashboards, troubleshooting data systems, and contributing to process improvement and agency analysis projects.

Responsibilities:
- Assist with data collection, transformation, and reporting using tools such as Microsoft Excel, Power BI, and the State Treatment Activity Reporting System (STARS)
- Maintain and update Power BI dashboards and visualizations to ensure accurate and timely reporting
- Support data entry, cleanup, and integration across STARS, Excel, and online forms
- Write or modify code and queries—ranging from basic scripts to complex logic—to automate data processes, primarily using DAX, M, Excel, and SQL
- Troubleshoot and resolve data-related issues and system errors
- Add and configure new data sources into existing systems and dashboards
- Document data workflows and identify opportunities for process improvement
- Apply strong critical thinking skills and work independently to troubleshoot issues and improve processes
- Collaborate with staff on at least one analysis project aligned with agency priorities and their own interests
- Have experience with Microsoft Access, SQL, Power Query, or scripting tools, which is considered a strong plus
- Demonstrate strong analytical and problem-solving skills, including the ability to think critically and work independently to identify and resolve data or system issues
- Have attention to detail and the ability to document technical processes clearly
- Be willing to learn new technologies and adapt to evolving project needs

Required Qualifications:
- *APPLICANT MUST BE A CURRENT PART-TIME OR FULL-TIME STUDENT (MINIMUM OF 6 CREDIT HOURS) IN UPCOMING SEMESTER OR IN THE IMMEDIATELY PRECEDING SEMESTER
- * have proficiency in Microsoft Excel and Power BI, which are required for this role
- * be able to write and troubleshoot basic to intermediate code or queries for data automation and integration
- * be familiar with data validation, transformation, and governance principles
- * have the ability to communicate technical concepts clearly and collaborate effectively with staff
- * have an interest in public service systems, behavioral health, or data analytics
- Applicant must be enrolled as a part-time/full-time student at a college, university, or technical institute at the time they apply
- By the start of the internship, the student should have completed one year (nine months) of their chosen program

Preferred Qualifications:
- * have experience with Microsoft Access, SQL, Power Query, or scripting tools, which is considered a strong plus
- * have coursework or experience in research methods, statistics, public health, social services, or information systems is preferred
- All students are encouraged to apply, but preference may be given to applicants with a standing of junior/senior, South Dakota residents, and students of South Dakota institutions

Required Skills: Microsoft Excel, Power BI, SQL, DAX, Power Query, Data Validation, Data Transformation, Data Governance, Data Integration, Data Automation