Senior SQL Database Developer & ETL Project Lead
Posted Today by Stellar Professionals LLC
Negotiable
Undetermined
Remote
Remote or Cayce, South Carolina
Summary: The role of Senior SQL Database Developer & ETL Project Lead involves leading critical data migration and infrastructure modernization projects. The position requires a self-motivated individual with expertise in SQL and ETL processes, focusing on designing and automating high-volume data solutions. The candidate will also be responsible for converting legacy systems and ensuring system integrity in production environments. This is a fully remote position requiring alignment with EST working hours.
Key Responsibilities:
- Design, develop, and automate high-volume ETL solutions and data streams.
- Convert legacy SAS code and queries into optimized SSIS packages and modern reporting dashboards.
- Extract and process complex healthcare data structures including XML, CSV, and HL7 messages.
- Proactively monitor production environments to maximize system uptime and troubleshoot data processing issues.
Key Skills:
- Advanced querying, stored procedures, and query optimization in SQL Server & T-SQL (3+ years).
- Robust data integration, staging, quality, and pipeline development in ETL (3+ years).
- Strong data warehousing concepts using MS SQL Server 2016+ (3+ years).
- Professional experience parsing XML (3+ years) and HL7 v2.x / ORU Messages (1+ year).
- Practical development, debugging, and optimization in SSIS (1+ year).
- Clear understanding of data classification standards (HIPAA, PHI, PII) (1+ year).
Salary (Rate): undetermined
City: Cayce
Country: United States
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
We are looking for a self-motivated technical lead to drive critical data migration and infrastructure modernization projects.
Role Details
- Position: Database Developer (SQL) - Project Lead
- Work Arrangement: 100% Remote (Must be comfortable working EST hours)
- Location: Cayce, SC
- Interview Process: 1 Round of Virtual Interviews
Core Responsibilities
- Data Pipelines: Design, develop, and automate high-volume ETL solutions and data streams.
- Legacy Modernization: Convert legacy SAS code and queries into optimized SSIS packages and modern reporting dashboards.
- Data Parsing: Extract and process complex healthcare data structures including XML, CSV, and HL7 messages.
- System Integrity: Proactively monitor production environments to maximize system uptime and troubleshoot data processing issues.
Key Skills Required
Primary Technical Stack (Required):
- SQL Server & T-SQL: Advanced querying, stored procedures, and query optimization (3+ years).
- ETL & Staging: Robust data integration, staging, quality, and pipeline development (3+ years).
- Relational Databases: Strong data warehousing concepts using MS SQL Server 2016+ (3+ years).
- Data Formats: Professional experience parsing XML (3+ years) and HL7 v2.x / ORU Messages (1+ year).
- SSIS & Reporting: Practical development, debugging, and optimization in SSIS (1+ year).
- Compliance: Clear understanding of data classification standards (HIPAA, PHI, PII) (1+ year).
Preferred Extensions (Bonus Skills):
- Legacy SAS code conversion and scripting.
- Experience with Public Health or Disease Surveillance data systems.
- Familiarity with clinical coding standards (LOINC / SNOMED).
- Handling massive data sets (1 TB+).
Candidate Profile
- Exceptional communication skills with the ability to bridge technical gaps between peers, vendors, and end-users.
- Comfortable working under limited supervision to research, design, and specify data flows independently.
- Pre-employment compliance includes standard 7-year background/credit screenings and a drug-free affidavit.