Senior SQL & Data Engineer - Low-Latency Data Platform

Epic Software; United States; A distancia; USD 120.000 - 180.000; Jornada completa

Descripción de la vacante

Aubrant is seeking a Senior SQL and Data Engineer to own the data tier across the platform. You will design denormalized read models, snapshot tables, and refresh pipelines that handle EHR, HIE, claims, and pharmacy feeds with published freshness guarantees.

You will manage de-identification paths, responsible for synthetic data and data quality checks while supporting offshore development under governance.

Formación

• Bachelor's Degree in Computer Science or 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 set-based design.
• Expert-level index design across covering, filtered and columnstore indexes, with production-scale tuning.
• Strong execution plan analysis skills and practical use of Query Store, Extended Events, Resource Governor.

Responsabilidades

• Design denormalized read models and snapshot tables for a multi-source patient view.
• Own index strategy and tune queries at production volume.
• Partner on SQL Server workload management and readable secondary routing.
• Build and operate ETL, change data capture and delta refresh pipelines across data sources.
• Define and publish refresh service levels per data source, ensuring correct as-of dates.

Conocimientos

SQL Server

Azure SQL

T-SQL

Query Store

Index design

Denormalized read models

Educación

Bachelor's Degree in Computer Science or related field

Herramientas

Flyway

CI/CD

Descripción del empleo

Aubrant is seeking a Senior SQL and Data Engineer to own the data tier across the platform. You will design denormalized read models, snapshot tables, and refresh pipelines that handle EHR, HIE, claims, and pharmacy feeds with published freshness guarantees.

You will manage de-identification paths, responsible for synthetic data and data quality checks while supporting offshore development under governance.