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 Service Delivery Analytics.
The intern will be performing the following but are not limited to:
1. Writing queries in Transact SQL to perform data analysis for performance management requests.
Candidates should be familiar with the following functions in SQL:
a. Grouping data with totals
b. Case statements
c. SQL joins including (Inner, Left, Right, Full, and Cross)
d. Subqueries
2. Developing Static and Dynamic Reports using SQL Server Reporting Services and publish to SharePoint library for consumption.
3. Creating Pivot Tables and Pivot charts in Excel to summarize data extracts from a SQL Server Environment.
4. Reviewing automated reports and identifying changes and inconsistencies in the data
5. Create monthly Report Analysis on CPO and COO monthly reports.
6. Develop Self-Service Excel Dashboards using PowerPivot data models and Power View dashboards.
7. Create technical documentation, procedures, and develop data dictionaries for MeasureIT.
8. Candidates will also be exposed to the Sql Server Data Tools platform including
a. SQL Server Integration Services (SSIS)
b. SQL Server Reporting Services (SSRS)
c. SQL Server Analysis Services (SSAS)
d. Data warehousing techniques
e. Multidimensional cube development
f. MDX query language

Skills:

SQL Query Language

Database Management

Report Development using SQL and SSRS

Basic HTML ¿ Preferred by not required

Technical Writing

Internship Areas: Information Technology