Fix and Improve a Small dbt / BigQuery Data Pipeline

September 28, 2026

I’m looking for an experienced Data Engineer to review and improve a small existing data pipeline using **Python, SQL, dbt, and BigQuery**.

The pipeline currently lo data into BigQuery, but I need help cleaning up the transformation logic, adding basic data-quality checks, and making sure the workflow can run reliably without manual intervention.

This is a small, well-defined task rather than a full data platform build.

**Scope of Work**

* Review the existing SQL/dbt transformation logic

* Fix any obvious issues in the pipeline

* Add 3–5 basic dbt data-quality tests

* Improve one incremental model if necessary

* Verify the final tables are loading correctly in BigQuery

* Add basic documentation explaining the changes

* Provide a short handoff note with recommendations

**Required Skills**

* SQL

* Python

* dbt

* BigQuery

* ETL / ELT pipelines

* Data validation and troubleshooting

Experience with Airflow or Cloud Composer is a plus, but not required for this task.

**Deliverables**

1. Updated dbt/SQL files

2. Working data-quality tests

3. Verified successful pipeline run

4. Short documentation / handoff notes

This should be a relatively small assignment for someone experienced with modern data engineering workflows.

Share Share