Department of Civil Service

← Back to Internship Listing

Transact SQL/Bus Intelligence (90006,90039, 90070) (ID: 105875) for Fall 2017

Agency/Facility

Office of Information Technology Services

Swan St., Core 3, 5th floor
Albany , NY 12223

Division/Unit: Service Delivery Analytics

 

Web Site: http://www.its.ny.gov(New Window)

 

Proposal Information

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

Logistical Information

Payment? Paid

Number of Hours: 20 - 30

Location: Albany

Number of Interns Needed: 3

Desired Candidate Profile

Preferred Standing Junior

Minimum Standing: Sophomore

Degree Concentrations: Business Administration, Information Technology, Mathematics, Public Administration