Data Analyst

Children's Aid Society; New York (NY); On-site; USD 80,000 - 90,000; Full time

Job summary

Children's Aid Society is seeking a Data Analyst to support the Office of Performance Management. The role focuses on database creation, data management, reporting, and collaboration with diverse programs and central departments to drive data-driven outcomes for NYC children and families.

The analyst will develop dashboards, standardize data definitions, and help translate technical issues into insights for non-technical stakeholders.

Qualifications

• Bachelor of Arts or Sciences with emphasis on database design, development, and data management for social/health sciences; Master’s preferred.
• Minimum 3 years of demonstrated 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.

Responsibilities

• Create and 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 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 Data Governance Council.
• Develop and maintain Power BI dashboards and reporting tools to monitor KPIs and operational metrics.
• Support the creation of agency-wide performance dashboard by standardizing data definitions, reporting logic, and KPI structures across divisions.
• Collaborate with internal stakeholders and IT teams to connect and organize data from multiple program systems into centralized reporting structures.
• Document data flows, definitions, and reporting processes as part of data governance initiatives.
• Inventory and map organizational data systems to understand data collection, storage, and usage.
• Develop scalable data pipelines and reporting processes for centralized analytics.
• Perform other duties as assigned.

Skills

Excel

SQL

Relational databases

Power BI

Python

R

SPSS

SAS

Education

Bachelor's degree in data-related field

Master's degree preferred

Tools

SAP Business Objects

SAP Crystal Reports

IBM Cognos

Job description

Description

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

Position Summary

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 audience.

Essential Duties

• 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.

Minimum Qualifications

• 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.

Key Competencies

• 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.

It is the policy of Children's Aid to provide equal employment opportunity to all employees and applicants for employment and is dedicated to maintaining a work environment that is free from harassment and discrimination. Children's Aid will not tolerate discrimination, harassment, or retaliation on any basis, including race, creed, color, national origin, ethnicity, alienage or citizenship status, gender/sex (including pregnancy), disability, religion, source of income, sexual orientation, gender identity or expression, age, familial status, caregiver status, military status, marital or partnership status, status as a victim of domestic violence, sexual violence or stalking, predisposing genetic characteristics, arrest or conviction record, credit history, unemployment status or any other characteristic protected by federal, state or local law. Children's Aid is committed to complying with applicable state and local laws governing non-discrimination in employment. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

Children's Aid will conduct a prompt and thorough investigation of all allegations of discrimination, harassment, retaliation, or any violation of the Equal Employment Opportunity Policy in a confidential manner and will take appropriate corrective action, if and where warranted. Children's Aid prohibits retaliation against employees who provide information about, complain about, or assist in the investigation of any complaint of discrimination or violation of the Equal Employment Opportunity Policy.

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. The position's requirements are subject to periodic review and adjustment based on organizational needs and changes in work dynamics.

Qualifications

Behaviors

• Team Player - Works well as a member of a group
• Dedicated - Devoted to a task or purpose with loyalty or integrity

Motivations

• Ability to Make an Impact - Inspired to perform well by the ability to contribute to the success of a project or the organization
• Work-Life Balance - Inspired to perform well by having ample time to pursue work and interests outside of work

Education

• Bachelors (required)

Experience

• 1 - 2 years: Experience working with multiple data systems and integrating data for reporting or analytics purposes. (required)
• 2 years: Experience building or supporting dashboards using Power BI. (required)
• 3 years: Demonstrated, high level of expertise with Excel, SQL scripting, and relational databases. (required)

Skills

• Attention to Detail (preferred)

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.