About the companyInCommon is hiring on behalf of a US-based healthcare analytics SaaS company that delivers cost transparency and advanced analytics to health plans, self-funded employers, and benefits consultants. They process complex medical, pharmacy, and eligibility datasets to power actionable insights — and operate under HIPAA and SOC2.The team is lean and technically strong. Engineers own their domain end-to-end.About the roleThis is a senior, high-autonomy role owning the data platform. You won't be working off tickets — you'll set the technical direction, identify problems before they escalate, and drive modernization independently. You receive an objective, not a step-by-step plan.The near-term priority is migrating a substantial legacy SQL Server stored procedure codebase into a modern, maintainable, testable data pipeline architecture. You'll assess the existing procedures, design the target state, and execute with minimal supervision.The work spans AWS-hosted SQL Server, AWS infrastructure, and Airflow-based ETL pipelines — supporting both internal operations and client-facing data onboarding.What you'll doAudit, document, and refactor legacy T-SQL stored procedures into modular dbt models, Python transformations, or Airflow DAGs — preserving business logic fidelity through validation frameworksDesign and maintain ETL/ELT pipelines for ingesting claims, eligibility, pharmacy, and premium datasets from diverse client sourcesOwn SQL Server administration on AWS: query tuning, index management, schema changes, backups, HA/DRBuild data validation, anomaly detection, and reconciliation checks across critical pipelinesEnforce SOC2 and HIPAA-compliant access controls, encryption, and audit loggingMaintain technical documentation — data dictionaries, lineage diagrams, runbooks — as a habit, not on requestWhat we're looking for5+ years in data engineering or senior DBA roles in production environmentsExpert-level T-SQL: complex queries, window functions, CTEs, performance tuning, execution plan analysisDemonstrated experience refactoring legacy stored procedure logic into modern pipeline architecturesProficiency in Python for ETL, pipeline components, and data validationProduction experience with Apache Airflow and dbtWorking knowledge of AWS (S3, RDS, or equivalent) and SQL Server on AWSPractical experience with SOC2 and HIPAA requirements — not just theoreticalStrong async working style; comfortable operating without daily check-insEven better if you haveSSIS experience (relevant to the legacy migration context)Background working with healthcare data (claims, eligibility, pharmacy)
Job Title
Senior Data Engineer