Python API Integration Engineer
Location: Westlake, TX ( 5 days onsite, then 5 days remote. so onsite every other week. Can also sit in Raleigh NC or Jersey City NJ. )
Required:
Integrate API’s with internal portfolio management systems using Python, enabling seamless data flow for investment reporting and analytics.
• Integrate API endpoints to synchronize investment management data using Django/FastAPI/Zope REST Framework for real-time financial data exchange.
• Develop robust ETL APIs that automate data mining and transfer between different database sources and the Allvue platform.
• Build Python based document extraction pipelines – Parse investor statements, capital call and other documents (PDF/excel), converting unstructured data into validated JSON
Create Python scripts to parse and load data from API in XML/JSON formats, ensuring data integrity and consistency across platforms.
• Design and implement dedicated MySQL database using complex SQL queries for efficient data retrieval and analysis.
• Collaborate with cross-functional teams to define API requirements and troubleshoot integration issues, improving data accuracy and team efficiency.