RRemoteville
BuzzClan logoBuzzClan

SQL Database Developer

Skills
ETL ToolsMicrosoft SQL ServerSQL Server Integration ServicesData WarehousingDatabasesDisease ManagementElectronic Health Records
Role

What the job involves

The main requirements, responsibilities and hiring steps.

Requirements

  • 3+ years of MS T-SQL experience including stored procedures advanced queries and optimization
  • 3+ years of ETL process development experience
  • 1+ year of SQL Server Integration Services SSIS experience
  • 3+ years of report development experience
  • 3+ years of data warehousing and relational database experience
  • 1+ year of experience with HL7 v2.3.1 to 2.5.1 and ORU messages
  • 3+ years of XML experience
  • 3+ years of MS SQL Server 2016+ experience
  • 1+ year of security and data classification experience related to CDC HIPAA CJIS PHI and PII

Nice to have

  • Large data sets
  • Requirements gathering
  • Documentation
  • Public health systems
  • Statistical analysis
  • LOINC
  • SNOMED
  • FASTQ files
  • Demultiplexing
  • R Studio

Day to day

  • Develop and optimize MS T-SQL stored procedures and advanced queries to support reliable database operations.
  • Build and maintain ETL processes and SQL Server Integration Services pipelines for structured healthcare data.
  • Create reports and work with data warehouses and relational databases while handling HL7, XML, and large data sets.