Data Engineer Los Angeles County - Department of Health Services
Build and maintain ETL/ELT pipelines that ingest clinical, housing, and operational data from multiple source systems into Azure SQL and Synapse warehouses. Use Spark and Hive for large-scale processing and develop Spark SQL and PySpark transformations.
Create dimensional data models for Housing for Health reporting, KPI tracking, and CQI initiatives used by more than 200 staff through Power BI. Schedule and monitor loads using Apache Airflow and Azure Data Factory, while implementing validation, quality checks, logging, error handling, alerting, and HIPAA-compliant performance improvements.