SQL Database Developer

novalink Solutions llc
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Remote

Tech stack

Big Data
ETL
Data Warehousing
Relational Databases
Software Debugging
Multiplexing
Microsoft SQL Server
Parsing
RStudio
SAS (Software)
SQL Stored Procedures
SQL Server Integration Services
T-SQL
XML
Data Processing
Data Classification
Performance Monitor
Health Level Seven International
Data Pipelines

Job description

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.

Requirements

  • 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

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

Apply for this position