Python Data Integration Developer
Basic Information
- Experience Level: 5 10 years
Required Skills
- Strong Python 3.x experience for data ingestion and transformation.
- DataFrame processing expertise (Polars preferred Pandas acceptable).
- Relational database modeling skills.
- Familiarity with Genevas data structures (output layouts not platform config).
- AWS (S3 ECS/Fargate RDS Postgres).
- API consumption (GraphQL REST JSON).
- Strong experience deploying Geneva in the Private Credit / Fund space including multi-layer SPV/Fund structures.
- Knowledge of Geneva securities.
Nice-to-Haves
- Working Java knowledge for ORM integration.
- Experience with Snowflake as a staging area.
- Knowledge of bitemporal data models.
- Workflow automation (BPMN tools).
Core Responsibilities
- Ingest and transform Geneva output data (post-trade portfolio accounting) into internal ORM (Postgres ORM).
- Develop Python-based data importers for ingestion and transformation.
- Assist in implementing Java components for ORM integration and bitemporal data model handling.
- Map Geneva data to internal relational structures ensuring accuracy and referential integrity.
- Use GraphQL APIs to deliver data in standardized formats.
- Collaborate with internal teams to enhance ingestion workflows and support reporting.
- Document maintain and test ingestion processes.
- Support AWS-hosted infrastructure for data pipelines (ECS/Fargate S3 RDS).
- Use Snowflake for temporary staging of rapidly evolving datasets when needed.