Client Data Analyst – Programs & Impact

YWCA Seattle King Snohomish • Seattle, WA

3d • Hybrid

About The Position

Every number tells a story. At YWCA Seattle | King | Snohomish, data isn't collected simply for reporting. It helps us understand whether families are finding stable housing, individuals are securing employment, survivors are receiving critical services, and where inequities continue to exist in our community. As our Data Analyst – Programs & Impact, you'll transform complex client and program data into meaningful insights that help shape decisions across the organization. You'll partner with program leaders, finance, and executive leadership to build dashboards, improve reporting, identify trends, and strengthen data quality across more than 70 programs serving thousands of community members each year. If you enjoy solving problems, building reports that people actually use, and helping mission-driven organizations make smarter decisions, we'd love to meet you.

Requirements

• Bachelor's degree in a related field or an equivalent combination of education and experience.
• One to three years of experience working with data, reporting, program support, or a related field.
• Strong Microsoft Excel skills and comfort working with data.
• Ability to analyze information, identify trends, and communicate findings clearly.
• Strong attention to detail and commitment to producing accurate work.
• Excellent organizational, communication, and customer service skills.
• Ability to learn new software systems and adapt to changing priorities.
• Ability to work independently while collaborating effectively with a variety of teams.
• Experience using SQL, reporting tools, or data visualization software.
• Familiarity with client databases or case management systems such as HMIS or ClientTrack.
• Experience working in a nonprofit, healthcare, housing, public sector, or human services environment.

Nice To Haves

• Candidates should be able to commute to our Seattle office when onsite attendance is required.

Responsibilities

• Analyze and compile client data (demographics, services, outcomes) to support programs and strategic initiatives
• Build and maintain reports, dashboards, and visualizations using Excel, SQL, R, and reporting tools
• Create and automate recurring reports for internal teams and funders
• Translate data into clear, actionable insights for non-technical audiences
• Clean and transform data into SQL and R to improve data accessibility and accuracy
• Design, implement, maintain, and optimize SQL queries for reporting and data extraction
• Create and maintain documentation for data definitions, processes, and reporting standards
• Support and co-administer multiple data systems such as ClientTrack and HMIS
• Serve as secondary HMIS agency lead and Coordinated Entry liaison
• Conduct and develop trainings for client data system users
• Provide ongoing technical support and customer service to data system users
• Interpret and translate complex data or system requirements into practical guidance for staff
• Troubleshoot system issues and coordinate with vendors when needed
• Help to identify and resolve data system issues, conduct data quality assurance testing, analyze and evaluate systems, and identify and recommend potential system improvements
• Provide support with data system infrastructure improvements, customizations, and documentation
• Monitor data for accuracy, completeness, and consistency
• Develop and maintain data quality checks and validation processes
• Ensure compliance with federal, state, and local reporting requirements (including HUD standards)
• Support annual reporting cycles and new data initiatives
• Partner with program directors, managers, frontline staff, and leadership to understand data needs and improve reporting processes
• Provide guidance and support on tools like Excel, SQL, R, and reporting systems
• Help teams use data to inform decisions and improve service delivery
• Communicate findings clearly in both written and verbal formats
• Commitment to diversity, including sensitivity to the needs of residents and staff from diverse cultural and economic backgrounds.
• Participate and provide support in various ways for the agency’s Social Justice Initiative
• Support the YWCA’s Social Justice Initiative by understanding how racism, sexism, classism, and other oppressions play out in institutions and systems
• Use the lens of social justice to review policies and procedures

Benefits

• medical insurance
• retirement plan
• generous vacation, holiday, and sick leave plans
• Employees may become eligible to participate in the YWCA Retirement Fund after meeting hours-worked requirements, which may include completing at least 1,000 hours in a 12-month period or over two years, depending on plan provisions. Prior YWCA service may count toward eligibility if reemployment occurs within two years

What This Job Offers

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