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 Program Management Office (PMO) within BEDC provides technical support to the project delivery teams. This includes the following sections and groups: Project Controls, Schedule Controls, Permitting Support, Cost Estimating, Business Solutions, Data Analytics, and management of the Enterprise Program Management Information System (ePMIS). The PMO uses people, processes, and tools to mitigate issues that may impact a project. BEDC seeks to hire a Computer Associate (Software) 3 for the Program Management Office (PMO) located in the Lefrak Office in Queens, NY. Under direction of the PMO Business Solutions Manager, and with some latitude for independent initiative and judgement, the selected candidate will serve as a Business Analyst for the Bureau of Water & Sewer Operations (BWSO). The selected candidate will need to be skilled in application development to support best in class management of BWSO’s capital program, primarily the Lead Service Line Replacement Program. The Business Analyst will manage data captured on the huge variety of elements in project delivery to support Project Teams and all levels of Management. The Business Analyst will also maintain and develop tools within existing DEP-used technology, such as eBuilder and SQL, to capture, manipulate, or output engineering project management data. Typical tasks will include: - Address system users support requests - Interface with technology providers personnel to address problems - Support ongoing maintenance of reporting and data solutions - Analyze business requirements into technical requirements for reporting/visualizations, data models, and databases. - Review technical specifications derived from technical requirements - Participate in the design, performance, and code review process - 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. **** 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 - 1 – 5 years of experience in Business Analytics - 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 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.