NY HELPYes

AgencyEducation Department, State

TitleInformation Technology Specialist 3 (Database) (NY HELPS), Box PIMS-799/01570

Occupational CategoryI.T. Engineering, Sciences

Salary Grade23

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

Salary RangeFrom $84156 to $106454 Annually

Employment Type Full-Time

Appointment Type Permanent

Jurisdictional Class Competitive Class

Travel Percentage 0%

Workweek Mon-Fri

Hours Per Week 37.5

Workday

From 9 AM

To 5 PM

Flextime allowed? No

Mandatory overtime? No

Compressed workweek allowed? No

Telecommuting allowed? Yes

County Albany

Street Address Office of Performance Improvement and Management Services

Statewide Longitudinal Data System

City Albany

StateNY

Zip Code12234

Minimum Qualifications MINIMUM QUALIFICATIONS:

NY HELPS
This title is part of the New York Hiring for Emergency Limited Placement Statewide Program (NY HELPS).

For the duration of the NY HELPS Program, this title may be filled via a non-competitive appointment, which means no examination is required but all candidates must meet the minimum qualifications of the title for which they apply. At a future date (within one year of permanent appointment), it is expected employees hired under NY HELPS will have their non-competitive employment status converted to competitive status, without having to compete in an examination. Employees will then be afforded with all of the same rights and privileges of competitive class employees of New York State. While serving permanently in a NY HELPS title, employees may take part in any promotion examination for which they are qualified.

NON-COMPETITIVE MINIMUM QUALIFICATIONS:
To be considered for appointment through NY HELPS, or 55 b/c, candidates must meet ONE of the open-competitive minimum qualifications for this position. The qualifications are:

Five years of experience in database programming or administration. the database programming or administration experience must have involved direction or performance of activities related to managing and maintaining enterprise database environments as well as the data contained in the databases. The experience must have included responsibility for designing, implementing, and maintaining database systems.

SUBSTITUTION: A bachelor's degree in any field including or supplemented by 15 semester credit hours in programming languages and two years of experience in database programming or administration; OR a bachelor's or higher-level degree in any field and three years of experience in database programming or administration; OR an associate degree with 15 semester credit hours in a programming languages field and four years of experience in database programming or administration.

PROMOTION: Current NYSED State employees must have one year of permanent competitive or 55-b/55-c service as an Information Technology Specialist 2, Information Technology Specialist 2 (Programming), or Supervising Computer Operator.

SPECIALIZED REQUIREMENTS:

Candidates must also possess:
• 1 to 2 years of experience in ETL (Extract, Transform, Load)
• More than 2 to 5 years of experience in SQL

COMPETITIVE MINIMUM QUALIFICATIONS:

Reassignment: Candidates must have one year of permanent competitive or 55b/c service as an Information Technology Specialist 3 (Database).

Eligible List Appointment: Candidates must be reachable on the Civil Service eligible list for this title. If you are on the Civil Service eligible list for this title, you may receive a canvass letter. You must complete and return it as instructed on the letter.

Section 70.1 Transfer: Candidates must have one year of permanent competitive or 55b/c service in any of the following titles: Chief Computer Operator, Information Technology Specialist 3, Information Technology Specialist 3 (Data Communications), Information Technology Specialist 3 (Systems Programming).

Section 52.6 Transfer: Candidates must have one year of permanent competitive or 55b/c service in a title allocated SG-21 or higher eligible to transfer under Section 52.6 of the Civil Service Law.

For information regarding the transfer options of your current title, please visit the Civil Service Career Mobility Office Website. https://careermobilityoffice.cs.ny.gov/cmo/gotit/title-search/index.cfm

55b/c Appointment: This position is eligible for 55b/c designation and candidates with 55b/c eligibility are encouraged to apply. Candidates must possess a current 55b/c eligibility letter and one of the following minimum qualifications:

Either 1. a bachelor's or higher-level degree in any field including or supplemented by 15 semester credit hours in programming languages AND two years of experience in database programming or administration;

Or 2. a bachelor's or higher-level degree in any field AND three years of experience in database programming or administration;

Or 3. an associate degree* with 15 semester credit hours in programming languages AND four years of experience in database programming or administration;

Or 4. five years of experience in database programming or administration.

To qualify for consideration, the database programming or administration experience must have involved direction or performance of activities related to managing and maintaining enterprise database environments as well as the data contained in the databases. The experience must have included responsibility for designing, implementing, and maintaining database systems.

*Candidates who have completed at least 60 college semester hours in a bachelor's degree program, including at least 15 semester credit hours in a computer science field, also qualify, but must meet the experience requirements as described in #3.

Provisional Appointment: In the absence of an eligible list with three or more candidates willing to accept a position, a temporary provisional appointment may be considered. For provisional appointment, candidates must meet ONE of the following qualifications:

1. a bachelor's or higher-level degree in any field including or supplemented by 15 semester credit hours in programming languages AND two years of experience in database programming or administration;

Or 2. a bachelor's or higher-level degree in any field AND three years of experience in database programming or administration;

Or 3. an associate degree* with 15 semester credit hours in programming languages AND four years of experience in database programming or administration;

Or 4. five years of experience in database programming or administration.

Or 5. Be a current New York State Department of Education employee must have one year of permanent competitive or 55-b/55-c service as an Information Technology Specialist 2, Information Technology Specialist 2 (Programming), or Supervising Computer Operator.

To qualify for consideration, the database programming or administration experience must have involved direction or performance of activities related to managing and maintaining enterprise database environments as well as the data contained in the databases. The experience must have included responsibility for designing, implementing, and maintaining database systems.

*Candidates who have completed at least 60 college semester hours in a bachelor's degree program, including at least 15 semester credit hours in a computer science field, also qualify, but must meet the experience requirements as described in #3.

