Information Technology Spec 2-Data Warehouse (NY HELPS)

NY HELP Yes Agency Insurance Fund, State Title Information Technology Spec 2-Data Warehouse (NY HELPS) Occupational Category I.T. Engineering, Sciences Salary Grade 18 Bargaining Unit PS&T - Professional, Scientific, and Technical (PEF) Salary Range From $65001 to $82656 Annually Employment Type Full-Time Appointment Type Permanent Jurisdictional Class Competitive Class Travel Percentage 5% 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 15 Computer Dr West City Albany State NY Zip Code 12205 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 2; 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: Experience with Oracle, SQL, PL/SQL, JavaScript, Python, C# and OOP techniques. Duties Description As a member of NYSIF’s Data Warehouse Team, duties include but are not limited to: Develop, maintain, and document code written in SQL and PL/SQL. Design/create database structures including PL/SQL, tables, packages, procedures, functions. Develop code/script using JavaScript, Python, C# and OOP techniques. Test, verify and implement new and modified code. Address service requests as it relates to NYSIF Data Warehouse Reporting. 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 InclusionThe 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 [email protected]. Some positions may require additional credentials or a background check to verify your identity.Name Megan Browe Telephone Fax Email Address [email protected] Address Street PO Box 66699 City Albany State NY Zip Code 12206 Notes on Applying Please send a resume and cover letter to [email protected]. Please be sure to include the Vacancy ID number in the subject of your email.