Worked on the cal-itp/data-infra repository to deliver three new features focused on data modeling and workflow automation. Developed and validated new TIDES data models for vehicle locations and trips, supporting public GTFS-RT feeds and per-agency exports with high data quality and historical accuracy. Enhanced the CI/CD pipeline by integrating Graphviz into GitHub Actions, enabling automated visual model reporting during builds. Refactored dbt models to implement SCD Type 2 joins and introduced persistent source_record_id fields, ensuring stable identity across data versions. Leveraged SQL, YAML, and dbt to improve data integrity, validation, and maintainability within a scalable engineering framework.