Database Developer (SQL) - Contract - Remote

Database Developer (SQL)
Location:Remote

Interview Process:1 Round of Virtual Interviews

Duration:12Months
Employment Type: Contract
Experience Required: 07+ Years

Project Scope:

Seeking an experienced Database Developer(SQL) to support critical public health data initiatives, including datawarehouse modernization, data pipeline enhancements, disease surveillancesystem integrations, and electronic case reporting (eCR) solutions. Theconsultant will play a key role in designing, developing, optimizing, andsupporting complex database solutions, ETL processes, reporting systems, anddata migration initiatives.

The ideal candidate will have strong expertisein SQL Server, T-SQL development, ETL processes, SSIS, data warehousing,healthcare data integrations, and large-scale data management. This rolerequires close collaboration with database administrators, data integrationteams, business stakeholders, and technical teams to deliver secure, scalable,and reliable data solutions.

Key Responsibilities:

• Design, develop,and maintain complex database solutions and data integration processes.
• Develop andoptimize SQL stored procedures, advanced queries, and database performance.
• Design, build,and support ETL processes and data pipelines.
• Develop,troubleshoot, and maintain SQL Server Integration Services (SSIS) packages.
• Support datawarehouse initiatives, reporting solutions, and business intelligencerequirements.
• Convert andmodernize legacy data processes, including migration of SAS-based solutions.
• Create andmaintain process documentation, data flow diagrams, and technicalspecifications.
• Gather businessrequirements and perform gap analysis with stakeholders.
• Support diseasesurveillance systems, electronic case reporting (eCR), and healthcare dataintegrations.
• Parse and processmultiple data formats including XML, CSV, SOAP, and HL7 messages.
• Support datamigrations, testing, validation, deployment, and post-production supportactivities.
• Monitor andtroubleshoot production data processing and integration workflows.
• Implementautomation solutions to improve efficiency, reliability, and data quality.
• Assist with dataclassification, security compliance, and regulatory requirements.
• Provide technicalleadership, best practices, mentoring, and guidance to team members.
• Collaborate withvendors, business users, and technical teams to deliver project objectives.

Required Skills & Experience:

• 3+ years ofexperience with Microsoft SQL Server T-SQL development.
• Strong expertisein stored procedures, advanced queries, debugging, and performanceoptimization.
• 3+ years ofexperience with ETL process development.
• 1+ year ofexperience with SQL Server Integration Services (SSIS).
• 3+ years ofexperience with report development and reporting solutions.
• 3+ years ofexperience with data warehousing and relational database design.
• 1+ year ofexperience working with HL7 v2.x messaging standards, including ORU messages.
• 3+ years ofexperience processing XML and structured data formats.
• 3+ years ofexperience supporting Microsoft SQL Server 2016 or higher.
• Experience withhealthcare data security requirements including HIPAA, PHI, PII, and relatedcompliance standards.
• Strong experiencein database troubleshooting, performance tuning, and process automation.

Preferred Skills:

• Experiencemanaging and processing large-scale datasets exceeding 1TB.
• Requirementsgathering, business analysis, and technical documentation experience.
• Public health,healthcare, or disease surveillance systems experience.
• Experience withStatistical Analysis System (SAS).
• Knowledge ofLOINC and SNOMED healthcare standards.
• Experienceworking with FASTQ files and demultiplexing processes.

·Experience with Rand RStudio.

• Familiarity withElectronic Disease Surveillance Systems (EDSS), eHARS, CDC reporting systems,or similar healthcare platforms.
• Experience withElectronic Case Reporting (eCR) integrations and workflows.
• Power BIreporting and dashboard development experience.

Education
Bachelor’s Degree in Computer Science, Information Technology, Data Management,or a related field, or equivalent combination of education and professionalexperience.

Technical Environment

·Microsoft SQLServer 2016+

·T-SQL

·SQL ServerManagement Studio (SSMS)

·SQL ServerIntegration Services (SSIS)

·ETL and DataPipeline Development

·Data WarehousingSolutions

·Power BI

·HL7 v2.xMessaging

·XML, CSV, SOAP

·Healthcare DataExchange Systems

·SAS

·Electronic CaseReporting (eCR)

Originally posted on