About

We need an experienced engineer to build a reliable ingestion pipeline that connects to Square’s Payouts and Payout Entries APIs, enriches with Square Location metadata, and stores the results in Snowflake for reporting. Scope: Ingest data from 5 separate Square instances. Transform and roll up merchant fees and revenues per location, per day. Store the results in Snowflake (fact table + location dimension). Schedule the job to run daily (with retry/recovery for reliability). Deliverable: Automated, production-ready pipeline that: Pulls and aggregates Payout Entry data. Groups by location and date. Loads into Snowflake for use in reporting views.