Department of Civil Service

Description:

The intern will require a minimum of (20 hours/week) to a full time schedule (37.5/hours per week) in order to support the data analysis and reporting function of Performance Management.
The intern will be performing the following duties in support of Performance Management and the MeasureIT platform but not limited to:
1. Writing simple to moderate queries in TSQL to perform data analysis for performance management requests.
2. Creating Pivot Tables and Pivot charts to summarize data extracts from a SQL Server Environment.
3. Create monthly Report Analysis on CPO and COO monthly reports.
4. Develop Self-Service Excel Dashboards using PowerPivot data models and Power View dashboards.
5. Create technical documentation, procedures, and develop data dictionaries for MeasureIT.
6. Developing Static and Dynamic Reports using SQL Server Reporting Services and publish to SharePoint library for
consumption.
7. Attend report requirement meetings for CPO Portfolio Management and COO Service Management.
8. Conduct End-User training for Service Area Staff of Self-Service Dashboards created by Student Intern.

Skills:

SQL Query Language

Database Management

Technical Writing

Basic HTML ¿ Preferred by not required

Internship Areas: Information Technology