Sign upLog in

Senior Data Developer

DP Professionals

Cayce, SC(remote)

Apply
JOB DETAILS
SKILLS
Automation, Best Practices, Centers for Disease Control and Prevention (CDC), Communication Skills, Data Analysis, Data Formats, Data Import/Export, Data Management, Data Migration, Data Processing, Data Sets, Data Visualization, Data Warehousing, Database Administration, Database Extract Transform and Load (ETL), Database Management Software/Systems (DBMS), Debugging Skills, Disease Investigation, Documentation, Editing, Functional Requirements Document (FRD), Gap Analysis, HIPAA (Health Insurance Portability and Accountability Act), HIV/AIDS (Acquired Immune Deficiency Syndrome), HL7 (Health Level 7), Help Data Formats, Identify Issues, Industry Standards, Interpersonal Skills, Mentoring, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Onboarding, People Management, Presentation/Verbal Skills, Problem Solving Skills, Procedure Development, Process Development, Production Control, Public Health, Query Optimization, Relational Databases (RDBMS), Requirements Management, Research Skills, SOAP (Simple Object Access Protocol), SQL (Structured Query Language), SQL Server Integration Services (SSIS), Security Compliance, Server Support, Software Upgrades, Statistical Analysis System (SAS), Stored Procedures, System Integration (SI), Team Player, Technical Leadership, Time Management, Validation Testing, Writing Skills, XML (EXtensible Markup Language)
LOCATION
Cayce, SC(remote)
POSTED
4 days ago
DPP is seeking a Senior Data Developer for an opportunity to help support public health technology in South Carolina.
 
Work location: Remote; must be comfortable working East coast hours
Duration: 12 months
Terms: W2 contract
 
Position description:
  • A Senior Data Developer is needed to support the STD / HIV program area. Project work includes transition from the 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.
  • The Data Developer will work closely with members of the Systems Integration, Health Data Visualizations, and Database Administration teams as well as STD / HIV program staff.
  • This position will be a part of the team responsible for supporting critical systems and environments used by the STD HIV team, the Public Health Lab, and Disease Surveillance.
  • 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. 
Duties and responsibilities include, but aren’t limited to:
  • 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 
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 with 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&R Studio 
Additional skills:
  • 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
  • Solid background in data integration, staging, quality and distribution
  • Excellent written, oral, and interpersonal communication skills 
Interested? Learn more:
Click the apply button or contact our recruiter Mike at Mike.Strain@dppit.com to learn more about this position (#26-00689).

Authorized US Worker - US Citizens and those authorized to work in the US are encouraged to apply. We are unable to sponsor at this time. EOE/AA/V/D

DPP offers a range of compensation and benefits packages to our employees and their eligible dependents. Call today to learn more about working with DPP.


 

About the Company

D

DP Professionals