Client Data Analyst – Programs & Impact

About YWCA Seattle | King | Snohomish

YWCA Seattle | King | Snohomish aims to eradicate racism, empower women, and create opportunities for all community members to succeed. By dismantling institutional and systemic racial barriers, the organization benefits the entire community. Operating over 70 programs across King and Snohomish counties, it supports more than 7,000 people annually with housing stability, economic empowerment, and health and safety services. A strong focus on client-centered service delivery and data-driven program enhancement drives the organization.

Position Overview

This role leverages data to reveal impactful stories surrounding clients and programs. The Client Data Analyst transforms intricate program and client data into insights that assist key leaders in decision-making. Collaborating with program heads, finance, and executive teams, this position develops dashboards, enhances reporting, detects trends, and improves data quality for a wide array of programs.

The role is predominantly remote with some onsite commitments at the Seattle office for meetings and collaborative events.

Responsibilities

• Analyze client data including demographics, services, and outcomes to support program goals and strategic projects.
• Develop and sustain comprehensive reports, interactive dashboards, and data visualizations via Excel, SQL, and R.
• Automate routine internal and funder reporting processes.
• Interpret data for non-technical audiences to ensure clear, actionable insights.
• Clean and reshape data using SQL and R to enhance accuracy and accessibility.
• Create, optimize, and maintain SQL queries for data extraction and reporting.
• Document data definitions, workflows, and reporting standards thoroughly.
• Co-administer data systems such as ClientTrack and HMIS, acting as secondary HMIS lead and liaison for Coordinated Entry.
• Design and conduct user training sessions for client data systems and provide ongoing technical user support.
• Communicate complex data and system concepts clearly to staff and troubleshoot data system issues, coordinating with vendors when necessary.
• Lead data quality assurance efforts and recommend improvements to data infrastructure and systems.
• Ensure compliance with all data reporting standards including federal, state, local, and HUD requirements.
• Partner with diverse teams across the organization to refine data processes and foster data-driven decision-making.
• Emphasize social justice by recognizing and addressing systemic inequities in data analysis and organizational policies.

Qualifications

• Bachelor's degree in a related field or equivalent education and professional experience.
• 1-3 years experience in data analysis, reporting, or program support.
• Advanced proficiency in Microsoft Excel with strong data handling ability.
• Strong analytical skills to identify trends and communicate complex findings simply and accurately.
• Detail-oriented with a commitment to high-quality and precise outputs.
• Excellent organizational, communication, and customer service capabilities.
• Adaptability to learn new software and manage shifting priorities effectively.
• Ability to work independently but also collaborate well across teams.
• Experience with SQL, data reporting tools, or visualization software is essential.
• Knowledge of client databases such as HMIS or ClientTrack preferred.
• Familiarity with nonprofit, healthcare, housing, public sector, or human services environments beneficial.

Physical Demands

• Regular communication with various stakeholders using verbal, written, and electronic methods.
• Extensive use of computers and office equipment for report generation and data analysis.
• Prolonged periods working at a computer in a stationary position.
• Frequent movement within office settings for collaborative engagements.
• Occasional travel to multiple YWCA locations or community sites.
• Periodic lifting of items up to 20 pounds.
• Frequent visual focus on electronic data and reports.
• Repetitive hand and wrist movements due to computer work.

Compensation and Benefits

• Starting hourly wage: $32
• Full-time role with a 40-hour workweek
• This is a non-exempt position under FLSA
• Comprehensive benefits including healthcare, retirement plans, and paid leave for vacations, holidays, and sick days
• Eligibility for YWCA Retirement Fund participation subject to hours worked and plan rules, with credit for prior YWCA service within 2 years of rehire