Senior Data Analyst

Graham Windham • New York, NY

13d • $70,000 - $70,000 • Hybrid

About The Position

Graham Windham strives to make a life-altering difference with children, youth and families who are overcoming some of life’s most difficult challenges and obstacles, by helping to build a strong foundation for life: a safe, loving, permanent family and the opportunity and preparation to thrive in school and in the world. The Program Performance and Planning (PPP) group advances a culture of learning, strategic program development, and data-driven performance management in pursuit of that mission and vision. PPP partners with program managers to select and develop new interventions, analyze and interpret data, assess model fidelity and program effectiveness, apply learning from data analysis and feedback into program improvement efforts, and develop program resources to strengthen operations and service delivery. The PPP seeks a Senior Data Analyst to build and maintain reports and dashboards that support all of Graham’s work. This will entail close collaboration with our IT department, specifically a data engineer, to ensure that we have all necessary data in our data warehouse, develop and maintain a robust enterprise-level data model, produce and maintain automated reports and dashboards, run ad hoc queries and analyses, and maintain the library of data assets that are used by leadership across the agency. This position will also support the development and use of tools in Microsoft Excel, Forms, PowerApps, and more to ensure teams have strong data collection and management practices. This position will work deeply with data from all units across Graham including foster care, preventive services, mental health, care coordination, youth coaching, and community centers. This position will interface with the rest of the PPP team who collaborate with leadership and staff to generate insight from the data and develop plans for achieving excellence in operations and outcomes. The ideal candidate will have strong data analysis skills, be curious and inquisitive, and think creatively about how to ensure our data is complete and accurate. This person will be interested in exploring how artificial intelligence (AI) tools can be useful in supporting the data work of Graham, in line with our strong privacy and confidentiality practices.

Requirements

• Bachelor's degree and a minimum of 3 years of relevant experience in data analysis, business intelligence, or a related technical role.
• Strong quantitative and analytical skills, with the ability to interpret data from diverse sources and translate it into clear, actionable insights.
• Hands-on experience building and maintaining dashboards and data models in Power BI, including DAX and Power Query.
• Experience with data modeling concepts (e.g., star schema, normalization) and working within an enterprise data environment.
• Advanced Microsoft Excel skills (e.g., pivot tables, lookups, Power Pivot).
• Strong proficiency in SQL, including experience writing complex queries, joins, subqueries is a plus
• Familiarity with ETL/data pipeline concepts and tools is a plus.
• Strong communication skills, with the ability to present technical findings to non-technical stakeholders.
• Dedication to the organization's mission and a belief that children and families can succeed regardless of their circumstances.

Nice To Haves

• Experience with nonprofit or human-service organizations a plus.
• Willingness to travel throughout NYC, as needed.

Responsibilities

• Design, build, and maintain Power BI dashboards and reports, including data modeling, DAX calculations, and query optimization within Power Query (M).
• Own and manage the Power BI workspace structure, including workspace organization, dataset/dataflow management, row-level security, version control, and refresh scheduling.
• Partner with IT/database colleagues on the design and evolution of the enterprise data model, ensuring source tables, relationships, and data elements support accurate and scalable reporting.
• Conduct ad-hoc and recurring analyses using SQL, Power BI, Excel, and Power Query to answer business questions, evaluate program performance, and support decision-making.
• Document data definitions, table structures, dashboard logic, and query/report methodology to support consistency, auditability, and knowledge transfer.
• Translate stakeholder requests into technical requirements, and communicate analytical findings clearly to both technical and non-technical audiences, including through presentations and facilitated discussions.
• Coach and support program staff in interpreting dashboards and data, promoting broader data literacy across the organization.
• Other related duties as assigned.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior