Job Description:

As a Senior SQL and Data Engineer, you will own the data tier that everything
else in this platform depends on. You will design the denormalized read models
and snapshot tables that let a composed patient view resolve in milliseconds,
tune the queries and indexes that serve them, and build the refresh pipelines
that keep them current against EHR, health information exchange, claims and
pharmacy feeds with clearly published freshness guarantees.

You will work at production data volume, with execution plans open, and you will
be the person who can say what a query will cost before it ships. You also own
the de-identification path that lets offshore engineers work safely, which means
designing synthetic data that is realistic enough to test against
and provably free of protected health information.

What qualifications make you an Aubrant Senior SQL and Data Engineer?

1. Reasons about data volume and query cost before writing code, not after a
performance incident.

1. Rigorous about correctness: a risk score shown in two places has to agree in
both.

1.



Able to explain a data lineage or freshness constraint to a clinician in
terms they can act on.

1. Treats migrations, rollback and data quality checks as part of the
deliverable.

1. Comfortable owning a single critical seat and being the escalation point for
it.

Responsibilities:

Data Modeling and Performance:

* Design denormalized read models and snapshot tables that let a multi-source
patient view resolve as a small number of indexed lookups.

* Own index strategy across covering, filtered and columnstore indexes, and
tune queries using execution plans and Query Store at production volume.

* Partner with the architect on SQL Server workload management, including
Resource Governor and readable secondary routing.

Pipelines and Integration:

* Build and operate ETL, change data capture and delta refresh pipelines across
EHR, HIE, claims and pharmacy sources.

* Define and publish a refresh ser

📌 Senior SQL and Data Engineer (Hyderabad)
🏢 Aubrant Digital
📍 Hyderabad