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?
- Reasons about data volume and query cost before writing code, not after a performance incident.
- Rigorous about correctness: a risk score shown in two places has to agree in both.




- Able to explain a data lineage or freshness constraint to a clinician in terms they can act on.
- Treats migrations, rollback and data quality checks as part of the deliverable.
- 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 service level per d

📌 Senior SQL and Data Engineer (India)
🏢 Aubrant Digitial
📍 India