Analytics engineering and AI data teams struggling with fragile cron scripts, unvalidated warehouse tables, or runaway BigQuery/Snowflake compute bills frequently search to hire a freelance dbt, BigQuery, Snowflake, Dagster & Airflow data pipeline programmer. I am Aldian Fazrihady, a Senior Freelance Data & AI Engineer available via Upwork.
Core Modern Data Stack & AI Feature Pipeline Capabilities
- Modular dbt (Data Build Tool) Transformation Layers: Structuring staging, intermediate, and mart SQL/Python models with incremental materializations, partitioning/clustering keys, and automated data quality tests (`not_null`, `unique`, `relationships`).
- Dagster & Apache Airflow Asset Orchestration: Building software-defined data assets that coordinate ELT ingestion (dlt / Airbyte / Fivetran), dbt runs, and downstream `pgvector` embedding refreshes.
- BigQuery & Snowflake FinOps Tuning: Eliminating full-table scans via date partitioning, clustering, and BI Engine / materialized view caching.
Frequently Asked Questions
Can a freelance programmer connect our BigQuery or Snowflake warehouse safely to an AI text-to-SQL agent?
Yes. I build curated, read-only semantic dbt mart views with rich column descriptions and strict cost-limited service accounts so LLM text-to-SQL agents generate accurate, safe analytical queries.
How can we hire you for dbt, BigQuery, or Dagster engineering?
Reach out on Upwork.