SQL Database Developer

Specific duties and responsibilities will include but are not limited to the following:

• 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 BI.
• 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 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