Senior Data Analyst (63869)

Paycom - ATS; Brooklyn (OH); Remote; USD 63,000 - 77,000; Full time

Job summary

Graham Windham seeks a Senior Data Analyst to build and maintain reports and dashboards supporting agency programs. The role collaborates with IT to ensure data availability in the warehouse, develops a robust enterprise data model, and maintains automated dashboards and ad hoc analyses for leadership decision making.

The ideal candidate will bring strong data analysis skills, curiosity, and a proactive approach to data accuracy.

Qualifications

• Bachelor's degree and minimum 3 years of experience in data analysis, BI, or a related technical role.
• Strong quantitative and analytical skills with ability to translate data into clear insights.
• Hands-on experience building dashboards and data models in Power BI, including DAX and Power Query.
• Experience with data modeling concepts (e.g., star schema) and enterprise data environments.
• Advanced Excel skills (pivot tables, lookups, Power Pivot).
• Strong SQL proficiency; ability to write complex queries.
• Familiarity with ETL/data pipeline concepts is a plus.

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 and data elements support accurate reporting.
• Conduct ad-hoc and recurring analyses using SQL, Power BI, Excel, and Power Query to answer business questions and evaluate program performance.
• Document data definitions, table structures, dashboard logic, and query methodology to support consistency and auditability.
• Translate stakeholder requests into technical requirements and present analytical findings clearly to technical and non-technical audiences.
• Coach and support program staff in interpreting dashboards and promoting data literacy across the organization.
• Other related duties as assigned.

Skills

Data analysis

Data visualization

Stakeholder comms

Collaboration

Problem solving

Education

Bachelor's degree

Tools

Power BI

SQL

Power Query

DAX

Power Pivot

Excel

Job description

Job Details

Job Details: Job Location: 1 PIERREPONT PLAZA SUITE 901 - BROOKLYN, NY 11201, Position Type: Full Time, Education Level: 4 Year Degree, Salary Range: $70,000.00 - $70,000.00 Salary/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 aSenior 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

• 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

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

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.

EEO Statement

The Equal Employment Opportunity Policy of Graham Windham (GW) is to provide a fair and equal employment opportunity for all associates and job applicants regardless of race, color, religion, national origin, gender, sexual orientation, age, marital status, or disability. GW hires and promotes individuals solely based on their qualifications for the job to be filled.