Horse Racing Analytics Data Integration
Budget: ₹12,500 – ₹37,500 INR
# API / Data Integration Engineer Required – Horse Racing Analytics Platform
We are looking for an experienced API and data integration engineer to support an existing horse racing analytics platform.
The backend is already built using **Python, FastAPI, PostgreSQL, and SQLAlchemy**. The system currently supports CSV/XLSX/HTML imports, race card imports, trackwork imports, medical reports, declarations, results, and post-race audits.
The current requirement is to integrate structured racing data sources into the existing backend and improve the data ingestion pipeline.
## Scope of Work
* Integrate external racing data APIs or structured feeds if available.
* Connect data sources such as JSON, XML, CSV, Excel, HTML, or FTP/SFTP feeds.
* Build clean API clients for supported providers.
* Map external data into our existing database schema.
* Improve source-link import for racing websites.
* Improve HTML parser coverage where API access is unavailable.
* Validate imported race cards, declarations, scratchings, trackwork, results, and medical data.
* Handle authentication, API keys, rate limits, retries, and logging.
* Build error handling for failed/partial imports.
* Maintain source attribution for every imported field.
* Ensure no duplicate horse/race records are created.
* Add tests for every new integration.
## Required Skills
* Python
* FastAPI
* PostgreSQL
* SQLAlchemy
* REST API integration
* JSON/XML/CSV data mapping
* HTML parsing with BeautifulSoup/lxml
* Data validation
* API authentication and rate-limit handling
* Git
## Preferred Skills
* Sports data APIs
* Horse racing or betting data experience
* Web scraping/parser experience
* PDF/OCR data extraction
* Background jobs / schedulers
* Docker
## Important Requirements
* Do not redesign the existing backend.
* Do not create duplicate database tables unless required and approved.
* Do not invent missing data.
* Do not hard-code predictions or results.
* Missing fields must be reported clearly.
* If a source blocks automated access, the system should support saved HTML/CSV/XLSX upload instead.
* Every imported record must include source name and timestamp.
## Deliverables
* Working API/data integration modules
* Clean data mapping into existing PostgreSQL tables
* Import validation reports
* Error and retry handling
* Unit/integration tests
* Documentation for setup and usage
## Current Goal
We want to reduce manual data entry by integrating structured racing data sources wherever possible and improving the reliability of automated imports.
Please share:
* Your relevant API integration experience
* Similar data ingestion projects
* Suggested approach
* Estimated timeline
* Fixed cost or hourly rate
* GitHub/portfolio links if available
We are looking for an experienced API and data integration engineer to support an existing horse racing analytics platform.
The backend is already built using **Python, FastAPI, PostgreSQL, and SQLAlchemy**. The system currently supports CSV/XLSX/HTML imports, race card imports, trackwork imports, medical reports, declarations, results, and post-race audits.
The current requirement is to integrate structured racing data sources into the existing backend and improve the data ingestion pipeline.
## Scope of Work
* Integrate external racing data APIs or structured feeds if available.
* Connect data sources such as JSON, XML, CSV, Excel, HTML, or FTP/SFTP feeds.
* Build clean API clients for supported providers.
* Map external data into our existing database schema.
* Improve source-link import for racing websites.
* Improve HTML parser coverage where API access is unavailable.
* Validate imported race cards, declarations, scratchings, trackwork, results, and medical data.
* Handle authentication, API keys, rate limits, retries, and logging.
* Build error handling for failed/partial imports.
* Maintain source attribution for every imported field.
* Ensure no duplicate horse/race records are created.
* Add tests for every new integration.
## Required Skills
* Python
* FastAPI
* PostgreSQL
* SQLAlchemy
* REST API integration
* JSON/XML/CSV data mapping
* HTML parsing with BeautifulSoup/lxml
* Data validation
* API authentication and rate-limit handling
* Git
## Preferred Skills
* Sports data APIs
* Horse racing or betting data experience
* Web scraping/parser experience
* PDF/OCR data extraction
* Background jobs / schedulers
* Docker
## Important Requirements
* Do not redesign the existing backend.
* Do not create duplicate database tables unless required and approved.
* Do not invent missing data.
* Do not hard-code predictions or results.
* Missing fields must be reported clearly.
* If a source blocks automated access, the system should support saved HTML/CSV/XLSX upload instead.
* Every imported record must include source name and timestamp.
## Deliverables
* Working API/data integration modules
* Clean data mapping into existing PostgreSQL tables
* Import validation reports
* Error and retry handling
* Unit/integration tests
* Documentation for setup and usage
## Current Goal
We want to reduce manual data entry by integrating structured racing data sources wherever possible and improving the reliability of automated imports.
Please share:
* Your relevant API integration experience
* Similar data ingestion projects
* Suggested approach
* Estimated timeline
* Fixed cost or hourly rate
* GitHub/portfolio links if available