SQL Database Developer & ETL Project Lead

Stellar Professionals

Cayce, SC, United States

about 2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

3 years minimum

Working hours

Regular working hours

Job source

dice.com

Tech stack

Data Files Data Integration Extract Transform Load (ETL) Data Migration Data Systems Data Warehousing Relational Databases Software Debugging Microsoft SQL Server Parsing Query Optimization SAS (Software)

+10 more

SQL Stored Procedures SQL Server Integration Services Data Streaming Transact-SQL Extensible Markup Language (XML) Data Processing Scripting Data Classification Health Level Seven International Data Pipelines

Job description

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.

Requirements

We are looking for a self-motivated technical lead to drive critical data migration and infrastructure modernization projects., * 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+)., * 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.