Senior Data Engineer
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Senior Data Engineer (MSSQL) on a contract basis, remote for 1–3 months, with a pay rate of "unknown." Requires 5+ years in Data Engineering, MSSQL expertise, and experience with ETL/ELT processes, particularly in healthcare.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
-
🗓️ - Date discovered
September 12, 2025
🕒 - Project duration
1 to 3 months
-
🏝️ - Location type
Remote
-
📄 - Contract type
Unknown
-
🔒 - Security clearance
Unknown
-
📍 - Location detailed
United States
-
🧠 - Skills detailed
#Monitoring #"ETL (Extract #Transform #Load)" #Data Ingestion #dbt (data build tool) #Scala #SQL (Structured Query Language) #Airflow #SSIS (SQL Server Integration Services) #Indexing #Database Performance #GIT #Data Modeling #Python #SaaS (Software as a Service) #Data Engineering #Data Quality #Snowflake
Role description
Senior Data Engineer (MSSQL)
Contract, Remote
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.
About the Company
We are a healthcare SaaS company with a global engineering team. We move quickly, value clarity and ownership, and equip engineers with premium tools to deliver high-impact work.
Senior Data Engineer (MSSQL)
Contract, Remote
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.
About the Company
We are a healthcare SaaS company with a global engineering team. We move quickly, value clarity and ownership, and equip engineers with premium tools to deliver high-impact work.
