Data Analyst

Compensation: $80,000/year - $90,000/year

About the role

At Children’s Aid, we believe that all kids have limitless potential. Our dedicated staff provides comprehensive support for nearly 50,000 children and families in targeted, under-resourced New York City neighborhoods. We know what it takes to ensure children grow up strong, healthy, and ready to thrive in school and life: excellent education and health care, social-emotional support, and strong, stable families. The mission of the Office of Performance Management is to create sustainable data-driven operations in programmatic and central divisions to increase effectiveness and achieve mission-driven outcomes for children.

The Data Analyst contributes to this mission through database creation, management, analysis, reporting, and collaboration with a diverse array of programs and central departments. The Data Analyst possesses superior data management and analytic skills, as well as a proven ability to communicate in writing and verbally with a wide range of stakeholders to foster accountability and learning, including effectively translating technical issues and concepts into accessible insights for non-technical audiences.

Responsibilities

• Create and/or strengthen systems for data collection, management, reporting, and analysis including documenting all procedures.
• Create databases to aggregate data from multiple sources to track process and outcome measures.
• Create and produce recurring and ad hoc reports of operational and performance indicators for all levels of staff, Board, and external audiences.
• Analyze actual performance against projected performance as well as trends within and across programs on a regular basis.
• Collaborate with Performance Management staff in working directly with programs and departments to implement all components of a comprehensive performance management system.
• Assist staff with accessing and analyzing data to inform them of strategic and programmatic decisions.
• Manage the exchange of data pursuant to data-sharing agreements, observing all confidentiality and use requirements.
• Train staff on data collection, entry, management, and analysis.
• Participate in Children’s Aid’s Data Governance Council.
• Develop and maintain Power BI dashboards and reporting tools that help program teams and leadership monitor key performance indicators and operational metrics.
• Support the creation of agency-wide performance dashboard by helping to standardize data definitions, reporting logic, and KPI structures across multiple divisions.
• Collaborate with internal stakeholders and IT teams to connect and organize data from multiple program systems into centralized reporting structures.
• Assist with documenting data flows, data definitions, and reporting processes as part of broader organizational data governance and data strategy initiatives.
• Contribute to efforts to inventory and map organizational data systems to better understand how data is collected, stored, and used across the agency.
• Support the development of scalable data pipelines and reporting processes that allow data from multiple sources to be integrated into centralized analytics.
• Perform other duties as assigned.

Requirements

• A Bachelor of Arts or Sciences with an emphasis on database design, development, and data management for the social or health sciences; a Master’s preferred.
• Minimum 3 years of demonstrated, high level of expertise with Excel, SQL scripting, and relational databases.
• 2+ years of experience building or supporting dashboards using Power BI.
• 1+ years of experience working with multiple data systems and integrating data for reporting or analytics purposes.
• Experience documenting data processes, definitions, or reporting methodologies.

Skills

• Experience using various third-party business intelligence or report writing tools (e.g., SAP Business Objects, SAP Crystal Reports, IBM COGNOS, etc.).
• Knowledge of statistics and statistical software (e.g., SPSS, SAS).
• Experience with programming languages used for data analysis and automation (e.g., R, Python) preferred.
• Experience conducting outcomes reporting in a non-profit, education setting, or healthcare setting.
• Experience with Microsoft 365 applications, including Copilot.
• Customer service orientation; ability to work collaboratively; ability to understand data needs from the perspectives of various audiences.
• Ability to create and maintain strong interdepartmental relationships to advance the mission of the organization and ensure positive outcomes.
• Ability to work independently and as part of a team.
• Ability to multi-task, prioritize, meet deadlines, and problem-solve.
• Comfort performing hands-on work as well as assisting in strategic projects.
• Results-oriented perspective and commitment to operational excellence.

Schedule

The incumbent is expected to work a schedule, whether in-person or hybrid, as determined by the department's needs to facilitate effective collaboration with the team. This flexibility is essential for maintaining seamless communication, fostering teamwork, and ensuring the smooth operation of the department's processes.