Summary
Written in English from the original postingData Engineer for a legal entity platform pilot, building automated ingestion pipelines from CSV and XML exports into AWS S3 and Snowflake. The role designs an entity data model, point-in-time ownership graph, data lineage, quality checks, and access controls, with infrastructure as code and CI/CD. It is a remote hourly contract requiring 5+ years of production data engineering experience.
Job description
This role builds the data foundation of a Legal Entity Platform: an AI-ready, single source of truth for ownership and control data across 8,000+ legal entities. The first phase is a pilot for one investment fund, starting in December 2026.
The scope covers source ingestion into AWS and Snowflake, a unified entity model with a unique Entity ID, and a point-in-time ownership graph (14+ levels) that calculates economic ownership percentages. It also includes data lineage, quality checks, and access control. Work is done in the client’s AWS accounts through a VDI.
What you will do
Build automated ingestion pipelines from source-system CSV/XML exports into S3 and Snowflake (Snowpipe), and work around incomplete or limited source APIs.
Design an all-tiers entity data model with a unique Entity ID and a crosswalk to source systems.
Support fuzzy name and alias resolution together with the AI/ML lead.
Build a point-in-time ownership graph (14+ levels, effective-dated relationships) and deterministic economic-ownership calculations.
Capture lineage on every attribute (source, as-of date, owner, AI confidence) and route low-confidence AI matches to a data steward review queue.
Implement ingestion checks, source-precedence rules, register reconciliation, and role-, region- and attribute-level access.
Manage infrastructure as code and CI/CD, and serve data to search, charts, and natural-language Q&A.
Job requirements
5+ years of hands-on data engineering on production pipelines.
Advanced SQL and Python.
Hands-on experience with AWS data services (S3, Lambda, Glue, Step Functions, EventBridge).
Graph or hierarchical data modeling (recursive CTEs, point-in-time / bitemporal data).
Entity resolution or Master Data Management (MDM) experience.
Terraform or CloudFormation, and Git-based CI/CD.
Fluent English (written and verbal).
Nice to have
Snowflake (Snowpipe, Streams/Tasks).
Graph databases (Neptune / Neo4j).
Amazon Bedrock for document extraction.
Private-equity, fund structure, or legal-entity ownership data.
AWS or SnowPro certifications.
Engagement details
Hourly contractor
Remote (US Eastern or Central hours preferred)
Full time (40 hs/week)
Start: ASAP (December 2026)
Duration: 3–6+ months
The weekly Digest
The week's most transparent data engineering jobs in your inbox once a week.
Once a week, a few new jobs that state their salary, location and stack, plus links to the rest. No open tracking; clicks are counted per issue, not per person. Unsubscribe with one click.