Senior Python Developer for API-to-SQL Data Synchronization Platform

We are seeking an experienced Python backend developer to design and implement a data integration platform that synchronizes data from one or more external REST APIs into a SQL database. The system will periodically retrieve data from external services, transform and validate the incoming records, and persist them into a relational database while maintaining complete auditability and operational visibility. The solution must be reliable, maintainable, and capable of handling evolving API schemas, large datasets, intermittent connectivity issues, and long-running unattended operation. Responsibilities • Design the overall architecture • Implement API integration components • Design database schema and persistence layer • Handle pagination, retries, rate limits, and error recovery • Implement data validation and transformation logic • Create structured logging and debugging facilities • Provide deployment and configuration documentation • Ensure reliable synchronization of new and updated records Required Skills • Strong Python experience • Experience integrating third-party REST APIs • Experience with SQL databases (PostgreSQL, SQL Server, or MySQL) • Experience building backend services and automation systems • Strong debugging and troubleshooting skills • Experience handling large data imports and synchronization processes Preferred Experience • FastAPI • SQLAlchemy • Docker • Background job processing • Data migration and ETL systems • Monitoring and observability tooling • Cloud deployment experience Project Goals The resulting system should: • Synchronize data from external APIs into a local database • Support incremental updates • Handle API schema changes gracefully • Maintain detailed audit logs • Provide sufficient logging and diagnostics for troubleshooting • Be easily extensible for additional API integrations in the future To Apply Please begin your proposal with the words "Python Integration" so I know you have read the full description. Please also describe: 1. Similar integration projects you have completed 2. How you would structure the application 3. How you would handle API schema changes over time 4. How you would ensure reliable synchronization without duplicates or missing records 5. Your preferred technology stack for this project