Review Vacancy
TitleInformation Technology Specialist 2-Data Warehouse (NY HELPS)
Occupational CategoryI.T. Engineering, Sciences
Bargaining UnitPS&T - Professional, Scientific, and Technical (PEF)
Salary RangeFrom $77329 to $86056 Annually
Duties Description As a member of NYSIF’s Data Warehouse Team, duties include but are not limited to:
• Analyze and gather requirements for software systems.
• Design, develop and modify relational and multidimensional database structures and data flows.
• Design, develop and modify database procedures/packages to perform data extraction, transformation and loading into Data Warehouse.
• Identify and implement improvements to SQL queries for increased performance.
• Design, develop and modify data visualization dashboards.
• Develop and maintain automated deployment scripts and jobs (CI/CD).
• Develop and maintain documentation for existing and new systems.
• Investigate and resolve service tickets by analyzing data and process to identify root cause of the issue.
• Work Schedule includes production support after hours and weekends.
Minimum Qualifications • Reachable on current Civil Service eligible list for this title; OR
• One year of permanent, competitive class service as an Information Technology
Specialist 1; OR
• One year of permanent, competitive class service as an Information Technology Specialist 2 (Programming); OR
• One year of permanent, competitive class service in a title eligible for transfer Section 52.6 of the Civil Service Law; OR
• Bachelor's or higher-level degree including or supplemented by 15 semester credit hours in computer science; OR
• Bachelor's or higher-level degree in any field AND one year of experience in information technology; OR
• 60 semester credit hours including or supplemented by 15 semester credit hours in computer science AND one year of experience in information technology; OR
• Two years of experience in information technology.
Note: Certain math and business courses although taken as part of a computer science curriculum, are not counted towards the 15 semester credit hours.
Preferred Qualifications:
• Advanced knowledge and experience in relational databases, SQL.
• Experience in database design and modeling.
• Experience with ETL tools such as IBI Data Migrator, Informatica PowerCenter
• Experience with Data visualization tools such as Spotfire, Tableau, Power BI.
• Development experience in Python
• Development experience in R is a plus.
Additional Comments For new State employees appointed to graded positions, the annual salary is the hiring rate (beginning of the Salary Range) of the position. Promotion salaries are calculated by the NYS Office of the State Comptroller in accordance with NYS Civil Service Law, OSC Payroll rules and regulations and negotiated union contracts.
Fringe Benefits:
• Competitive Compensation.
• Future Career Growth Potential.
• Open and Supportive Team-Based Environment.
• Plentiful Vacation, Personal, and Sick Leave Accruals.
• Paid State and Federal Holidays.
• Full Medical, Vision, and Dental.
• Retirement Options.
• Public Student Loan Forgiveness (PSLF).
• Possibility of Telecommuting, Flextime, and Alternative Work Schedules.
NY HELPS Program:
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, 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 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.
NYSIF Commitment to Diversity, Equity, and Inclusion
The New York State Insurance Fund (NYSIF) prioritizes and champions diversity, equity, and inclusion (DEI) throughout our agency. NYSIF provides equal opportunities to all employees and applicants for employment without regard to race, religion, color, age, sex, national origin, sexual orientation, gender identity, disability, veteran status, or any other protected category under federal, state, and local law. We believe that embracing our differences brings richness, new ideas and experiences to NYSIF, which energizes a creative and innovative work environment. We strive to foster a workplace where diverse individuals are able to participate fully in the decision-making process and have ample opportunity for advancement. We are committed to investing the necessary resources and attention to improving the engagement, retention, and promotion of the extraordinary talent we have.
Executive Order 31 commits New York State government to becoming a model employer for people with disabilities, increasing the participation of people with disabilities in state service and ensuring equal access to opportunities. NYSIF is proud to utilize best practices to recruit, hire, retain, and promote career advancement of individuals with disabilities. This includes special focus on current and prospective employees with the most significant disabilities, such as the use of supported employment, individual placement with support services, customized employment, the civil service sections 55/b and 55/c programs, internships, and job shadowing. If you are a person with a disability and wish to request that a reasonable accommodation be provided for you to participate in a job interview, please send an email to NYSIF’s Reasonable Accommodations mailbox at ra@nysif.com.
Some positions may require additional credentials or a background check to verify your identity.