Review Vacancy

Date Posted: 08/09/18
Applications Due: 08/20/18
Vacancy ID: 57920

Position Information

AgencyInformation Technology Services, Office of

TitleStudent Assistant-Service Delivery Analytics Intern, Ref. #90006M

Occupational CategoryOther Professional Careers

Salary GradeHourly

Bargaining UnitPS&T - Professional, Scientific, and Technical (PEF)

Salary RangeFrom $19.69 to $22.08 Hourly

Employment Type Full-Time

Appointment Type Temporary

Jurisdictional Class Non-competitive Class

Travel Percentage 0%

Schedule

Workweek Mon-Fri

Hours Per Week 30

Workday

From 8 AM

To 5 PM

Flextime allowed? No

Mandatory overtime? No

Compressed workweek allowed? No

Telecommuting allowed? No

Location

County Albany

Street Address 50 Wolf Road

City Albany

StateNY

Zip Code12205

Job Specifics

Minimum Qualifications • Must be a US citizen or foreign national eligible to work in the United States
• Must be 18 years of age or older
• Must be currently attending a New York State college, university or graduate program, or be a resident of New York State attending a college, university or graduate program outside of New York State
• Must have completed a minimum of one (1) year as a student at a degree-granting two or four-year college or university (completion of one year’s worth of academic credits over a more extended period of time may qualify part-time students)
• Or currently enrolled graduate student or accepted in a graduate degree program
• Must have a minimum grade point average (GPA) of 2.5 or equivalent to a C.

Preferred qualifications:
• Junior or Sophomore level college Student
• Major in Information Technology

Preferred Skills:
Information Technology-Network and Programming knowledge and familiarity with Microsoft Office Suite.

Duties 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 duties in support of Service Delivery Analytics and the MeasureIT platform but not limited to:
1. Writing simple to moderate queries in Transact SQL to perform data analysis for performance management requests.
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 to summarize data extracts from a SQL Server Environment.
4. Creating monthly Report Analysis on Chief Portfolio Office and Chief Operations Office monthly reports.
5. Developing Self-Service Excel Dashboards using PowerPivot data models and Power View dashboards.
6. Creating technical documentation, procedures, and develop data dictionaries for MeasureIT.

Additional Comments Fingerprinting will be required of hired candidates. Selected candidates who are new or returning to NYS service may be required to pay for fingerprinting fees.

Some positions may require additional credentials or a background check to verify your identity.

Contact Information

Name Schuyler Younkin

Telephone 518-473-0398

Fax 518 402-4924

Email Address HR.Recruitment@its.ny.gov

Address

Street ESP, P.O. Box 2062

City Albany

State NY

Zip Code 12220

 

Notes on ApplyingPlease submit a resume, cover letter, and transcript to the attention of RoxanSchuyler Younkin at HR.Recruitment@its.ny.gov, no later than August 20, 2018, and indicate that you are applying for Student Assistant- Service Delivery Analytics Intern, ref.# 90006M. Please specify in your cover letter how you meet the minimum and preferred qualifications, including any relevant course work. Proof of your student status (i.e. course schedule, transcript, or other documentation) and GPA will be required prior to appointment.