Senior Data Engineer (MSSQL)

About the Role
We are seeking a Senior Data Engineer to re-architect the data layer that powers our healthcare SaaS product for Skilled Nursing Facility (SNF) billing teams. Today, the system relies heavily on scraping to ingest data from third-party platforms. The next step is to transition to database dump–based ingestion and build a stable, scalable pipeline on top of it.
This is a hands-on role where you’ll reverse-engineer legacy pipelines, design a clean target model, and implement reliable ETL/ELT processes. The project will start as a full-time engagement for 1–3 months, with the possibility of transitioning into ongoing part-time support.

Key Responsibilities

• Audit and reverse-engineer current schemas and scraping-based pipelines.
• Design a normalized, well-documented target data model (OLTP/OLAP).
• Build robust ETL/ELT pipelines to process MSSQL database dumps, handling semi-structured and delayed feeds.
• Optimize database performance through indexing, partitioning, and query tuning.
• Implement monitoring, validation, and data quality checks.
• Document lineage, architecture, and processes, and transfer knowledge to the team.
   

Requirements

• 5+ years in Data Engineering with strong MSSQL/T-SQL expertise.
• Experience transitioning from scraping/legacy data ingestion to DB-driven pipelines.
• Strong data modeling skills (3NF, star, snowflake).
• Hands-on experience with SQL and Python for ETL/ELT.
• Familiarity with orchestration, versioning, and testing (Airflow/Dagster/SSIS, Git, CI/CD).
• Ownership-driven, proactive, and comfortable with ambiguous data sources.
   

Nice to Have

• Experience with dbt or similar frameworks.
• Exposure to healthcare or billing system integrations.
• Familiarity with data warehousing and performance benchmarking.