Data Analyst/City Research Scientist
Job Description
THE SELECTED CANDIDATE WILL BE OFFERED A SALARY BETWEEN $87,743.00 - $100,904.00
The Administration for Children’s Services (ACS) protects and promotes the safety and well-being of children and families through child welfare and juvenile justice services and community supports. ACS manages community-based supports and foster care services and provides subsidized childcare vouchers. ACS child protection staff respond to allegations of child maltreatment. In juvenile justice, ACS oversees detention, placement and programs for youth in the community.
The ACS division of Policy, Planning and Measurement (PPM) collaborates with every ACS division to guide systems analysis and strategic systems improvement; assure quality of practice at ACS and its provider agencies; professionalize the frontline workforce; bring knowledge into practice; provide research and analytic support; and plan and develop new programs and policies.
The ChildStat Data Team (CSDU) within the Office of Research and Analytics (ORA) at ACS works closely with the Division of Child Protection (DCP) frontline management and central leadership. This unit supports the ChildStat model, a management accountability and quality improvement process that combines aggregate data analysis with case dialogue to drive positive outcomes for children and families. The CSDU has developed five advanced dashboards and a SharePoint portal to enhance transparency and accountability across divisions.
Reporting to the Executive Director, the Data Analyst will be responsible for:
- Top priority: Support the development of the Reporter Tool, integrating all city institutions and related addresses.
- Create an automated data-matching process through algorithmic and creative problem solving. This is currently being developed but will need more support.
- Maintenance of the Reporter Tool’s data store. Create an annual update method for institutional addresses.
- Development of the tool’s data visualizations through dashboards including user-friendly filtering of spatial and data analysis.
- Maintain weekly and monthly updates to the CSDU-R datastore, Sharepoint data portal.
- Develop weekly data analysis and ad-hoc reports for follow-up topics from ChildStat (deeper dive into trends and issues that surfaced during the Childstat sessions) e.g. new DHS shelter map identifying children with ACS involvement and living in shelters.
- Ongoing development, refinement, and standardization for the child protection performance indicators, including the maintenance of SQL scripts for data querying.
- Utilizing R, provide additional ad-hoc data requests and analysis for ACS central leadership, includes requests outside the ChildStat scope.
- Provide key insights and data patterns to inform DCP’s performance improvement plans for DCP COQI.
- Support the development and validation of child protection measures for Safe Measures Dashboard.
- Incorporate new databases to inform Child Protection performance indicators (ACS has several new databases that are not yet utilized to their full capacity to inform practice).
- Responsible for maintaining and validating the accuracy of data for assigned projects. If necessary, collaborate with IT/developer consultants related to UX/UI design.
- Participation in vetting processes for new data systems, platforms, and/or tool development.
- Drafting process briefs or summary write-ups.
- Building and analyzing dashboards and other interactive reports.
- Perform exploratory analysis: understanding workflow, and long-term data trends, identify new procedures to help create or track key metrics, respond to practice-related data requests, and evaluate policy decisions.