Data Scientist - Analytics Engineer (N375)

Salary Range: $8,840.09-$11,912.82 monthly

SUMMARY

The Los Angeles County Department of Homeless Services and Housing (HSH) consolidates our countywide response to homelessness. The driving force behind HSH is increasing accountability and transparency, improving care for people experiencing or at risk of homelessness, and streamlining collaboration with partners including services providers, the County’s 88 cities, and unincorporated areas to deliver high-quality, life-saving care.  Staff schedules are based on business need and may include the option for a hybrid work schedule where employees work remotely and from the office.

The Analytics Engineer plays a key role on the HSH Data Engineering team, building the semantic layer that supports performance tracking, evaluation, and policy guidance.

This position translates analytic requirements into curated silver and gold data models using Databricks and supports integration of data from normalized backend systems.

This is a chance to architect a scalable data environment from the ground up in a mission-driven context.

The engineering team plays a central role in the County’s data strategy, with opportunities for mentorship, innovation, and cross-sector impact.

ESSENTIAL FUNCTIONS


* Build and maintain semantic data models (silver and gold layers) in Spark/Databricks, primarily through 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.

This includes creating and maintaining documentation that clarifies data model logic, table relationships, and mapping assumptions to support downstream users and internal knowledge transfer.


* 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.


* Apply expectations and version control to standardize, test, and document pipelines.


* Collaborate with Evaluation and Reporting teams to align models with use cases and downstream needs.


* Participate in integration of external and internal sources using Azure services and contribute to scalable, secure data pipelines.


* Support data modeling standards and technical documentation practices.


* Assist in ...