Overview
On Site
Full Time
Skills
Science
Research
Analytical Skill
Data Warehouse
Optimization
Query Optimization
Performance Monitoring
Microsoft SQL Server
Writing
Database Administration
Communication
Documentation
Microsoft Azure
Amazon Web Services
Snow Flake Schema
NoSQL
Job Details
Health Sciences Research IT is seeking a DBA/Datawarehouse Architect to join our team serving the schools of the health sciences. The candidate will work with other team members and research groups to design pipelines for data ingestion/transformation and implement the designs and execute them.
This will be for ingesting thousands of files and others single large files in various formats. They will help support a large number of different research groups on many projects. The candidate will support with the teams to understand the data query requirements to optimize query performance with indices/views/functions etc. and be able to create analytic files based on specifications provided.
The candidate must understand data warehousing concepts. The candidate will be responsible for DBA functions as well such as permissions, optimization, query optimization, performance monitoring, etc. Our team has a great mix of junior and experienced people.
The ideal candidate will have three or more years of experience working in a MS SQL Server environment in both writing data ingestion pipelines/jobs as well as database administration. The candidate must have strong communication and documentation skills. Data experience in Azure, AWS, Snowflake, and NoSQL as well as experience with EHR and claims data is preferred but not required.
This will be for ingesting thousands of files and others single large files in various formats. They will help support a large number of different research groups on many projects. The candidate will support with the teams to understand the data query requirements to optimize query performance with indices/views/functions etc. and be able to create analytic files based on specifications provided.
The candidate must understand data warehousing concepts. The candidate will be responsible for DBA functions as well such as permissions, optimization, query optimization, performance monitoring, etc. Our team has a great mix of junior and experienced people.
The ideal candidate will have three or more years of experience working in a MS SQL Server environment in both writing data ingestion pipelines/jobs as well as database administration. The candidate must have strong communication and documentation skills. Data experience in Azure, AWS, Snowflake, and NoSQL as well as experience with EHR and claims data is preferred but not required.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.