What are the responsibilities and job description for the IES ETL Developer (Project Assistant) ref# 10992 position at NYS Office of Information Technology Services?
Description
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
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
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
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
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
- Eligible employees and dependents can pick from a variety of affordable health insurance programs
- Family dental and vision benefits at no additional cost
- 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.
Salary : $66,951 - $85,138