Senior Data Analyst

Job Details: Level: Experienced, Job Location: 1 PIERREPONT PLAZA SUITE 901 - BROOKLYN, NY, Position Type: Full Time, Education Level: 4 Year Degree, Salary Range: $70000.00 - $70000.00Salary/year, Travel Percentage: Up to 25%, Job Shift: Day, Senior Data Analyst About Program Performance & Planning In full partnership with families and communities, 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. About the Position 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. Competencies and Strengths: 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. Qualifications: Qualifications: 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. Position Type Full-Time Salary/Compensation $70,000 Location This position will be primarily remote, with an expectation of regular in-person workdays at our office locations in Downtown Brooklyn, as well are regular visits at other Graham sites in Manhattan and the Bronx.