Cloudary SAS logo

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

Hiring from
Brazil
Work type
Remote
Posted

622,563 remote jobs, straight from company career pages

100% free · New jobs every minute

Show 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

Apply for this job100% free