Data Engineer – Legal Entity Platform (AWS / Snowflake) (107)
Remote job2h ago
Key details
- Location
- Remote job
- Work style
- Remote
- Level
- Senior
- Job type
- Contract
- Experience
- 5–8 yrs
- Function
- Data & ML
- Focus area
- Data engineering & Analytics
- Posted
- 2h ago
Skills
About the role
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
How well do you match this job?
Free account needed to apply or save. It takes a minute, and we'll bring you right back to this job.