Review Vacancy
AgencyInformation Technology Services, Office of
TitleIES ETL Developer (Project Assistant) ref# 10992
Occupational CategoryI.T. Engineering, Sciences
Bargaining UnitPS&T - Professional, Scientific, and Technical (PEF)
Salary RangeFrom $66951 to $85138 Annually
Duties Description ITS provides operational support to state agencies on a 24x7x365 basis; some positions may be required to provide this critical service at any time.
Under the direction of a senior program manager, the IES ETL Developer will be assigned to the Integrated Eligibility System (IES) within the Office of Information Technology Services (IES) and will be responsible for designing, developing, and maintaining data integration solutions. The incumbent will employ expertise in data warehousing, ETL processes, and data pipeline optimization, along with a solid understanding of database systems and data modeling.
Duties include, but are not, limited to the following:
• Design, develop and maintain ETL processes to extract, transform, and load data from various sources.
• Build and optimize scalable data pipelines for large datasets. Ensure data accuracy, integrity, and consistency across systems.
• Collaborate with data analysts, data engineers, and business stakeholders to understand data requirements.
• Develop and maintain data warehouse architectures and data models.
• Troubleshoot and resolve data-related issues and performance bottlenecks.
• Implement data quality checks and validation processes.
• Document ETL processes, workflows, and data mappings.
• Monitor ETL jobs and ensure timely data delivery.
• Stay updated with industry trends and emerging data technologies.
Minimum Qualifications Four (4) years of experience in ETL development including Databricks, Informatica, or ETL tools, experience in data engineering, or any data migration project as well as proficiency in programming/scripting.
Bachelor’s Degree may substitute for 2 years of experience
Master’s Degree may substitute for 3 years of experience.
Preferred Qualifications:
Preferred Qualifications
• Experience in SQL and relational databases (i.e., Oracle, SQL Server, MySQL, PostgreSQL).
• Experience with data warehousing concepts and implementation.
• Strong understanding of data integration, transformation, and migration techniques.
• Knowledge of cloud data platforms (i.e., AWS Redshift, Azure Data Factory, Google BigQuery).
• Familiarity with data governance, data quality frameworks and methods.
• Understanding of Agile/Scrum methodologies.
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration abilities
Additional Comments ITS will not offer permanent employment to any candidate unless the candidate provides documentation that they are authorized to accept work in the United States on a permanent basis. It is the policy of ITS not to hire F1 or H1 visa holders for permanent employment or to sponsor non-immigrant aliens for temporary work authorization visas or for permanent residence.
May fill multiple positions
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.
Benefits of Working for NYS
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.
• Up to three (3) days of professional leave annually to participate in professional development
Health Care Benefits
• Eligible employees and dependents can pick from a variety of affordable health insurance programs
• Family dental and vision benefits at no additional cost
Additional 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.
Some positions may require additional credentials or a background check to verify your identity.
Email Address PostingResponses@its.ny.gov
Address
Street Empire State Plaza, Swan Street Building, Core 4
PO Box 2062
Notes on ApplyingTo apply for this position, please send a cover letter and resume indicating that you are applying for IES ETL Developer (Project Assistant) Ref# 10992 and include the Vacancy ID in the subject line. In your cover letter, please clearly indicate how you meet the minimum qualifications as stated above, and describe relevant experience for this position.
Fingerprinting will/may be required as part of a background check.