Data Analyst Jobs

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. Each year, the agency’s Division of Child Protection responds to more than 50,000 reports of suspected child abuse or neglect. In juvenile justice, ACS manages and funds services including detention and placement, intensive community-based alternatives for youth, and support services for families. ACS is also a key part of NYCs early childhood and education continuum, providing childcare assistance to thousands of child welfare involved and low-income children so they can access safe, affordable, quality care.
The Office of Research and Analytics (ORA), within the ACS Division of Policy, Planning and Measurement, conducts routine and ad-hoc data analysis and reporting, to support and evaluate system improvement efforts, conduct quality assurance, monitor contractors and meet reporting mandates. ORA is seeking applicants for a data analyst who will develop reports and conduct data analysis in support of services provided by the ACS Division of Child and Family Well-Being (CFWB). CFWB coordinates and funds childcare vouchers and oversees the expansion of ACS’ Family Enrichment Center contracts, which are a primary prevention approach to increasing family stability/well-being and promoting “protective factors”, like social connectivity, that help families build the resiliency and supports they need during hard times.
Responsibilities of this position include:

• Design SQL/R queries to directly query and analyze internal and external data sources. Provide timely, valuable solutions for ad hoc analyses via SQL/R with a focus to detail on crafting scripts that can be easily manipulated and automated to efficiently address similar future analyses.
• Draft/edit comprehensive reports in statistical and narrative forms in order to provide a written summary of results and recommendations.
• Perform extensive data validation/quality assurance analysis within large datasets, filter and clean data, troubleshoot and resolve data issues. Analyze data results and identify patterns and trends in data sets.
• Manage and respond to inquiries and provide technical assistance to internal colleagues regarding data requests. Participate in ongoing dialogues with data scientists, IT, and management in order to stay on track and identify any opportunities or room for development.

1. For Assignment Level I (only physical, biological and environmental sciences and public health) A master's degree from an accredited college or university with a specialization in an appropriate field of physical, biological or environmental science or in public health.
To be appointed to Assignment Level II and above, candidates must have:
1. A doctorate degree from an accredited college or university with specialization in an appropriate field of physical, biological, environmental or social science and one year of full-time experience in a responsible supervisory, administrative or research capacity in the appropriate field of specialization; or
2. A master's degree from an accredited college or university with specialization in an appropriate field of physical, biological, environmental or social science and three years of responsible full-time research experience in the appropriate field of specialization; or
3. Education and/or experience which is equivalent to "1" or "2" above. However, all candidates must have at least a master's degree in an appropriate field of specialization and at least two years of experience described in "2" above. Two years as a City Research Scientist Level I can be substituted for the experience required in "1" and "2" above.
NOTE:
Probationary Period
Appointments to this position are subject to a minimum probationary period of one year.

The preferred candidate should possess extensive experience working with large administrative databases including queering database, data cleaning and data manipulations, data matching, statistical analysis and reporting.

• Familiarity with NYS child welfare and/or benefits administration systems of record is strongly preferred but not required.
• Experience with Tableau and data visualization software is a plus.
• Strong programming skills using SQL is required (programing experience in R is a plus).
• Strong communication skills with ability to build good relationships with colleagues and stakeholders and explain complex topics in simple terms.

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.

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# 569473.
For all other applicants go to www.nyc.gov/careers and search for Job ID# 569473. 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.

New York City residency is generally required within 90 days of appointment. However, City Employees in certain titles who have worked for the City for 2 continuous years may also be eligible to reside in Nassau, Suffolk, Putnam, Westchester, Rockland, or Orange County. To determine if the residency requirement applies to you, please discuss with the agency representative at the time of interview.