Housing for Health (HFH) program office within Community Programs, a division under the Los Angeles County Department of Health Services (DHS) is looking to support people experiencing homelessness with complex clinical needs by building a scalable data environment to track performance, evaluate, and provide policy guidance.
Requirements
- Experience building data transformations and models in Databricks or Spark-based environments.
- Strong knowledge of Medallion Architecture and curated model development (e.g. data normalization as well as dimensional modeling with star/snowflake schemas)
- Skilled in working with normalized datasets and applying entity resolution techniques to build clean, reliable analytic tables joined across systems (e.g., MDM-linked client records).
- Familiarity with data quality best practices and methods for identifying contaminations in data pipelines.
- Experience performing root cause analysis to determine sources of pipeline failures.
- Experience using declarative syntax to manage and implement data transformations in such tools as Delta Live Tables, dbt, and Spark.
- Proficient in SQL, Python, GitHub, and CI/CD workflows.
Responsibilities
- Build and maintain semantic data models (silver and gold layers) in Spark/Databricks, primarily through ELT/ETL pipelines written in PySpark.
- Understand and identify entity relationships among large collections of normalized backend tables to design accurate, denormalized, analyst-ready structures.
- Contribute to schema and catalog design decisions, including naming conventions for static vs. live feeds and ad hoc data use cases.
- Collaborate with program and analytic teams to understand and translate both business rules used to define data fields as well as needs of analytic teams using semantic layer to produce reports and dashboards.
- Collaborate with the Privacy Engineer to ensure analytic datasets align with RBAC policies, de-identification requirements, and data classification standards set for Departmental and Countywide use.
- Contribute to, update, and maintain centralized code repositories used for data transformations.
- Participate in Dev/Prod promotion workflows using GitHub, ensuring proper validation and configuration for CI/CD deployment.
Other
- A valid California Class C Driver License or the ability to utilize an alternative method of transportation when needed to carry out job-related essential functions.
- Successful clearing through the Live Scan and the Health Clearance process with the County of Los Angeles.
- Ability to work across technical and program teams and contribute to shared engineering practices.
- Two (2) years of experience applying advanced statistical analyses, including predictive analytics or data engineering, to produce actionable recommendations to support data-driven program, policy, and operational decision-making.
- A Bachelors degree from an accredited college in a field of applied research such as Data Science, Machine Learning, Mathematics, Statistics, Business Analytics, Psychology, Computer Science, or Public Health
