Looker Studio Dashboard developer/Engineer (iPaaS, Python, BigQuery)

We are seeking an experienced data engineer/automation expert to build an end-to-end automated data pipeline. The goal is to ingest, standardize, and visualize heterogeneous text data from multiple external sources, creating a highly responsive, drill-down capable monitoring dashboard with real-time alerting. What We Have (Data Sources): The data is fragmented and comes from 2-3 channels. API Ingestion: Real-time or scheduled data fetching via third-party software APIs. Automated Scraping/Downloads: Webhook-based pushes or automated CSV/JSON exports from scraping tools. Data Dimensions: Platform source, publish time, raw text/content, engagement metrics (reach, likes), and metadata. What We Need to Achieve: Automated Ingestion (12-Hour SLA): Reliable extraction and aggregation from all sources every 12 hours without manual intervention. ETL & AI Tagging: Cleanse and standardize the heterogeneous data. BI Dashboard: Connect the database to a modern BI tool to visualize trends. Ideal Stack / Approach: We are open to your specific tool recommendations. We prioritize existed , cost-effective, and highly maintainable architectures. To Apply, Please Provide: A brief overview of the architecture/tools you would use to achieve this workflow. Examples of similar automated ETL + BI dashboard projects you have built.