About the role
We build software for US healthcare providers, and it runs on data from their clinical record systems. As a Data Engineer, you will own how that data reaches us. You will connect new data sources, capture every change, and turn raw tables into clean, trusted data that our products and services use. This is hands-on engineering on a production platform that handles patient data, so correctness and security matter as much as speed.
What you will do
- Bring new data sources online. Connect to client EHR databases, set up change capture, and add freshness checks to every feed.
- Build and run incremental pipelines in Python and Dagster, starting with a full load, then loading only what changed.
- Turn raw tables into clean, query-ready tables.
- Keep the data streams that downstream services read fast and correct, using cursors, indexes and partitions.
- Build data-quality checks: reconcile row counts, detect schema changes, handle late-arriving data, and alert on stale feeds.
- Tune SQL, indexes and query plans on PostgreSQL and SQL Server, and keep cloud costs sensible.
- Own your pipelines in production. Manage the infrastructure as code, deploy through CI, write runbooks, and fix what breaks.
Tech stack
Python, SQL, Dagster, PostgreSQL, SQL Server, S3 with Parquet and Iceberg, DuckDB, AWS (EKS, RDS), Terraform, Argo CD, Prometheus and Grafana, GitHub Actions, and a bit of Java.
What we look for
- 3–6 years building and running production data pipelines.
- Strong Python and advanced SQL: window functions, query plans, indexing.
- Working knowledge of T-SQL and SQL Server.
- Incremental loads or CDC done for real: watermarks, idempotent upserts, backfills, schema changes.
- A workflow orchestrator in production: Dagster, Airflow or Prefect.
- AWS (S3, RDS, IAM) and columnar formats such as Parquet.
- Docker, Git, and automated tests for data code.
- Clear written English. You write down how things work and why.
Nice to have
- Startup experience: comfortable with ownership, ambiguity and shipping fast without cutting corners.
- US healthcare experience: HIPAA/PHI handling, EHR integrations, or MDS / PDPM / post-acute care.
- Experience evaluating AI output at scale: test sets, accuracy metrics and regression tracking.
- CI/CD with GitHub Actions; observability with Prometheus, Grafana or Loki.
Work arrangement
- This is an in-office role at our Faridabad office, five days a week. Remote work is only by exception, when a situation genuinely requires it.
- Candidates must be based in or near Faridabad / Delhi NCR, or willing to relocate before joining.
Why join us
- Work at the cutting edge of AI-assisted software engineering, on real production systems.
- Real ownership of software used by care teams in US facilities.
- Hard, meaningful problems: clinical correctness, AI grounded in evidence, and getting the details right.
- A small, senior team where your work is visible from day one.
About AsterMed Technologies
AsterMed Technologies is a healthcare technology company in Faridabad. We build and run software, data platforms and AI-assisted tools for healthcare organisations, with careful engineering and close attention to data security.