Position Information

NY HELPNo

AgencyInformation Technology Services, Office of

TitleIES ETL Developer (Project Assistant) ref# 10992

Occupational CategoryI.T. Engineering, Sciences

Salary GradeNS

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

Salary RangeFrom $66951 to $85138 Annually

Employment Type Full-Time

Appointment Type Temporary

Jurisdictional Class Competitive Class

Travel Percentage 10%

Schedule

Workweek Mon-Fri

Hours Per Week 37.5

Workday

From 9 AM

To 5 PM

Flextime allowed? No

Mandatory overtime? No

Compressed workweek allowed? Yes

Telecommuting allowed? Yes

Location

County Albany

Street Address 40 North Pearl Street

May be filled in NYC or other locations in New York.

City Albany

StateNY

Zip Code12207

Job Specifics

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.

How to Apply

Name Jeff Memole

Telephone 518-473-0398

Fax 518-402-4924

Email Address PostingResponses@its.ny.gov

Address

Street Empire State Plaza, Swan Street Building, Core 4

PO Box 2062

City Albany

State NY

Zip Code 12220

 

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.