Senior Data Analyst, OGC

Position Summary

The Senior Data Analyst position has emerged in response to a federal mandate by the United States District Court Southern District of New York (SDNY) to help address systemic data architecture issues in New York City Public Schools (NYCPS). The analyst will work closely with the Director of Systems and Analytics, Senior Systems Implementation Analyst, and Software Database Architect to unshackle the agency from restrictive data siloes and grow responsive data ecosystems in their places.

Together they will develop and leverage key stakeholder relationships to identify and build technical solutions to address systemic challenges related to leveraging analytics. The Analyst’s contributions will be vital in cultivating Office of Systems and Analytics (OSA)’s office culture that prioritizes kindness, excellence, transparency, and civic responsibility.

The role involves the application of advanced analytical and problem-solving skills to gather, analyze, interpret, and visualize data to inform legal strategies, policy formulation, and decision-making processes. The analyst will help lead the charge in deploying next-generation technology within the NYCPS, including Microsoft Azure, Power Platform, AI LLM software, and more, alongside tried-and-true data tools like SQL, R, SPSS, STATA, Python, and Microsoft 365.

The Analyst will conduct research on all existing systems, identify and recommend critical indicators for regular reporting to Office of the General Counsel (OGC) leadership, and build the necessary tools for extracting, organizing, analyzing, and visualizing such data. These analytics will be incorporated into OGC leadership’s regular planning processes and the analyst will maintain a key role in training OGC stakeholders in the interpretation and use of data assets.

The Senior Data Analyst is a high-impact role in the newly formed OSA to build responsive government in New York City.

The Challenge:

Public reporting shows that the NYCPS OGC is facing a ballooning number of annual special education cases. OGC faces significant challenges in using its many disparate and often antiquated case management systems to extract critical intel and develop key performance indicators for staffing, case triage, litigation approach, fraud-tracking and prevention, settlement opportunities, and policy making. Developing these metrics is essential for OGC to shape a successful case management and resolution strategy in NYCPS’s ever-changing environment.

The Mission:

The Office of Systems and Analytics’ unique mission is to reimagine the ineffective systems & protocols that disproportionately impact marginalized communities and impede the larger OGC in its mission to provide ethical legal counsel & representation and create safe & inclusive learning environments. Our goal is to empower OGC with modern analytics, business intelligence, and a robust data culture to create a vibrant community of well-trained, technically competent, inclusive, collaborative, and focused legal professionals.

Performs related work.

Reports to: Director of Systems & Analytics

Direct Reports: N/A

Key Relationships: Various NYCPS instructional program staff, leadership, and senior staff in Offices of the General Counsel, Special Education, Division of Instructional and Information Technology, external partners, NYCPS stakeholders, and City and State officials, and others as needed.

Data Management and Analysis

• Support the implementation of OGC data architecture and communication tools.
• Support the life cycle management of data analytics functions, including data quality reconciliation and report generation for OGC-related systems.
• Participate in data collection, analysis, and methodology decisions for OGC-related systems.
• Assist in building and maintaining user input systems in Microsoft Power Apps and data architecture for Microsoft Power BI.
• Ensure data integrity through careful handling of data imports/exports, storage, manipulation, analysis, and security for OGC-related data.
• Contribute to developing input systems for NYCPS attorneys and monitoring data from various OGC-related sources.
• Aid in designing and…