Please note: State agencies that contact job applicants do not usually request personal or financial information via text message or over the phone in connection with your response to a job posting. If you are contacted for such information by these methods, or any other method, please verify the identity of the individual before transmitting such information to that person.
Pursuant to Executive Order 161, no State entity, as defined by the Executive Order, is permitted to ask, or mandate, in any form, that an applicant for employment provide his or her current compensation, or any prior compensation history, until such time as the applicant is extended a conditional offer of employment with compensation. If such information has been requested from you before such time, please contact the Governor's Office of Employee Relations at (518) 474-6988 or via email at

Note: For questions about the job posting, please contact the agency that posted this position by using the contact information provided on the "Contact" tab for the position.

Review Vacancy

Date Posted 09/10/18

Applications Due09/21/18

Vacancy ID58781

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%

Workweek Mon-Fri

Hours Per Week 30


From 8 AM

To 5 PM

Flextime allowed? No

Mandatory overtime? No

Compressed workweek allowed? No

Telecommuting allowed? No

County Albany

Street Address 50 Wolf Road

City Albany


Zip Code12205

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.

Name Schuyler Younkin

Telephone 518-473-0398

Fax 518 402-4924

Email 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, no later than September 21, 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.

Printable Version