Senior SQL and Data Engineer (India Only)

Aubrant Digital LLC; Hyderabad; On-site; INR 2,400,000 - 4,200,000; Full time

Job summary

Aubrant Digital LLC is seeking a Senior SQL and Data Engineer to own the data tier across our platform. You will design denormalized read models, tailor snapshot tables, and optimize queries for fast patient views across EHR, HIE, claims, and pharmacy feeds.

You will manage de-identification paths, ensure data quality, and deliver versioned migrations within CI pipelines. Strong SQL Server/Azure SQL expertise and English fluency are required for daily client-facing work.

Qualifications

• Bachelor's Degree in Computer Science or a related discipline or equivalent experience.
• Must be fluent in written and spoken English at a native or bilingual level; client-facing daily.
• 6+ years of professional data engineering or database engineering experience on Microsoft SQL Server and Azure SQL.
• Expert-level advanced T-SQL, including window functions and query plan-aware design.
• Expert-level index design across covering, filtered and columnstore indexes with production-scale tuning.
• Experience with Flyway or equivalent versioned migration tool in CI pipelines.
• Experience with healthcare data, including claims, HIE feeds and PHI de-identification techniques.
• Working knowledge of .NET and C# sufficient to review data access layer.

Responsibilities

• Design denormalized read models and snapshot tables for low-latency access across multi-source data.
• Own index strategy and tune queries using execution plans and Query Store at production volume.
• Partner with architect on SQL Server workload management 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 refresh service levels per data source with accurate as-of dates.
• Implement de-identification and synthetic data paths to keep PHI secure.

Skills

T-SQL

Data modeling

Denormalized read models

Query optimization

English communication

Azure SQL

Education

Bachelor's degree in Computer Science or related field

Tools

Flyway

Azure Data Factory

Databricks

SQL Server

Redis

Job description

Senior SQL and Data Engineer (India Only)

About Aubrant

Aubrant Digital is a leader in multi-shore custom application development. We are passionate about solving our clients’ business problems through consultative teamwork, innovative software, and proven processes. We’ve served more than 50 clients and delivered hundreds of high quality, custom enterprise applications. Our clients value us as integral team members who get the job done on time and on spec, and we are proud of our high client retention rate and under 2% staff turnover. With offices in New Jersey, Boston, Costa Rica, and Eastern Europe, we execute the full software lifecycle, from architecture and design through development, QA and application maintenance & support. Our company culture emphasizes client service, trust-based relationships, and innovation.

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 data source, so the interface can show accurate as-of dates rather than implying real-time data.
• Implement the shared cohort and risk scoring data layer so every consuming screen reports identical values.

Data Governance and Quality:

• Own the de-identification and synthetic data generation path that keeps the offshore development environment free of protected health information.
• Deliver versioned, gated database migrations through Flyway or an equivalent tool inside the CI pipeline.
• Build data quality and reconciliation checks that catch a broken feed before a clinician sees stale data.

Qualifications:

• Bachelor's Degree in Computer Science or a related discipline, or equivalent experience.
• MUST be fluent in written and spoken English at a native or bilingual level; this role is client-facing daily.
• 6+ years of professional data engineering or database engineering experience on Microsoft SQL Server and Azure SQL.
• Expert-level advanced T‑SQL, including window functions, set‑based rewriting of procedural logic, and query plan‑aware design.
• Expert-level index design across covering, filtered and columnstore indexes, with demonstrated tuning results at production data volume.
• Strong execution plan analysis skills, plus practical use of Query Store, Extended Events, Resource Governor and readable secondaries.
• Proven experience designing denormalized read models, snapshot tables and materialized aggregates for low‑latency read paths.
• Experience with Flyway or an equivalent versioned migration tool running inside a CI pipeline.
• Experience with healthcare data, including claims, HIE feeds and pharmacy or Surescripts data, and with PHI de‑identification technique.
• Working knowledge of .NET and C# sufficient to review and influence the data access layer.
• Experience with Redis or another distributed cache sitting in front of a relational read model is a plus.
• Experience with Azure SQL Managed Instance, Azure Data Factory or Databricks is a plus.
• Excellent problem‑solving skills, with the ability to analyze complex requirements and propose innovative solutions.
• Strong communication and collaboration skills, with the ability to work effectively in a cross‑functional team environment.
• Able to build strong customer relationships and deliver customer‑centered solutions.