Skip to content

Data Engineer – Legal Entity Platform (AWS / Snowflake) (102)

  • Remote
    • -, São Paulo, Brazil
  • Technology

SQL, Python, AWS (S3, Lambda, Glue, Step Functions, EventBridge), Snowflake (Snowpipe), Terraform / CloudFormation, Git-based CI/CD, Graph / Hierarchical Data Modeling, Entity Resolution / MDM

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.

Job requirements

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

Remote
  • Brazil
Technology

or