Apply on Employer Site

NYS Office of Information Technology Services · 17 hours ago

Information Technology Specialist 4 Database - 10332

Albany, NY

Full-time

Onsite

Entry, Mid Level

1+ years exp

The NYS Office of Information Technology Services is responsible for providing technology solutions to support public safety. The Information Technology Specialist 4 will assist in data management, governance, and database support while collaborating with various teams to ensure data quality and compliance.

Cyber SecurityGovernmentInformation TechnologyIT Infrastructure

No H1B

Responsibilities

Assist in the day-to-day collection, validation, and entry of data from various sources into centralized databases

Perform routine data cleaning and standardization tasks to ensure accuracy, completeness, and consistency

Help enforce data governance policies and naming conventions under the guidance of senior staff

Conduct basic data quality checks, identify anomalies or duplicates, and report issues to senior team members

Assist in documenting data sources, definitions, and lineage (data dictionaries, metadata)

Execute basic queries (using SQL or similar) to extract data for reports or analysis as requested

Assist in the monitoring of data pipelines and ETL (Extract, Transform, Load) processes, flagging any failures

Perform regular database backups and support restoration tests

Help with user access management, granting basic permissions following approved requests

Support the migration and archiving of data according to retention policies

Generate and distribute standard reports and dashboards using tools like Excel, Power BI, or Tableau

Support other teams (e.g., Analytics, Marketing, Operations) by providing clean, reliable datasets for their projects

Participate in meetings to understand data needs and communicate updates on data status

Assist in preparing data for internal and external audits

Maintain detailed logs of data management activities and issues

Stay updated on company data policies, compliance requirements, and best practices

Proactively learn new data management tools and technologies as required

Complete all assigned tasks with a high degree of accuracy and attention to detail

Qualification

SQLData GovernanceETL ProcessesData CleaningData ReportingProfessional DevelopmentAttention to DetailCollaboration

Required

Open to NYS employees with one year of permanent competitive service as an Information Technology Specialist 4, SG25 OR in a position at the SG23 level or higher deemed administrative under Section 52.6 of Civil Service Law OR in a title eligible for transfer under Section 70.1 of Civil Service Law

The transfer cannot be a second consecutive transfer resulting in advancement of more than two salary grades

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

Some positions may require fingerprinting

Some positions may require up to 25% travel and/or lifting up to 50 lbs

Benefits

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.

Company

NYS Office of Information Technology Services

New York State Office of Information Technology Services (ITS) is transforming how State government delivers services to New Yorkers and local governments.

Founded in 2012

Albany, New York, USA

5001-10000 employees