Senior Data Analyst (63580) at Graham Windham in 1 PIERREPONT PLAZA SUITE 901 - BROOKLYN, NY 11201

Job description

• Salary Range
• Senior Data Analyst
• 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.

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.

Requirements

• In keeping with the Graham Pillars of Respect, Grow, Thrive, and Lead and the requirements of the position, the following competencies and strengths are important attributes for being successful in this role:
• Detailed & Organized: Extremely detail-oriented, with excellent written and oral skills.
• Supportive and Learning Oriented Coach: Has an aptitude for coaching others and an orientation toward using data and information to support a culture of learning and improvement
• Curious: Interested in understanding why things are the way they are and persistent about figuring things out.
• Engaged: Communicates openly, honestly and clearly and is willing to have healthy disagreement, with the goal of building a more connected community.
• Solution-focused and Dependable: Works with others to solve problems, acknowledges mistakes and successes, and follows through on commitments.
• Growth-oriented: Openness to feedback and self-reflection towards self-improvement.
• Respectful: Has strong personal integrity and wants to participate in a culture that celebrates vibrant and diverse spiritual and ideological perspectives, racial, ethnic, and gender identities, and sexual orientations.
• Bold and Passionate: Enjoys empowering staff to help them achieve safety, family, education, and opportunity for the kids and families we serve.
• 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.
• Experience with nonprofit or human-service organizations a plus.
• Willingness to travel throughout NYC, as needed.

Skills

Required

• Strong communication skills
• Dedication to the organization's mission

Benefits

• Level
• $70,000