Worked on the pass-culture/data-gcp repository over a two-month period, focusing on stabilizing and maintaining data engineering workflows rather than delivering new features. Addressed critical reliability issues by fixing database naming inconsistencies in CI/CD and dbt source configurations, using SQL and YAML to ensure consistent deployments and reduce risk across environments. Improved maintainability by refactoring environment selection logic for database names, simplifying conditional expressions without altering behavior. Additionally, resolved a SQL syntax error in the Firebase Performance Data Pipeline, which restored accurate metric extraction and data integrity. Demonstrated a methodical approach to troubleshooting and enhancing data pipeline reliability and analytics.