"Alerted.org

NY HELP No

Agency Information Technology Services, Office of

Title IES Database Developer (Project Assistant) ref# 10182

Occupational Category I.T. Engineering, Sciences

Salary Grade NS

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

Salary Range From $66951 to $85138 Annually

Employment Type Full-Time

Appointment Type Temporary

Jurisdictional Class Competitive Class

Travel Percentage 10%

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

County Albany

Street Address 40 North Pearl Street

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

City Albany

State NY

Zip Code 12207

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 Data Management Specialist, the IES Database Developer will be assigned to the Integrate Eligibility System (IES) within the Office of Information Technology Services (ITS) and will work with the Data Management Teams designing, implementing, and optimizing Master Data Management (DM) solutions. Duties include but are not limited to the following. • Design and implement scalable DM solutions, including data modeling, data quality, governance, and integration strategies.• Guide the definition and implementation of DM architecture principles and design patterns for various styles, ensuring smooth data publishing and subscribing for applications.• Utilize programming languages (Python, R, SQL) for data manipulation, analysis, and process automation. • Design and implement ETL/ELT pipelines using tools like Informatica.• Build and deploy DM solutions and integrations on cloud platforms such as GCP and AWS.• Analyze existing DM architectures and develop roadmaps for optimization.• Research emerging DM trends and refine technology strategy.• Act as a business analyst, gathering requirements, performing fit-gap analysis, and preparing documentation.• Identify automation opportunities in data conversion and integration processes to improve efficiency.• Ensure adherence to data governance policies and security measures.• Collaborate with stakeholders to understand data requirements and resolve issues.

Minimum Qualifications Minimum Qualifications: Two (2) years of experience in experience in DM architecture, data modeling, governance, and data quality.• A Bachelor’s degree in Computer Science or a closely related field may substitute for one (1) year of general experience.• A Master’s degree in Computer Science, or a closely related field may substitute for one (1) additional year of general experience.Preferred Qualifications:• Experience with Python, R, and SQL (PostgreSQL) and DM tools like Informatica and ETL/ELT processes.• Experience with building and deploying solutions on AWS and GCP, including relevant cloud services.• Experience in Python, API and Webservices for data integration.• Experience in conducing fit-gap analysis, document requirements, and facilitate workshops.• Experience identifying and implementing automation for process improvement.• Experience working in a government setting.

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.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 NYSGenerous 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 developmentHealth Care Benefits• Eligible employees and dependents can pick from a variety of affordable health insurance programs• Family dental and vision benefits at no additional costAdditional 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.

Name human.resources

Telephone 518-473-0398

Fax 518-402-4924

Email Address [email protected]

Address

Street Empire State Plaza, Swan Street Building, Core 4

PO Box 2062

City Albany

State NY

Zip Code 12220

Notes on Applying To apply for this position, please send a cover letter and resume indicating that you are applying for IES Database Developer (Project Assistant) Ref# 10182 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.