Database Developer (SQL)
Skills
Warehouse OperationsAnalytical SkillsData AnalyticsData ExchangeData WarehousingDatabasesHealthcare
What the job involves
The main requirements, responsibilities and hiring steps.
Requirements
- MS SQL Server 2016 or newer experience
- Strong T-SQL stored procedure and query optimization skills
- ETL and SSIS experience
- Relational database and data warehousing knowledge
- Experience handling HL7 v2.3.1 to 2.5.1 and ORU messages
- XML data exchange and integration experience
- Knowledge of CDC HIPAA CJIS PHI and PII compliance
- Ability to manage large datasets 1 TB+
- Requirement gathering and technical documentation skills
- Experience with public health or disease surveillance systems preferred
- SAS experience preferred
- LOINC and SNOMED terminology experience preferred
- Experience with FASTQ files and demultiplexing preferred
- R or R Studio experience preferred
Nice to have
- Analytical
- Detail-oriented
- Collaborative
- Healthcare-focused
- Data-driven
Day to day
- Develop and optimize MS T-SQL stored procedures advanced queries and performance tuning
- Design and implement ETL processes for data integration and transformation
- Work with SQL Server Integration Services (SSIS) for data movement workflow automation and support healthcare data initiatives