SQL Database Developer

Basic Qualifications:

• 3+ Years of Experience with MS T-SQL (Stored Procedures, Advanced Queries, Optimization)
•  3+ Years of Experience with ETL Process Development
• 1+ Year of Experience with SQL Server Integration Services (SSIS)
•  3+ Years of Experience with Report Development
•  3+ Years of Experience with Data Warehousing & Relational Databases
• 1+ Year of Experience with HL7 v 2.3.1 - 2.5.1 and ORU Messages
•  3+ Years of Experience with XML
•  3+ Years of Experience with MS SQL Server 2016+
• 1+ Year of Experience with security and data classification related to CDC, HIPAA, CJIS, PHI, PII

Preferred Skills:

•  Ability to manage large data sets (1 TB+)
•  Requirements Gathering & Documentation
•  Public Health / Disease Surveillance Systems Experience
• Statistical Analysis System (SAS)
•  LOINC / SNOMED
• FASTQ Files and Demultiplexing
• R&R Studio

• Prepare and maintain process documentation, data flows, and diagrams for assigned processes (new and existing).
• Work with end users to perform gap analysis, gather and document functional requirements, and create necessary processes
• Assist with project and time management including estimates and status reporting
• Ability to plan, organize, review, and implement associated project milestones to completion.
• Process Development, Process Automation, and ETL Solutions
• SQL stored procedure creation, advanced query design, debugging, and optimization (MS T-SQL)
• Rewriting of SAS code into SSIS Packages and Power B.I.; SSIS Debugging, Rewriting and optimization of remaining SAS code and queries as needed.
• Data Pipeline and Reporting Development, Modification, Improvement, and Monitoring
• Help format and automate data uploads into the Data Warehouse and Disease Surveillance Systems like CDC SAMS / eHARS and the new Electronic Disease Surveillance System (EpiTrax)
• Parsing of multiple data formats including xml\\\, csv, SOAP, HL7
• Assist with system, data and database migrations and related changes, testing, and validation
• Help with eCR solutions including condition authoring, data import and utilization, process automation and troubleshooting, and data review, analysis, and reporting
• Monitor production processing to ensure proper data flow and response times