Computer Associate - Data Acquisition Systems

The NYC Department of Environmental Protection (DEP) enriches the environment and protects public health for all New Yorkers by providing 1.1 billion gallons of high-quality drinking water, managing wastewater and stormwater, and reducing air, noise, and hazardous materials pollution. DEP is the largest combined municipal water and wastewater utility in the country, with nearly 6,000 employees. DEP's water supply system is comprised of 19 reservoirs and 3 controlled lakes throughout the system’s 2,000 square mile watershed that extends 125 miles north and west of the City.

The Bureau of Water Supply seeks to hire a Computer Associate (Software) I for a position within Engineering & Construction Division, Drinking Water Operations Directorate, located in Downsville, New York. The Bureau of Water Supply (BWS) Engineering & Construction Division’s Dam Safety group oversees the BWS Dam Safety Program which tracks, performs, and maintains: operation & maintenance, inspections, work order management, instrumentation, emergency planning, regulatory compliance, facility improvements, and operational safety of the BWS system of 34 water supply impounding structures as well as 120 other smaller dams throughout the watersheds.

Dam instrumentation (e.g. piezometers, inclinometers, extensometers, crack gauges, flow meters, etc.) is valuable for remote and continuous monitoring of dam safety parameters at DEP’s water supply impoundments. BWS is improving and expanding the dam safety instrumentation used to remotely monitor the performance of these critical structures. Key to the planned expansion and improvements are importing data from dam instrumentation throughout the watershed into the Automated Data Acquisition System (ADAS), interfacing the ADAS with other DEP operational databases, expanding remote alarms and alerts, and maintaining and updating the ADAS operating systems as needed.

Under direct supervision of the Dam Safety Engineer, the Computer Associate (Software) I will serve as the Computer Associate- Data Acquisition Systems and will manage the Dam Safety ADAS and associated databases. They will manage the BWS meteorological monitoring system which generally consists of its own remote data acquisition system (RDAS), and its associated weather stations, snow pillows, and communication facilities. Specific duties include:

- The analysis, design, development, implementation, troubleshooting, enhancement, upgrades (hardware and software) maintenance, and security of the Dam Safety ADAS database management systems, data communications systems, applications, websites and/or related software functions. Diagnoses problems and communicates technical issues to technical and non-technical audiences. Creates, maintains, and implements source code and may participate in application analysis and testing. Prepares program specifications and diagrams, develop logic flowcharts, and documents program development and revisions. Provide similar support for meteorological RDAS systems.

- Addressing system users support requests, add/remove users, reset passwords, etc.

- Interfacing with technology providers’ personnel and DEP Bureau Information Technology staff to address problems

- Supporting ongoing maintenance of reporting and data solutions

- Supporting ongoing maintenance and expansion of field hardware installations and data stream integration into existing and new operating databases.

- Analyzing business requirements into technical requirements for reporting/visualizations, data models, and databases.

- Reviewing technical specifications derived from technical requirements

- Participate in the design, performance, and code review process

- Overseeing development and maintenance of the division's data repository and ensure successful data gathering and validating the accuracy of the data prior to publication of reports.

- Learning and maintaining general understanding of water supply and water delivery

(This is a brief description of what a Computer Associate (Software) I might do in this position and does not include all the duties of this position)

Special Working Conditions: Computer Associates (Software) may be required to work shifts including nights, Saturdays, Sundays, and holidays.

Preferred Skills:

- Experience with Microsoft Office including Word, Excel, Access, and various database management program skills

- A baccalaureate degree, from an accredited college, in computer science

- Automated Data Collection System database management

- PC (Personal Computer) hardware, internet interface hardware, and field data acquisition hardware knowledge

- Experience in building Dashboards and reports using applications such as Power BI.

- SQL (Structured Query Language) skills with experience working with large datasets to generate reports and dashboards

- Experience in application development, cloud architecture, Relational- NoSQL databases, analytics

- Experience with broad technology delivery, including custom development using various development languages such as Python, C#, Java

- Basic understanding of field data acquisition techniques, information transfer protocols, and field hardware.

- Analytical and problem-solving ability

- Organizational skills

- Communication Skills

Special Working Conditions: Computer Associates (Software) may be required to work shifts including nights, Saturdays, Sundays, and holidays

Hours and Shift:

35 Hours per week. May be required to work shifts including nights, Saturdays, Sundays, and holidays.

Work Location:

20 NYC Highway 30A

Downsville, NY 13755

Downsville is a hamlet in the Town of Colchester, Delaware County, New York approximately 135 miles northwest of New York City.

COMPUTER ASSOC (SOFTWARE) - 13631

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.

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.