Client Data Analyst – Programs & Impact
ABOUT YWCA SKS: At YWCA Seattle | King | Snohomish, our mission is to eliminate racism, empower women, and ensure all people in our community have the opportunity to thrive. We believe that when barriers created by institutional and structural racism are removed, everyone benefits. Through more than 70 programs across King and Snohomish counties, we provide housing stability, economic advancement, and health and safety services to more than 7,000 individuals each year. We are committed to delivering client-centered services while using data to strengthen our programs, measure our impact, and continuously improve the communities we serve.
POSITION DESCRIPTION: 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.
Work Location: This is a largely hybrid position. Employees work primarily remotely, with periodic onsite work required for meetings, trainings, collaboration, and organizational needs. Candidates should be able to commute to our Seattle office when onsite attendance is required.
RESPONSIBILITIES: Client Data Review & Reporting (Primary Focus)
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
Data Systems Trainings & User Support
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
Data Quality & Compliance
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
Staff Support & Collaboration
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
Race and Social Justice:
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
QUALIFICATIONS: Experience
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.
Technical Skills
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.
PHYSICAL DEMANDS OF THIS POSITION: The physical demands described here are representative of those that must be met by an individual to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. In performing this position, the employee:
Continuously communicates and exchanges information with employees, leadership, community partners, vendors, and other stakeholders through verbal, written, and electronic communication.
Continuously uses a computer, keyboard, mouse, telephone, and other standard office equipment to prepare reports, analyze data, and perform daily work.
Frequently remains in a stationary position while working at a computer for extended periods.
Frequently moves throughout the office to attend meetings, trainings, and collaborate with coworkers.
Occasionally travels between YWCA locations or to community meetings and training sites.
Occasionally lifts and carries office materials, files, or equipment weighing up to 20 pounds.
Frequently uses visual acuity to review data, spreadsheets, reports, and electronic records.
Frequently performs repetitive hand and wrist movements associated with typing and computer use.
*Continuously = Over 80% of the time * Frequently = 20-80% * Occasionally = Under 20%
#LI-Hybrid
#YWCAWORKS ( for Indeed)