Job Description PLEASE NOTE THAT WE ARE ONLY SEEKING INTERNAL CITY EMPLOYEES FOR THIS POSITION. 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 storm water, 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 Engineering Design & Construction (BEDC) currently has a portfolio of capital projects valued at $23.8B, and another $10.5B projected over the next 10-year commitment plan. The projects BEDC implements allows DEP as a whole to continue to operate and maintain an exemplary water supply system. The Human Resources & Support (HR&S) division consists of two sections composed of Personnel Services and Administrative Support. Each section is responsible for promoting professional development and providing exceptional administrative customer services to BEDC employees. BEDC seeks to hire a Computer Associate (Software) 2 for the Human Resources & Support (HR&S) directorate, located at our headquarters in Queens, NY. Under general supervision of the HR Director, and with considerable latitude for independent initiative and judgement, the selected candidate will serve as an HR Data Systems Analyst. The selected candidate will manage the HR system. They will provide technical support to the HR&S team on the design, development, implementation, troubleshooting, enhancement, maintenance, and security of our Web and database management systems. Additionally, the selected candidate will assist the Program Management Office (PMO) within BEDC with any special projects as assigned, to support project delivery teams. The selected candidate will need to be skilled in application development to support best in class management of BEDC’s capital projects. They will manage data captured and maintain tools within existing DEP-used technology, such as eBuilder, ASP.NET MVC, Power BI and SQL, to capture, manipulate, or report on project management data. Typical tasks will include: - Address system users support requests - Interface with technology providers personnel to address problems - Participate in ongoing maintenance and support for multiple systems. - Analyze business requirements into technical requirements for reporting/visualizations, data models, and databases. - Collaborate with cross-functional teams to understand project requirements and translate them into technical specifications. - Oversee development and maintenance of the department's data repository and ensure successful data gathering and validating the accuracy of the data prior to publication of reports - Develop IT-based solutions consisting of contextual, conceptual, and logical architectures using standards-based, rigorous methodologies and best practices. - Install and update software applications and operating systems - Collaborate with HR&S and IT staff/departments to implement new technology solutions and upgrades - Design, develop, and implement software solutions using C# and the .NET framework. - Write clean, efficient, and maintainable code following industry best practices. - Conduct thorough testing and debugging if applications to ensure smooth functionality. - Participate in code reviews to ensure code quality and adherence to coding standards. - Ability to adapt to new technologies and being able to set and follow development standards. - Troubleshoot and resolve technical problems in a timely manner. **** Only those applicants with permanent Civil Service status as a Computer Associate (Software) are eligible to apply to this JVN. If you do not have permanent civil service status as a Computer Associate (Software), please do not apply to this position as you will not be considered for an interview.**** PREFERRED SKILLS - Strong organization, writing, communication skills, with a strong vision of the goals - Experience gathering requirement from project teams and management for their needs - Experience in build Dashboards and reports using SSRS and Power BI. - Strong SQL skills with experience working with large datasets to generate reports and dashboards - Broad technology experience in application development, cloud architecture, Relational/NoSQL databases, analytics, machine learning, DevOps, management, and monitoring - Experience with broad technology delivery, including custom development using various development languages such as C#, Java - Hands-on experience with .NET Technologies. - Experience working with Microsoft SQL Server, creating data definitions and SSIS packages. - Web application is preferred. - Experience with Microsoft Visual Studio, Microsoft SQL Management Studio, Microsoft Reporting Services, Development of complex ETL data transformations using SSIS and stored procedure is a plus. - Experience in Agile Scrum and Waterfall Software Development Lifecycle Additional Information: **** Only those applicants with permanent Civil Service status as a Computer Associate (Software) are eligible to apply to this JVN. If you do not have permanent civil service status as a Computer Associate (Software), please do not apply to this position as you will not be considered for an interview.**** DEP is an equal opportunity employer with a strong commitment to the diversity of our organization and workforce. Your voluntary response to the NYCAPS on-line application section for referral information will assist us tremendously in our ability to track the success of our outreach and recruitment efforts. Please be sure to indicate your source of referral to this job. All appointments are subject to Office of Management and Budget (OMB) approval. To Apply: To apply click "Apply Now" 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. 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.