The Administration for Children’s Services (ACS) protects and promotes the safety and well-being of New York City’s children and families by providing child welfare, juvenile justice, and early care services. In child welfare, ACS contracts with private nonprofit organizations to support and stabilize families at risk of a crisis through preventive services and provides foster care services for children not able to safely remain at home.

The New York City Administration for Children’s Services of Office of Information Technology (OIT) Business Solutions department is responsible for the building the systems that provide operational, analytical and managerial support functions, as well as IT resource management, for the entire agency. Working closely with different business stakeholders within the agency, Business Solutions develops and implements both custom and packaged applications, and maintains the requisite technical infrastructure, using in-house project resources and hired consultants. We encourage innovation, creativity, and a think outside of the box attitude when solving complex problems and implementing new solutions.

The Office of Information Technology Business Solutions is recruiting for a position functioning as Team Lead Systems Developer who will perform the following duties, but not limited to:

- Lead the effort of complex application development according to requirements/specifications using primarily Dynamics and SQL Server and associated languages and tools in a variety of systems development life cycle (SDLC) methodologies, including Waterfall, Agile and Hybrid Agile.
- Design, develop, program and implement in assigned project utilizing MS Dynamics on cloud and/or on premises with SQL Server backend, .NET technologies and other related technologies.
- Design, develop, program and implement in assigned project utilizing ADX Studio/ADX Portals.
- Create packages, triggers and procedures, scheduling, tuning jobs and ETL process across multiple databases such as SQL Server, Oracle.
- Develop SQL Server Reporting Services reports.
- Utilize version control systems such as TFS.
- Create Technical Design Documents.
- Perform unit and integration testing.
- Interact with customers to comprehend product requirements.
- Explain technical concepts to users and help them understand the solutions implemented.
- Estimate timeframe to implement specifications.
- Work with the business analysts and team to program the specifications.
- Provide updates to Project Manager and supervisor.
- Participates in project meetings.
- Quick to learn, self-motivated, and enthusiastic; work well within a team environment and with minimal supervision.
- Comfortable working with defined project plans and contributing estimates to the planning process.
- Able to meet and deliver on deadlines and work well under pressure.
- Follow guidelines and standards as set forth by ACS and OIT.
- Supervise and mentor staff.
- Conduct performance evaluations and other supervisory duties.
- Design, develop, program and implement in assigned project utilizing Power Apps.
- Create, assist and enforce Standards and Best practices across multiple technological disciplines.
- Create training plans for staff.


ADDITIONAL INFORMATION:

THE SELECTED CANDIDATE WILL BE OFFERED A SALARY BETWEEN $110,000-$120,000.

Section 424-A of the New York Social Services Law requires an authorized agency to inquire whether a candidate for employment with child-caring responsibilities has been the subject of a child abuse and maltreatment report.

TO APPLY:

APPLICATIONS MUST BE SUBMITTED ELECTRONICALLY USING ONE OF THE OPTIONS BELOW:

For current city employees, go to Employee Self Service (ESS), Recruiting Activities, Careers and search for Job ID#608922.

For all other applicants go to www.nyc.gov/careers and search for Job ID#608922. Click on the "Apply" button.

If you do not have access to a computer, most public libraries have computers available for use.

Only candidates selected for an interview will be contacted.

1. A baccalaureate degree from an accredited college in computer science, engineering, human computer interaction, interactive media, digital and graphics design, data visualization, communication or a related field, and four years of satisfactory full-time experience related to the area(s) required by the particular position and a specialization in a relevant technology, process, methodology and/or domain; or

2. An associate degree from an accredited college in computer science, engineering, human computer interaction, interactive media, digital and graphics design, data visualization, communication or a related field, and six years of satisfactory full-time experience related to the area(s) required by the particular position and a specialization in a relevant technology, process, methodology and/or domain; or

3. A baccalaureate degree from an accredited college, and eight years of satisfactory full-time experience related to the area(s) required by the particular position and a specialization in a relevant technology, process, methodology and/or domain; or

4. Education and/or experience which is equivalent to "1", "2", or "3" above.

The preferred candidate should possess the following: - 8 years’ experience using database technologies such as SQL Server, CRM tools such as MS Dynamics, .NET and other technologies. - 3 years’ experience and very good working knowledge of MS Dynamics, Kingsway software, and related tools. - 2 years database development Experience using SQL 2012 and above - designing database tables, develop packages, functions, and stored procedures, database. - 2 years’ experience with SSRS and other related reporting tools. - 1-year experience with PowerApps. - 1-year experience ADX Studio/Portals. - Knowledge of Oracle 11g or above - designing complex packages, functions, and procedures, ETL process and developing Reports preferable. - Knowledge of BI Tool such as Tableau, Microsoft Power BI & BI Publisher - Knowledge of UNIX CRONTAB and/or Shell scripting / Power shell will have advantage. - Knowledge and programming experience in Oracle, PL/SQL - Experience with version control systems, preferably TFS. - Versed in different development methodologies. Ex. Iterative, Agile, Scrum etc. - Strong communication, analysis, and problem-solving skills. - Experience in creation of design documents. - Experience performing in lead role and mentored staff - Quick to learn, self-motivated, and enthusiastic work well within a team environment and with minimal supervision. - Comfortable working with defined project plans and contributing estimates to the planning process. - Able to meet and deliver on deadlines and work well under pressure. - Follow guidelines and standards as set forth by ACS and OIT.

As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at https://studentaid.gov/pslf/.

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.