Back to jobs

Senior SQL and Data Engineer (India Only)

Remote - india, India, Hyderabad, India

Open 3 months, first seen by us 108 days ago
Pay
Pay not listed
Work setting
Remote — work setting source
Listed location: Remote - india, India, Hyderabad, India
Work setup in the employer’s posting: Remote
From the employer’s posting
Employment
Full-time — employment source
Employment type in the employer’s posting: SALARIED_FT
From the employer’s posting

What you’ll work on

Full posting
  • Design denormalized read models and snapshot tables for a multi-source patient view

  • Own index strategy and tune queries using execution plans and Query Store

  • Build and operate ETL, change data capture and delta refresh pipelines

  • Publish a refresh service level per data source with accurate as-of dates

  • Own de-identification and synthetic data generation for the offshore dev environment

From the employer’s posting
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.
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.
Own the de-identification and synthetic data generation path that keeps the offshore development environment free of protected health information.

What you’ll bring

All qualifications

Core experience

  • Reasons about data volume and query cost before writing code
  • Rigorous about correctness and consistent values across screens
  • Explains data lineage or freshness constraints to clinicians in actionable terms
  • Treats migrations, rollback and data quality checks as part of the deliverable

Preferred experience

  • 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.
Qualification wording
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.
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.
Education & alternatives
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.

About Epic-Software

Aubrant Digital is a leader in multi-shore custom application development.

In the employer’s words · Read in context

Apply at Epic-Software

Posting record

Report an error

Open 3 monthsWe first saw this posting 108 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
Aug 5, 2026108 days ago
Recorded sightings
71
Last seen by us
Nov 21, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 108

Up longer than most. Similar jobs usually come down between day 6 and day 56.

From 14,771 similar postings that came down. Coming down is not always a hire.

Epic-Software is hiring

4 open jobs

  • No new data jobs since August
  • Its jobs tend to stay up a long time
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • C#
  • SQL
  • T-SQL
  • Azure
  • Databricks
  • Redis
  • SQL Server
Where the posting names them
- 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.
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.
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.
- 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:
- 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.
- 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.
- 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.
- 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.

Your next step

Complete your application on ats.rippling.com. The employer’s form will show what is required.

Applying through Rippling

  • “The résumé will be parsed to fill in the application details”: check what it filled before you send.

Already applied? Track this application

Job description

View original posting ↗

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?

  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 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.

 

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Remote - india, India, Hyderabad, India

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.