Delivery Lead - Python Data Integration Developer

About the Job

Required Skills/Desired Skills and Experience:

• Strong Python 3.x experience for data ingestion and transformation.
• Data Frame processing expertise (Polars preferred, Pandas acceptable).
• Relational database modeling skills.
• Familiarity with Geneva’s data structures (understanding 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 and understands the nuances of multi-layer SPV/Fund structures setups.
• Know how Geneva securities work.

Nice-to-Haves:

• Working Java knowledge for ORM integration.
• Experience with Snowflake as a data staging area.
• Knowledge of bitemporal data models.
• Workflow automation (BPMN tools).

Key Responsibilities:

Focus is on extracting Geneva data outputs and integrating them into the firm’s Postgres + ORM platform. This work is developer-centric, requiring both data engineering and financial data domain awareness.

Core Responsibilities:

• Ingest and transform Geneva output data (post-trade, portfolio, accounting data) into the internal ORM (Postgres + ORM).
• Develop Python-based data importers for ingestion and transformation.
• Help implement 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 retrieve and deliver data in standardized formats.
• Collaborate with internal teams to enhance ingestion workflows and support downstream reporting.
• Ensure ingestion processes are documented, maintainable, and tested.
• Support AWS-hosted infrastructure for data pipelines (ECS/Fargate, S3, RDS).
• Work with Snowflake for temporary staging of fast-evolving datasets when required.

Acuity Knowledge Partners is a leading provider of bespoke research, analytics, and technology solutions tailored for the financial services sector. Serving asset managers, corporate and investment banks, private equity and venture capital firms, hedge funds, and consulting firms, Acuity supports over 500 financial institutions and consulting companies globally. With a network of over 6,000 analysts and industry experts, combined with proprietary technology, Acuity operates from 10 locations worldwide, providing services to help clients unlock their human capital, drive revenue higher, and transform operations. Established as a separate entity from Moody's Corporation in 2019, following its acquisition by Equistone Partners Europe, Acuity is now majority-owned by funds advised by global private equity firm Permira. The headquarters is in London, with operations spanning globally.