Student Assistant Internship (Shared Application Services), Ref# 8896 - StateJobsNY : Job Details

Duties Description Under the direction of an Information Technology Specialist 2, within Digital Transformation Office, Shared Application Services, Service Management, this position will assist in the daily operations of MeasureIT Performance Management Application. Specific duties include but not limited to: 1. Create & Update technical documentation, procedures, and develop data dictionaries for MeasureIT products. 2. Help support and maintain daily ETL Processes using SQL to view logging, and using SQL Server Integration Services (SSIS) to debug and rerun processes. 3. Help support and maintain daily SQL Server Reporting Services (SSRS) processes using SQL to view logging, and using SSRS to debug and rerun the process. 4. Writing simple to moderate queries in Transact SQL to perform data analysis for performance management requests. 5. Maintain reporting refreshes using Excel & Power BI. 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.0 or equivalent to a C. Additional Comments This position can be part time or full time.Fingerprinting and background check may be required.Benefits of Working for NYS for eligible employees:Generous benefits package, worth 65% of salary, including:Holiday & Paid Time Off•Thirteen (13) paid holidays annually•Up to Thirteen (13) days of paid vacation leave annually•Up to Five (5) days of paid personal leave annually•Up to Thirteen (13) days of paid sick leave annually for PEF/CSEA•Up to Eight (8) days of paid sick leave annually for M/C•Up to three (3) days of professional leave annually to participate in professional development•Up to 50% telecommutingHealth Care Benefits•Eligible employees and dependents can pick from a variety of affordable health insurance programs•Family dental and vision benefits at no additional costAdditional Benefits•New York State Employees' Retirement System (ERS) Membership•NYS Deferred Compensation•Access to NY 529 and NY ABLE College Savings Programs, as well as U.S. Savings Bonds•Public Service Loan Forgiveness (PSLF)•And many more.The Office of Information Technology Services is an equal opportunity employer, and we recognize that diversity in our workforce is critical to fulfilling our mission. We encourage all individuals with disabilities to apply. Some positions may require additional credentials or a background check to verify your identity.Name Student Assistant Program Telephone 518-###-#### Fax Email Address [email protected] AddressStreet NYS Office of Information Technology Services Swan Street Building, Core 4 City Albany State NY Zip Code 12242 Notes on Applying Please complete the Student Assistant Application: no later than May 13, 2025. If you have any issues with the form, please contact ITS Student Assistant Program by email at [email protected].