Office of Information Technology Services
Swan Street, Core 4Albany , NY 12223
Division/Unit: Chief Portfolio Office/Perform Mgmt
Web Site: http://www.its.ny.gov
Office of Information Technology Services
Swan Street, Core 4Division/Unit: Chief Portfolio Office/Perform Mgmt
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 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 but not required
Internship Areas: Information Technology
Payment? Paid
Number of Hours: 20 - 30
Location: Albany
Number of Interns Needed: 1
Preferred Standing Sophomore
Minimum Standing: Sophomore
Degree Concentrations: Business Administration, Information Technology