Senior Data Analyst (63580)

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.