Data Engineer

Role Overview: We're looking for an experienced Data Engineer to build and own our marketing analytics data pipeline, from live ad platform APIs to auto-refreshing client dashboards. What you'll do: -Connect Google Ads, Meta Ads, Facebook Ads, CRM, and internal systems directly via API — no more manual exports -Own the full ETL process: extract, clean, standardize, and load data into Supabase -Build automated workflows so dashboards refresh on their own -Set up data quality checks/alerts so issues are caught before they reach the client -Build clean, structured dashboards connected to live data -Investigate and fix reporting discrepancies at the source -Spot trends/issues in the data and turn them into clear, actionable recommendations that a non-technical client can act on Must-haves: -Hands-on experience with Google Ads, Meta Ads, and Facebook Ads data comfortable with ROAS, CPA, CTR, spend, and conversions -Proven track record building automated ETL pipelines and workflows end-to-end -Experience with automation tools such as n8n, Make.com, Zoho Flow, or similar -Strong daily SQL — joins, aggregations, data cleaning, optimization -Python for scripting and pipeline work -Hands-on database experience: Supabase, PostgreSQL, BigQuery, or Snowflake -Experience connecting platforms to databases via REST APIs -Ability to design clean, maintainable table structures for reporting Nice-to-have: -Experience working in a digital marketing agency -Familiarity with cloud data warehouses (BigQuery, Snowflake, Redshift) -A portfolio of dashboards that drove real business decisions To apply: Please include a short note on one automated pipeline you've built end-to-end the platforms it connected, the tools you used, and what problem it solved.