The Office of Accountability Strategies (OAS) is responsible for providing strategic operational, analytical, and systems support services to the DSS-AO (Department of Social Services Accountability Office), across the DSS, and to sister agencies outside of DSS, ensuring data driven efficiencies are effectively implemented. Within OAS, Data Analytics, Reporting and Triage (OAS-DART) is responsible for supporting the integrity of social service programs. DART is responsible for developing technological and analytical advancements that represent an intelligence-led, data-driven Agency. DART maintains the data analysis, reporting and performance measurement systems of DSS-AO, utilizing advanced analytics to identify new investigative initiatives, refer cases with the highest probabilities of fraud, and ensure data quality and reporting.

OAS-DART is recruiting for one (1) Computer Associate Software II to function as a System Data Associate, who will:

- Create in a relational database user tables, views, user functions and stored procedures based on business rules.

- Manage the data manipulation of large data files extracted from various databases (SQL, Oracle, DB2) and export these data sets into output that can be analyzed and used for decision making.

- Gather and interpret database statistics to monitor performance. Make database changes as necessary to address performance problems.

- Assist systems administrator with installing, configuring, and maintaining servers that host the database system. Create, save, restore and test databases for system or user testing. Initiate backup and recovery procedures.

- Apply and implement metadata standards for data elements (i.e., naming conventions, formats, and default values) for system/applications.

- Maintain a repository for data element definitions and, from that repository, produces data reports.

- Assist in the preparation and support of data conversion and migration. Load data from different sources into databases.

- Analyze table change requests and their impact on other tables. Create programs, load and extract on ad hoc basis with minimal supervision and direction

1. A baccalaureate degree from an accredited college including or supplemented by 24 semester credits in computer science or a related computer field and one year of satisfactory full-time computer software experience in computer systems development and analysis, applications programming, database administration, maintenance and support, systems programming, data communications, mainframe development, mobile development, web development and design; or

2. A four-year high school diploma or its educational equivalent and five years of satisfactory full-time computer software experience as described in "1" above; or

3. Education and or/or experience equivalent to "1" or "2" above. College education may be substituted for up to two years of the required experience in "2" above on the basis that 60 semester credits from an accredited college is equated to one year of experience. In addition, 24 semester credits from an accredited college or graduate school in computer science or a related field, or a certificate of at least 625 hours in computer programming from an accredited technical school (post high school), may be substituted for one year of experience. However, all candidates must have at least a four-year high school diploma or its educational equivalent and at least one year of satisfactory full-time experience as described in "1" above.

- Proficiency in Structured Query Language (SQL) queries and stored procedures on various relational databases including Oracle and SQL Server - Experience in Business Intelligence and Analytical Tools (e.g., OBIEE), to deliver advanced analytical business reporting solutions - Experience in .NET programming and web application design - Experience in SharePoint design - Experience in SQL Server Reporting Service (SSRS) and SQL Server Integration Service (SSIS) - Experience in Microsoft Access and Visual Basic for Applications (VBA)

THIS POSITION IS OPEN TO QUALIFIED PERSONS WITH A DISABILITY WHO ARE ELIGIBLE FOR THE 55-A PROGRAM. PLEASE INDICATE IN YOUR COVER LETTER THAT YOU WOULD LIKE TO BE CONSIDERED FOR THE POSITION UNDER THE 55-A PROGRAM.

New York City Residency is not required for this position

The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.