Skip to content
getdataengineeringjobs
Back to results

Data Engineer - Legal Entity Platform (Amazon Web Services / Snowflake)

Remote Senior Contract Posted

Summary

Written in English from the original posting

Data 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.

Similar jobs

Cloudary SAS Apply