Impact Data Analyst: Power BI & Dashboards

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

Job summary

Children’s Aid is seeking a data-driven professional to support the Office of Performance Management by building and analyzing data systems that power operational and performance reporting.

The role focuses on designing data collection, managing dashboards, and enabling staff and leadership to act on insights. You will collaborate across departments, ensure data governance, and contribute to scalable analytics in a hybrid New York work environment.

Qualifications

• Bachelor-level degree in data management, analytics, or a related field.
• 3+ years of Excel, SQL, and relational databases.
• 2+ years building Power BI dashboards.
• 1+ years integrating data from multiple systems.
• Experience documenting data processes and reporting methodologies.

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

Skills

Data analysis

Attention to Detail

Team collaboration

Communication

Education

Bachelor's degree in data management or analytics

Master’s preferred

Tools

Excel

SQL scripting

Relational databases

Power BI

SAP Business Objects

SAP Crystal Reports

IBM Cognos

SPSS

SAS

R

Python

Microsoft 365

Copilot

Job description

Children’s Aid is seeking a data-driven professional to support the Office of Performance Management by building and analyzing data systems that power operational and performance reporting.

The role focuses on designing data collection, managing dashboards, and enabling staff and leadership to act on insights. You will collaborate across departments, ensure data governance, and contribute to scalable analytics in a hybrid New York work environment.