Senior SQL and Data Engineer (India Only)

About the role

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.

What you'll do

• 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
• 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 data source, so the interface can show accurate as-of dates rather than implying real-time data

What you need

• 6–11 yrs of experience
• SQL
• SQL Server
• Azure
• .NET
• C#
• Data modelling
• B.Sc or B.Tech or B.E. or BCA

Good to have

• Azure Data Factory
• Databricks
• Redis
• ETL
• Reconciliation