Data/Analytics Engineer

Salary Range: $10,214.43 -$13.376.56 monthly

SUMMARY

Serves as the Data & Analytics Engineer for Community Programs (CPs), acting as the Lead Data Architect for CP’s Databricks environment.

This role sits at the intersection of data engineering and advanced analytics, responsible for the end-to-end design, implementation, and management of a governed Medallion Architecture (Bronze, Silver, Gold) supporting housing, justice, and clinical operations.

This position replaces legacy reporting workflows with a unified, secure data platform that stitches complex, multi-sector program participation records across disparate systems into a cohesive longitudinal client model.

The role bridges infrastructure and advanced analytics by building scalable data products and integrations that support program tracking, executive reporting, and predictive modeling for County and State stakeholders.

WHAT YOU WILL DO


* Build and scale a governed Databricks environment that serves as the single source of truth across housing, justice, and clinical systems


* Design and implement automated, production-grade data pipelines and CI/CD workflows using Databricks, Terraform, and GitHub


* Translate complex program logic into scalable data models and reusable data products


* Build scalable semantic models that map a single client's journey across disparate housing, justice, and clinical programs, standardizing touchpoints over time.


* Establish secure-by-design data systems handling sensitive clinical (PHI) and justice (CJI) data utilizing Unity Catalog for centralized governance, audit logging, and access control.


* Enable advanced analytics by developing curated datasets, APIs, and environments for machine learning and NLP applications


* Partner with leadership and cross-functional teams to shape how data is used to drive policy, operations, and outcomes


* Lead and mentor technical staff while setting engineering standards for long-term scalability and maintainability


* Programmatically map complex, multi-source program utilization (CHAMP, DD, HMIS) to specific funding streams for strict fiscal and grant tracking compliance.

ESSENTIAL FUNCTIONS


* Data Infrastructure & Lakehouse Architecture: Design, implement, and maintain a scalable Databricks architecture using Medallion principles.

Build and optimize large-scale ETL/ELT pipelines to integrate structured and unstructured data across housing, justice, and clinical systems.

Ensure interoperability with healthcare and justice standards (e.g., FHIR, HL7v2) and support a unified, governed data environment serving as the system of record for analytics.


* Infrastructure Automation & DevOps (CI/CD): Design and manage automated data lifecycles using GitHub Actions and Terraform (Infrastructure as Code).

Implement software engineering practices, including version control, automated unit testing, and continuous integration to validate pipeline logic prior to production de...