Amazon SP-API + Ads API Expert

Hourly consulting. Calls, code review, help running pulls. Scope is only Amazon Selling Partner API (SP-API) and Amazon Advertising API. Not Salesforce, not SAP ERP, nothing else. We already pull Seller + Ads data into Snowflake with Python (DLT). Auth works. The pain is speed and reliability on historical and multi-account pulls, especially Sales & Traffic and Ads reporting under rate limits and retention rules. This is not a greenfield build and not “learn Amazon on our dime.” We need someone who has shipped large Amazon SP-API and Ads API pipelines in production to review our Python approach, advise the fastest reliable pattern (Reports vs Data Kiosk, windowing, parallelism, quotas, Ads retention), walk the code on calls, help define the design, and help us run and validate pulls. Advisory first — not necessarily a full rewrite. Our footprint: 5 seller/advertising brands with multiple Seller Central and Ads authorizations. Marketplaces mainly US, CA, MX (BR on some accounts). About 27 SP-API resources per marketplace and about 27 Ads resources (SP/SB/SD entities plus daily reports). Snowflake already has finances on the order of 1.1M+ rows, Ads campaign reports around 87K+ rows and growing, multi-account schemas. Business scale roughly $17M+ SP-API net sales in the loaded API window; fuller historical validation data around $59M US product sales. We want up to ~1–2 years of SP history; Ads practical lookback is ~60–95 days (we know longer Ads history has to be stored daily). Main pain: Sales & Traffic backfills take many hours because of 1-day report windows for ASIN daily grain plus tight Reports quotas. Ads incremental/backfill must be solid given retention limits. Only apply if you have shipped production Amazon SP-API and Ads API data pipelines before (multi-marketplace and/or multi-account) and can describe that experience in your proposal: volume, endpoints/reports, stack, what broke, how you fixed it. If you have not done this at scale, do not apply. In your proposal, briefly cover: 2–3 past Amazon SP/Ads ingestion projects with volume and endpoints; your recommended approach for multi-year Sales & Traffic vs Ads retention; hourly rate and typical hours for an advisory engagement (e.g. 5–15 hours for review, design, and a first working run); earliest availability for a paid kickoff call.