Database Developer - SQL Developer

Role: SQL Developer

Location: Remote

Interview Process: 1 Round of Virtual Interviews

Duration of the Contract: 12 Months

Possibility for Extension: No, this is a project-based position.

Work Location: The role is 100% remote.

Candidate location: No SC residency required. Open to Nationwide Candidates that are comfortable working EST Hours.

W2 Contract

IMPORTANT INFORMATION: This position requires the candidate to be engaged exclusively on Maxpath Technologies’ W2 payroll. Engagements via 1099 or third-party/sub-vendor or Corp-to-Corp arrangements are not accepted.

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

The candidate will work closely with the Systems Integration Section Manager and Project Manager(s) to identify, prioritize, and schedule workload and implementation to I. T. standards and procedures. The candidate will also work closely with customers and subject matter experts on process design, migration to the platforms, and testing.

Required Skills (rank in order of Importance):

1. 3+ Years of Experience with MS T- SQL (Stored Procedures, Advanced Queries, Optimization)

2. 3+ Years of Experience with ETL Process Development

3. 1+ Year of Experience with SQL Server Integration Services (SSIS)

4. 3+ Years of Experience with Report Development

5. 3+ Years of Experience with Data Warehousing & Relational Databases

6. 1+ Year of Experience HL7 v 2.3.1 -

2.5.1 and ORU Messages

7. 3+ Years of Experience with XML

8. 3+ Years of Experience with MS SQL Server 2016+

9. 1+ Year of Experience with security and data classification related to CDC, HIPAA, CJIS, PHI, PII

Preferred Skills (rank in order of Importance):

1. Ability to manage large data sets (1 TB+)

2. Requirements Gathering & Documentation

3. Public Health / Disease Surveillance Systems Experience

4. Statistical Analysis System (SAS)

5. LOINC / SNOMED

6. FASTQ FILES AND

DEMULTIPLEXING

7. R & RStudio

Environment / Tools

• Microsoft SQL Server (2016+), T- SQL, 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