Forward Deployed Analytics Engineer

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

Why Translucent

Healthcare providers drive $2.5 trillion in medical expenditures annually - and operate on razor-thin 2-5% margins. Despite these stakes, the finance teams behind these organizations are buried in spreadsheets, manual data pulls, and disconnected systems, spending more time finding and cleaning data than actually using it to make decisions.

Translucent is changing that. We're building the agentic AI platform designed exclusively for healthcare finance - giving every finance team, department, service line their own arsenal of AI Agents that run 24/7, understand their specific data, business logic, and workflows.

Founded in 2024 and backed by GV, NEA, FPV, and Virtue, we've already been deployed by healthcare organizations managing over $5 billion in combined revenue. The product-market fit is real, the problem is massive, and we're just getting started. If you want to work at the intersection of AI and one of the most complex, consequential industries in the world - this is the place.

About the role

We're hiring a Forward Deployed Analytics Engineer to join our team in New York. You will sit at the intersection of our customers' financial and clinical data and the agentic AI systems we are building on top of it. Working within our managed data pipeline, you will reverse-engineer customer-specific business rules, build the transformations that map raw customer data into our unified ontology and semantic layer, and hold the bar for correctness on everything that flows through it.

This is a high-ownership role. You will work directly with customers to understand their source-of-truth financial and clinical models, then translate that understanding into durable, well-tested data transformations.

What you'll do

• Understand customer requirements, current processes, workflows and business logic.
• Identify the data required to stand up a customer workspace, and review customer source-of-truth financial and clinical data models - potentially on-site with customers to capture business logic firsthand.
• Reverse-engineer and codify customer-specific business rules, from payer contract logic to chart-of-accounts idiosyncrasies.
• Build and validate transformations that map customer data into Translucent's unified ontology and semantic layer, using SQL within our managed data pipeline.
• Own testing and validation rigor for every transformation you ship - you are the last line of defense on data correctness.
• Partner with our data platforming team when transformation needs surface pipeline or platform constraints, without owning that infrastructure yourself.
• Interact directly with customers to confirm data access and validate your understanding of their source systems and business logic.
• Work with our platform team to identify expansion opportunities for core infrastructure and shared services, based on patterns you see across customer engagements.
• Partner with our insights and product engineering teams to understand and expand our data ontology as new customer needs and data sources emerge.

What we're looking for

Must-haves

• Deep healthcare data domain experience - prior work at a health system, healthcare-focused consulting, or health tech, with hands-on exposure to claims, reimbursement, or revenue cycle data. (EHR/clinical data experience is a plus)
• Comfort reverse-engineering messy or under-documented business logic directly from source systems.
• Strong SQL - this is the primary tool of the role, and we expect real fluency, not familiarity. Bonus points for BigQuery SQL experience.
• Experience working inside a modern data platform (Databricks, Snowflake, Fabric, BigQuery, or similar) as a hands-on user.
• Experience with dbt-style transformation tooling (we use SQLMesh) including model contracts and layered/medallion architectures; comfort working in transformation-as-code workflows including testing and validation.
• Track record of owning a data pipeline or transformation layer end-to-end, not just contributing to one someone else built.
• Solid data modeling and pipeline instincts: comfortable reasoning about schemas, normalization vs. denormalization, modeling complex domain entities and operating a data pipeline.
• Experience reasoning about and building both historical backfills and incremental loads - knowing when each is appropriate, and how to handle late-arriving or corrected data without breaking downstream consistency.
• Comfortable operating in a git-native, PR-driven workflow - version control, code review, and shipping changes through an established CI/CD pipeline.
• Production Python experience - you've shipped and maintained Python in a real pipeline or codebase, not just used it for scripts.
• 3-5+ years of relevant industry experience.

Nice-to-haves

• Epic Cogito and Epic Clarity certifications or accreditations
• Comfort working under strict PHI/data-governance constraints (e.g., synthetic-only test fixtures, no real patient data in code).
• Healthcare interoperability standards