Provisional candidates must take the examination for Information Technology Specialist 3 (Database) when it is next offered, and must be reachable on the resulting eligible list to maintain employment.

PREFERRED QUALIFICATIONS:

Preference will be given to candidates who also possess:
• 1 to 2 years of experience in ETL (Extract, Transform, Load)
• More than 2 to 5 years of experience in SQL

Duties Description The New York State Education Department’s Office of Information Technology Services is seeking applicants for the position of Information Technology Specialist (ITS) 3 (Database). Under the direction of the Information Technology Specialist 4 (Database), the Information Technology Specialist 3 (Database) will serve as the extract, transform, and load (ETL) Developer for the State Longitudinal Data System (SLDS) project. The SLDS project aims to modernize infrastructure and improve the interoperability to demonstrate proof-of-concept for a Statewide Longitudinal Data System, which ultimately integrates data from Pre-K through 12 grade, higher education, and workforce data sets. Duties of this position include, but are not limited to:
• Designs and develops extract, transform, and load (ETL) data processes for transmission of data among various source systems according to the business requirements for loading data into the SLDS;
• Assists with development of data transformation into a single data model for the SLDS;
• Collaborates with stakeholders to understand data requirements and business rules for the data;
• Builds and maintains data pipelines to automate the ETL processes and ensure data consistency and accuracy;
• Develops SQL queries, scripts, and code to perform data transformations, cleansing, and validations;
• Implements error handling and logging mechanisms to capture and report data quality issues during the ETL process;
• Optimizes ELT performance by tuning SQL queries, optimizing data loading processes and leveraging parallel processing techniques;
• Testing and validating ETL processing to ensure they meet functional and performance requirements;
• Documenting ETL processes, data mapping, and transformations for reference and knowledge sharing;
• Provides guidance to support the SLDS team on ETL processes, data transformation best practices, and emerging technologies to continuously improve the SLDS data operations and data infrastructure;
• Collaborates with other program offices and state agencies to ensure alignment with overall organizational goals and state SLDS goals and strategies; and
• Manages all SLDS technical work using NYSED IT system tools, such as Atlassian Jira and Confluence.

Additional Comments CONDITIONS OF EMPLOYMENT:
This will be a permanent competitive appointment, a permanent non-competitive appointment, or a temporary provisional appointment. At this time, agencies may recruit and hire employees by making temporary appointments. Provisional candidates must take the examination for Information Technology Specialist 3 (Database) when it is next offered and must be reachable on the resulting eligible list to maintain employment. For 55b/c appointment, candidates must possess the minimum qualifications, a current 55b/c eligibility letter and is subject to verification of applicant eligibility. Promotions and transfers may change appointees’ negotiating unit. Candidates should be aware that changes in negotiating units may affect their salary, insurance, and other benefits. Verification of education and experience will be required at the time of interview for all candidates.

This position leads to a maximum salary of $106,454 based on annual performance advances.

APPLICATION: Qualified candidates should send a resume and letter of interest by October 21, 2024, to omsjobs@nysed.gov (email submissions are preferred). Your resume must clearly indicate how you meet the minimum qualifications for this position. You must include the Box number (PIMS-799/01570) of the position in the subject line of your email and cover letter to ensure receipt of your application. Links to application materials will not be accepted (i.e., Google Docs). Your social security number may be required to confirm your eligibility.

New York State Education Department (NYSED) is an equal opportunity/affirmative action employer. NYS Human Rights Law prohibits discrimination because of age, race, creed, color, national origin, sexual orientation, military status, sex, disability, predisposing genetic characteristics, marital status, domestic violence victim status, gender identity, prior conviction records, prior arrests, youthful offender adjudications, or sealed records.

Interested in a job with New York State, but don’t know where to start?

Visit these links for information on working for New York State:
• https://www.cs.ny.gov/jobseeker/
• https://www.cs.ny.gov/pio/publications/gettingajob.pdf

Generous benefits of working for New York State, including, but not limited to, the following:

Holiday & Paid Time Off
• Thirteen (13) paid holidays annually.
• Thirteen (13) days of paid vacation leave in year one, increasing to 20+ days with additional years of service.
• Five (5) days of paid personal leave annually.
• Thirteen (13) days of paid sick leave annually for PEF/CSEA and eight (8) days paid sick leave annually for M/C.
• Annual professional leave and educational leave opportunities for eligible staff.

Health Care Benefits
• Eligible employees and dependents can choose from a variety of affordable and generous health insurance programs.
• Family dental and vision benefits at no additional cost.

Additional Benefits
• Enrollment in the New York State pension system which has earned the distinction of being one of the best-managed and best-funded plans in the nation OR Optional Retirement Defined Contribution Plan with 8% salary match (eligibility requirements apply).
• NYS Deferred Compensation and an exclusive 403(b) Optional Retirement Savings Plan.
• Paid Parental Leave for all employees and Paid Family Leave (M/C Only).
• Public Service Loan Forgiveness (PSLF).
• Opportunities for telecommuting.
• Eligibility for various life insurance options.

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

Name Office of Human Resources Management

Telephone (518) 474-5215

Fax (518) 486-5631

Email Address omsjobs@nysed.gov

Address

Street NYS Education Department

89 Washington Avenue, OHRM, Room 528 EB

City Albany

State NY

Zip Code 12234

Notes on ApplyingAPPLICATION: Qualified candidates should send a resume and letter of interest by October 21, 2024, to omsjobs@nysed.gov (email submissions are preferred). Your resume must clearly indicate how you meet the minimum qualifications for this position. You must include the Box number (PIMS-799/01570) of the position in the subject line of your email and cover letter to ensure receipt of your application. Links to application materials will not be accepted (i.e., Google Docs). Your social security number may be required to confirm your eligibility.