Novalink Solutions LLC Jobs

Database Developer (SQL) - Project Lead

Novalink Solutions LLC

Database Developer (SQL) - Project Lead

Posted Yesterday

Be an Early Applicant

Cayce, SC, USA

In-Office

Mid level

Artificial Intelligence • Information Technology • Professional Services • Consulting

The Role

Lead design and development of ETL processes, SSIS packages, T-SQL stored procedures, and data pipelines for STD/HIV and surveillance systems. Perform migrations, parsing (HL7, XML, CSV), reporting (Power BI), testing, validation, monitoring, optimization, and documentation while ensuring CDC/HIPAA compliance and mentoring team members.

Summary Generated by Built In

we're committed to fostering

healthy lives and communities. Our team of over 2,900 professionals operates across 70 offices

statewide, boasting a rich diversity of talent united by a shared dedication to impactful work.

As stewards of public health, we have a proud history of attracting and retaining top-tier

individuals who seek fulfilling careers that directly impact people's well-being.

We're on the lookout for self-driven individuals who thrive in collaborative settings, capable of

working autonomously while also being responsive to priority tasks. Crucially, candidates must

excel at cultivating effective relationships with colleagues from various backgrounds and

across all levels of the organization. Join us in making a meaningful difference in South

Carolina's health and environment.

Why is this position open (new role, increased workload, new dept, resignation,

promotion)?

If backfill Position – What separated the candidate you initially selected from all the other

resumes presented?

This opening is a new program specific position to support the technical needs of our STD HIV

staff. Some current projects include data migrations to our replacement Electronic Disease

Surveillance System (EDSS), ongoing Data Warehousing project, upcoming eCR projects, and

general Data Pipeline improvements and monitoring. The position may also support related

Lab and Disease Surveillance systems and help with CDC Data Modernization Efforts.

Scope of the project:

Candidates should be self-motivated, team-oriented, work under limited supervision, and

respond to priority tasks. Candidates must be able to independently research and design

processes, create specifications, develop, lead testing, perform code reviews, actively engage

with the team and stakeholders, attend meetings, provide guidance, and respond promptly.

A Senior Data Developer is needed to support the STD / HIV program area. Project work

includes transition from our current to replacement Electronic Disease Surveillance System

(EDSS), the continuing Data Warehousing project, Data Pipeline improvement, and supporting

new solutions for eCR onboarding and utilization. This need includes requirements gathering

with customers, providing technical advice, time and effort estimates, and project

documentation including status reporting. Expected work includes process development and

automation, ETL solutions, advanced querying, stored procedure creation, parsing various data

formats including xml and HL7, SSIS development and debugging, and reporting. The

developer will help with testing, validations, user acceptance testing, deployment, and post

implementation support. Continued support will consist of modifications to include new data

elements. Ensure systems are following industry best practices to ensure strategic initiatives

and compliance with federal and state regulatory laws and ensure business continuity. The

candidate may also provide proactive monitoring processes for immediate identification and

resolution of data processing issues.

This position will be a part of the team responsible for supporting critical systems and

environments used by our STD HIV team, the Public Health Lab, and Disease Surveillance.

Position: Database Developer (SQL) - Project Lead

Start Date:

immediately

Duration:

12 months

Possibility of

Extension?

Public Sector/Gov’t

Experience

Required?

Preferable

Pre-employment Checks (drug, credit, criminal, motor vehicle)?

Credit-7-year history; Criminal background check- 7 year history; E-Verify, Confidentiality

Agreement, Drug-Free Affidavit, Business Associate Agreement

Daily Duties / Responsibilities:

The candidate will work closely with members of the Systems Integration, Health Data

Visualizations, and Database Administration teams as well as STD / HIV program staff.

The candidate should be self-motivated and team-oriented, work under limited supervision, and

respond to priority tasks. The candidate must be able to independently research and design

processes, create specifications and data flows, develop ETL processes, make stored

procedures, advanced queries, and reports, assist with validations, actively engage with the

Team and stakeholders, attend meetings, provide guidance, and respond promptly.

Participate in a team comprised of DPH and solution implementation staff providing STD HIV

system and data migration support, data pipeline improvement and monitoring, data

warehousing and reporting. New solutions for eCR onboarding, import and utilization will be

included. Work can consist of planning, design, configuration, process development, SSIS and

script coding, and automation of data flows. Will coordinate with the assigned IT Section

Manager and Team Lead on daily assignments/tasks. Will coordinate and collaborate with

contract and vendor staff, existing DPH staff, and other I. T. professionals working with the

Office of Information Technology. Ensure assignments are completed accurately and on time,

assist with problem resolution, mitigate issues, provide solutions, communicate, and escalate as

needed to management, and report progress to the manager.

Will advise staff on code conversions, database and query design, optimization, process

improvements and automation, validations, reporting, and report creation. Work with vendors

and staff on deliverables, debugging, and converting current processes to SSIS and PowerBI.

This includes rewriting existing SAS solutions to conform to best practices and updated coding

standards and improving efficiency, performance, and maintenance.

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 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

SCDPH will utilize this position for 40 hours per week for the project’s duration. In general,

standard weekday work hours are expected. The selected candidate may be able to work

flexible hours during the week for the purpose of providing coverage on weekends when

necessary and preapproved. Total week hours (to include the weekend) should not exceed 40

unless approved in advance (i.e., hours worked on Saturday and/or Sunday would be deducted

from hours worked Mon-Fri). This position would need to be available to support critical

systems during business hours, on off-hours, and weekends.

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.

This will also include compliance with DPH security policy/procedures and integrating

systems, when possible, to streamline staff workflows, user security, data analytics, and

reporting.

Module support of the project.

• DPH will require that selected personnel sign the DPH confidentiality agreement

and/or Business Associate (BA) agreement if applicable. All web services must be

secure.

• DPH will not accept any offers including an “up-lift” charge. The rate paid per

consultant must not exceed the maximum rate established for this position described in

the State contract terms.

• Follow agency IT Standards, policies, and procedures to include documentation.

• All source code (compiled and un-compiled) will become the sole property of the

South Carolina Department of Public Health. Any source code, data, product, or

functionality resulting from this SOW or previously owned/developed by DPH will

remain the sole property of DPH and is not to be incorporated into the core product of

any vendor's application. Any modifications and interfaces developed under said

contract will not be used by the contractor for any independent project of the

contractor or published or publicized by the contractor without written permission of

DPH.

• DPH has the final say on all programming choices.

Payment Schedule:

The State will not pay any extra costs (i.e. Travel, employee benefits, insurance, room and

board, etc.) for temporary employees under this contract.

DPH Support:

DPH will provide:

• All required information including formulas, data, and mechanisms to check output.

• Staff to assist with any application or data questions.

• Conference rooms and scheduling for any application demos.

• A virtual workstation with required software.

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

Additional Skills (rank in order of Importance)

1. Ability to deal effectively with the needs of technical peers, technical and user

management, users, vendors, and staff members, and to communicate clearly and

effectively in spoken and written form

2. Solid background in data integration, staging, quality and distribution

3. Excellent written, oral, and interpersonal communication skills

Requirements

Skill Type

Skill Name