%3Cp class=%22MsoNormal%22%3E%3Cspan style=%22color:black;font-family:Arial, Helvetica, sans-serif;font-size:12px;%22%3EHealth 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.%26nbsp;%3Co:p%3E%3C/o:p%3E%3C/span%3E%3C/p%3E%3Cp class=%22MsoNormal%22%3E%3Cspan style=%22color:black;font-family:Arial, Helvetica, sans-serif;font-size:12px;%22%3EThis 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.%3Co:p%3E%3C/o:p%3E%3C/span%3E%3C/p%3E%3Cp class=%22MsoNormal%22%3E%3Cspan style=%22color:black;font-family:Arial, Helvetica, sans-serif;font-size:12px;%22%3EThe 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.%3Co:p%3E%3C/o:p%3E%3C/span%3E%3C/p%3E%3Cp%3E%3Cspan style=%22color:black;font-family:Arial, Helvetica, sans-serif;font-size:12px;%22%3E%3Cspan style=%22line-height:115%;mso-ansi-language:EN-US;mso-ascii-theme-font:minor-latin;mso-bidi-font-family:%26quot;Times New Roman%26quot;;mso-bidi-language:AR-SA;mso-bidi-theme-font:minor-bidi;mso-fareast-font-family:Aptos;mso-fareast-language:EN-US;mso-fareast-theme-font:minor-latin;mso-hansi-theme-font:minor-latin;%22%3EThe 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.%3C/span%3E%3C/span%3E%3C/p%3E
Supports multiple more complex services/databases; designs, develops, manages, and maintains databases. Plans and maintains database architecture and reporting. Optimizes database functions and implements integrated architecture and reporting updates. Trains and guides lower-level staff.
*!
Required skills include strong SQL Server skills with the ability to write advanced queries and excellent organizational, documentation and communication skills with proficiency in Microsoft Office. Familiarity with Execution Plans and optimization a plus. Experience with SAS, Stata, Web technologies, C#, Python, Powershell, Power BI, Snowflake, and health datasets is ideal but not required. A bachelor’s degree in computer science, Data Science or related area is preferred, or extensive experience with relational databases, stored procedures and SQL queries.
*!
Little physical effort required. Duties are primarily sedentary. May be required to move objects up to 25 pounds occasionally.
Diese Cookies sind für das Funktionieren der Website erforderlich und können in unseren Systemen nicht abgeschaltet werden. Sie können Ihren Browser so einstellen, dass er diese Cookies blockiert, aber dann könnten einige Teile der Website nicht funktionieren.
Sicherheit
Benutzererfahrung
Zielgruppenorientierte Cookies
Diese Cookies werden über unsere Website von unseren Werbepartnern gesetzt. Sie können von diesen Unternehmen verwendet werden, um ein Profil Ihrer Interessen zu erstellen und Ihnen an anderer Stelle relevante Werbung zu zeigen.
Google Analytics
Google Ads
Wir benutzen Cookies
🍪
Unsere Website verwendet Cookies und ähnliche Technologien, um Inhalte zu personalisieren, das Nutzererlebnis zu optimieren und Werbung zu indvidualisieren und auszuwerten. Indem Sie auf Okay klicken oder eine Option in den Cookie-Einstellungen aktivieren, stimmen Sie dem zu.
Die besten Remote-Jobs per E-Mail
Schliess dich über 5'000+ Personen an, die wöchentlich Benachrichtigungen über Remote-Jobs erhalten!