Data Analyst

Support the Office of Performance Management by building and analyzing data systems that power operational and performance reporting.

Responsibilities

• Create and strengthen data collection, management, reporting, and analysis systems, including documenting procedures.
• Build databases that aggregate data from multiple sources to track process and outcome measures.
• Produce recurring and ad hoc operational and performance indicator reports for staff, the Board, and external audiences.
• Analyze actual performance versus projected performance and review trends within and across programs on a regular basis.
• Collaborate with Performance Management staff to implement components of a comprehensive performance management system.
• Help staff access and analyze data to inform strategic and programmatic decisions.
• Manage data exchange under data-sharing agreements while observing confidentiality and use requirements.
• Train staff on data collection, entry, management, and analysis.
• Participate in Children’s Aid Data Governance Council.
• Develop and maintain Power BI dashboards and reporting tools for KPIs and operational metrics monitoring.
• Support creation of an agency-wide performance dashboard by standardizing data definitions, reporting logic, and KPI structures across divisions.
• Work with internal stakeholders and IT teams to connect and organize data from multiple program systems into centralized reporting structures.
• Document data flows, data definitions, and reporting processes as part of data governance and data strategy initiatives.
• Contribute to efforts to inventory and map organizational data systems, clarifying how data is collected, stored, and used across the agency.
• Support scalable data pipelines and centralized analytics reporting processes that integrate data from multiple sources.
• Perform other duties as assigned.

Requirements

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

Technologies

• Excel
• SQL scripting
• Relational databases
• Power BI
• SAP Business Objects
• SAP Crystal Reports
• IBM COGNOS
• SPSS
• SAS
• R
• Python
• Microsoft 365
• Copilot

Preferred Competencies & Skills

• Experience using third-party business intelligence or report writing tools (examples include SAP Business Objects, SAP Crystal Reports, IBM COGNOS).
• Knowledge of statistics and statistical software (examples include SPSS, SAS).
• Programming language experience for data analysis and automation (preferred: R, Python).
• Experience with outcomes reporting in a non-profit, education, or healthcare setting.
• Experience with Microsoft 365 applications, including Copilot.
• Customer service orientation and ability to collaborate; ability to understand data needs across different audiences.
• Ability to create and maintain strong interdepartmental relationships to advance mission and outcomes.
• Ability to work independently and as part of a team.
• Ability to multi-task, prioritize, meet deadlines, and problem-solve.
• Comfort with hands-on work as well as support for strategic projects.
• Results-oriented mindset and commitment to operational excellence.
• Attention to Detail (preferred).

Work Style (Preferred)

• Team Player: works well as a member of a group.
• Dedicated: devoted to a task or purpose with loyalty or integrity.

Motivations (Preferred)

• Ability to Make an Impact: motivated by contributing to project or organizational success.
• Work-Life Balance: motivated by having ample time to pursue work and interests outside of work.

Location & Schedule

• Location: New York, NY (hybrid).
• Schedule: Expected to work in-person or hybrid schedule as determined by department needs to support effective collaboration.
• Review cadence: Requirements subject to periodic review and adjustment based on organizational needs and changes in work dynamics.

Compensation

• Salary: USD 80,000 - 90,000 per yearly.

Minimum Experience & Education

• Experience: 1 - 2 years integrating multiple data systems for reporting or analytics; 2 years Power BI dashboard experience; 3 years high level expertise with Excel, SQL scripting, and relational databases.
• Education: Bachelor’s or better.