Data Warehousing (DW)
Welcome! This is a living document intended to capture information about how the Data Warehousing Team operates. This includes team culture as well as details about communication channels, and workflows.
About
Role
Specific mission or purpose statement for the team (e.g., "To design, build, and maintain scalable and reliable data repositories that supports all WashU's healthcare data needs.")
What we do
Detailed explanation of the team's core responsibilities and deliverables. Use bullet points or short paragraphs.
- Managing data sources
- Curating the OMOP schema
- Developing and maintaining ETL/ELT pipelines.
Team Members & Roles
| Name | Role |
|---|---|
| Snehil Gupta | Manager |
| Warren Thomas | DBA |
| Suhas Khot | Software Developer |
Norms & Culture (i.e. How We Work)
Technologies & Tools
Processes & Methodologies
- Best Practices, Guides, & Tutorials
External Engagements / Collaborations & Communications
How External Teams Engage with Us: Explain the process for other departments to submit requests, report issues, or collaborate with this specific team. (e.g., "Submit a DevOps request to X project," "Reach out via Teams channel Y.")
Getting Started (Onboarding)
Things that are specific to DW/RDC group.
- historical background
- special provisioning setups and/or tutorials
- common initial questions
- engagements and participations
- useful chats to be a part of
Important Meetings, Chats & Notes
| Name | Frequency | Time | Link | Notes |
|---|---|---|---|---|
| Datalake Infrastructure and Development Meeting | Weekly | Wednesday 3-345pm | Microsoft Teams | Agenda and Records Word Document (on Box) |
| DW Review/Demo - Data Warehousing Meeting | Bi-Weekly | Tuesday 1-2pm | Zoom | 1-1:30pm MDClone review / 1:30-2 DW Team Review |
| DW Retrospective | Bi-Weekly | Tuesday 2-230pm | Zoom | ?? |