What are the responsibilities and job description for the Senior SQL Database Developer & ETL Project Lead position at Stellar Professionals LLC?
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.