Description

*) 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
*) Help to perform and automate daily maintenance processes
*) Debug, troubleshoot, and optimize new and existing processes.
*) Resolve processing issues.
*) Support related server, database, software upgrades, and new environment configuration
*) Ensure maximum system uptime for critical components to ensure business continuity.
*) Advise the Team on best practice and techniques. Mentor team and staff on advanced topics.
*) Modification / rewrite of existing processes and creation of new processes to be compliant with agency security requirements and following industry best standards
 
Required Skills:
*) 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

Environment / Tools:
*) Microsoft SQL Server (2016+), TSQL, SSMS
*) SQL Server Integration Services (SSIS) and ETL/Data Pipeline development
*) Data Warehousing environments and reporting tools (e.g., Power BI)
*) HL7 v2.x (including ORU), XML, CSV, and other structured data formats
*) Healthcare/public health data systems (e.g., EDSS, eHARS, CDC reporting systems)
*) Electronic Case Reporting (eCR) and data exchange integrations
*) SAS (legacy processes) and scripting for data transformation
*) HIPAA, PHI/PII, and CDC data standards and security compliance

Key Skills

Education

Bachelor's degree