Healthcare Analytics Engineer: Data Transformation Lead

Translucent; New York (NY); On-site; USD 120,000 - 190,000; Full time

Job summary

Translucent is hiring a Forward Deployed Analytics Engineer in New York to bridge customer financial/clinical data with our agentic AI systems. You will reverse-engineer business rules, build durable data transformations, and ensure data correctness within our managed pipeline.

Join a high-ownership role, work directly with customers to capture source-of-truth models, and translate them into durable, well-tested data workflows.

Qualifications

• Deep healthcare data domain experience in health systems, healthcare consulting, or health tech.
• Strong SQL fluency and experience with data transformations.
• Ability to reverse-engineer and codify complex business rules from source systems.
• Experience with BigQuery SQL or equivalent.
• Hands-on in modern data platforms (Databricks, Snowflake, Fabric, BigQuery).
• Familiarity with transformation tooling like dbt-style workflows and SQLMesh.
• Proven end-to-end ownership of data pipelines and transformations.
• Solid data modeling and pipeline instincts; manage schemas and domain entities.
• Experience handling historical backfills and incremental loads without breaking downstream.
• Git-native, PR-driven workflow with CI/CD.
• Production Python experience in real pipelines.

Responsibilities

• Understand customer requirements, workflows, and business logic.
• Identify data needed to stand up a customer workspace and review data models.
• Reverse-engineer and codify customer-specific rules from source systems.
• Build and validate transformations mapping data into the ontology and semantic layer using SQL.
• Own testing and validation for every transformation shipped.
• Collaborate with data platforming and platform teams on constraints.
• Interact with customers to confirm data access and validate logic.
• Work with product/engineering to expand data ontology as needs evolve.

Skills

Healthcare data domain

SQL

Reverse-engineering business logic

BigQuery SQL

Databricks/Snowflake/Fabric

dbt-style transformations

End-to-end data pipelines

Data modeling

Incremental & backfill loads

Git/PR workflow

Production Python

Experience 3-5+ years

Tools

Databricks

Snowflake

Fabric

BigQuery

SQLMesh

Job description

Translucent is hiring a Forward Deployed Analytics Engineer in New York to bridge customer financial/clinical data with our agentic AI systems. You will reverse-engineer business rules, build durable data transformations, and ensure data correctness within our managed pipeline.

Join a high-ownership role, work directly with customers to capture source-of-truth models, and translate them into durable, well-tested data workflows.