Assistant Staff Analyst, Health (N22)

Salary Range: $35.23-$50.83 per hour

SUMMARY

The Los Angeles County Department of Health Services (DHS) is the second largest municipal health system in the nation.

  DHS is an integrated health system, operating 26 health centers and four acute care hospitals, in addition to providing health care to youth in the juvenile justice system and inmates in the LA County jails.

 Across the network of DHS’ directly operated clinical sites and through partnerships with community-based clinics, DHS cares for about 800,000 unique patients each year, employs over 22,000 staff, and has an annual operating budget of 5 billion.

Housing for Health (HFH) is a program office within Health Services Administration, a division in the DHS.  HFH was created in 2013 to address the unique needs and challenges faced by vulnerable people experiencing homelessness to provide flexible funding to community-based organizations.  HFH’s Housing and Services team works in partnership with contracted agencies to permanently house people and provide non-time limited services in housing.  As such, HFH is a key player and supports many of the Los Angeles County Homeless Initiative recommendations in response to and in support of the County’s effort to address and combat homelessness in the communities residing within Los Angeles County.

“

The Assistant Staff Analyst in the Housing and Services unit has experience and knowledge in supportive housing, programs and services tailored to people experiencing homelessness, provides technical assistance/training, and is flexible and adaptable to changes that may be needed to meet the needs of people experiencing homelessness.

 This position is responsible for assisting in the planning, directing, implementing, and monitoring Countywide Intensive Case Management Services supportive housing projects and homeless initiatives for clients who have complex health and/or behavioral health conditions, high utilizers of public services, and other vulnerable populations.

The Assistant Staff Analyst will be assigned to the following areas within the Housing and Services Team: Performance Improvement.

ESSENTIAL FUNCTIONS

Essential Skills & Responsibilities:


* Data Analysis & Reporting: Collect, analyze, and interpret data to assess program performance, identify trends, and inform decision-making.


* ETL (Extract, Transform, Load) & Power Query: Extract data from various sources, clean and transform it, and load it into reporting systems for analysis.


* Report & Tracker Development: Design and maintain trackers, dashboards, and automated reports to monitor program performance and contracted agency outcomes.


* Excel Macros & Automation: Develop and utilize Excel macros, VBA scripts, and other automation tools to improve data processing efficiency.


* Quality Assurance & Performance Improvement: Support ongoing data validation, quality assurance, and process improvement efforts for program tracking and fisca...