dbt & Dagster Social Integration -- 2

Madrid based project. Spanish language is a must

I need to bring content-performance data from Facebook, Instagram, GA4, Google Ads and Bing into an onpremise data warehouse and shape it with dbt, orchestrated by Dagster. The objective is pure data integration; reporting and dashboards will be handled later by a separate team.

You will design the ingestion pipelines, model the raw tables into analytics-ready marts with dbt, and schedule the entire workflow in Dagster so it runs reliably in production.

Key deliverables
• Source-to-target ingestion pipelines for every platform listed above
• dbt models, tests and documentation following best-practice folder structure
• Dagster jobs, sensors and deployment files that trigger daily loads and alert on failure
• A short run-book so my in-house analysts in Madrid can operate and extend the setup