Review Vacancy
TitleInformation Technology Specialist 3 (Systems Programming)
Occupational CategoryI.T. Engineering, Sciences
Bargaining UnitPS&T - Professional, Scientific, and Technical (PEF)
Salary RangeFrom $67703 to $85635 Annually
Appointment Type Contingent Permanent
Minimum Qualifications Eligible to transfer into this title based on one year permanent competitive class service in a title eligible for transfer under Section 70.1 of the Civil Service Law. Examples of eligible titles: Examples of eligible titles: Information Technology Specialist 3, Information Technology Specialist 3 - Data Communications or Information Technology Specialist 3 - Database. If you have questions about your transfer eligibility, please feel free to contact the Personnel Department.
Duties Description The incumbent will work in NYSIF Business Intelligence & Data warehouse team, his/her tasks include:
• Develop and maintain extraction codes in Oracle PL/SQL.
• Develop and maintain reports written in IBI InfoAssist and WebFOCUS.
• Develop and maintain BI dashboards using Tibco Spotfire and IBI WebFOCUS.
• Develop and maintain automated deployment scripts.
• Implement and maintain Data warehouse and DataMart using start Schema.
• Develop and maintain documentation for existing and new systems (users’ requirement, system diagrams, ER diagrams, source-to-target mapping documents…)
• Develop and maintain ETL script using IBI Data Migrator.
• Develop, maintain and perform unit testing, data cleansing and validation.
• Troubleshoot and fix bugs, errors and data discrepancies issues.
Additional Comments Please identify your current Civil Service title in your cover letter.
Some positions may require additional credentials or a background check to verify your identity.