Daily SQL ETL Automation

I need a hands-free SQL workflow that runs every 24 hours and reliably moves raw data all the way through extraction, transformation, and loading so it is analytics-ready each morning. I have not locked myself into a single platform yet, so whether you prefer MySQL, PostgreSQL, or Microsoft SQL Server, please build with portability in mind and note any engine-specific features you use. Robust logging, error handling, and clear configuration (no hard-coded secrets) are essential because I want to monitor runs without hovering over them.

Deliverables
• Code or stored procedures that handle:
– Data extraction
– Data transformation
– Data loading
• A scheduler setup (native DB agent, cron, Task Scheduler, or similar) that triggers the pipeline daily.
• Concise documentation or inline comments so I can tweak sources, targets, and run times later.

Acceptance criteria
• End-to-end run finishes on my sample dataset within the agreed window and leaves target tables in a consistent state.
• Failures are logged with enough detail for quick troubleshooting, and partial loads roll back cleanly.

Feel free to script in pure SQL, add a bit of Python or Bash, or suggest tools like Airflow, SSIS, or dbt if they keep the stack lightweight. I’m ready to review your approach and iterate quickly so the job can move to production next week.