Salary:
Seeking a SQL Database Developer with 3+ years of MS T-SQL, ETL process development, XML and SQL Server 2016+ for a long-term REMOTE assignment with our client in Columbia SC!
W2 Direct Hire Contract Position. No C2C or 1099 candidates please.
What will you do in this role:
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 standard
Required Education/Experience:
- 3+ Years of Experience with MS T-SQL (Stored Procedures, Advanced Queries, Optimization)3+ Years of Experience with ETL Process Development1+ Year of Experience with SQL Server Integration Services (SSIS)3+ Years of Experience with Report Development3+ Years of Experience with Data Warehousing & Relational Databases3+ Years of Experience with XML3+ 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 & DocumentationPublic Health / Disease Surveillance Systems ExperienceStatistical Analysis System (SAS)LOINC / SNOMEDFASTQ Files and DemultiplexingR&R Studio