Office of Information Technology Services
Swan St., Core 3, 5th floorAlbany , NY 12223
Division/Unit: Service Delivery Analytics
Web Site: http://www.its.ny.gov
Office of Information Technology Services
Swan St., Core 3, 5th floorDivision/Unit: Service Delivery Analytics
Web Site: http://www.its.ny.gov
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
Payment? Paid
Number of Hours: 20 - 30
Location: Albany
Number of Interns Needed: 3
Preferred Standing Junior
Minimum Standing: Sophomore
Degree Concentrations: Business Administration, Information Technology, Mathematics, Public Administration