1 SYSTEM DATA ASSOCIATE Job in Manhattan, NY

SORT BY

SET JOB ALERT

OFF

Details...

SYSTEM DATA ASSOCIATE

NYPD Civilian Jobs

Manhattan, NY | Full Time

$69k-89k (estimate)

4 Months Ago

SYSTEM DATA ASSOCIATE

NYPD Civilian Jobs Manhattan, NY

$69k-89k (estimate)

Full Time 4 Months Ago

Save

Sorry! This job is no longer available. Please explore similar jobs listed on the left.

NYPD Civilian Jobs is Hiring a SYSTEM DATA ASSOCIATE Near Manhattan, NY

HRA/DEPT OF SOCIAL SERVICES

Full-Time

Location

MANHATTAN

Exam May Be Required

Department

DSS ACCOUNTABILITY OFFICE NM

Salary Range:

$71,707.00 – $82,463.00

Job Description

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.

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

Minimum Qualifications

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.

Preferred Skills

- 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)

55a Program

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.

Residency Requirement

New York City Residency is not required for this position

Additional Information

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.

Job ID

529137

Title code

13631

Civil service title

COMPUTER ASSOC (SOFTWARE)

Title classification

Competitive-1

Business title

SYSTEM DATA ASSOCIATE