Data Warehouse Architect / Manager

Location: San Francisco, CA
Job Title:  Data Warehouse Architect / Manager
 
The Data Warehouse Architect / Manager is responsible for overseeing and supporting the current and future state of the enterprise Data Warehouse including:  data integration, data governance needs, reporting, analytics.  The Architect works with other data groups to develop   strategy, technical solution and implementation roadmap. For the management aspect of the job the DWAM is responsible for the ongoing and daily operational support needs of the Enterprise Data Warehouse (EDW)
 
They will also provide architecture designs to store data at every step of data warehousing and business intelligence process from the external data sources to operational systems to the analytic applications and designs central repository of detailed, historical and enterprise-wide information from various database platforms and external data sources. Following data management best practices the DWAM implements operational workflows needed to support, robust data flows of accurate and timely data assets and products. Partners with engineers and data scientists in large initiatives ensuring accurate interpretation of data domains and minimizing tech debt.
 
Deliverables
-   Work with data management and data engineering groups in both new development of data assets and maintenance of existing ones.
-   Execute high quality data integrations, migrations, and submissions to ensure on-time delivery of accurate data with minimal tech-debt.
-   Alongside data engineering and data science, manage DWH and reporting views of the data to keep concepts up-to-date and remove redundant, obsolete, or trivial data.
-   Implement and maintain high level of data quality monitoring across all stages of the data lifecycle.
-   Monitor data quality and timeliness working with operational and technical teams to resolve issues.
-   Develop an understanding of the data along with the operations and industry concepts/regulations that under pin it in service of successful implementations in large data focused initiatives.
 
Requirements:
-   3+ years of experience working with databases and driving data reliability, quality or data driven insights.
-   Advanced SQL skills and have some experience with Python or similar general programming language or scripting.
-   Familiar with concepts of data architecture and data governance, master data management and data warehouses design.
-   Experienced working with real-world data, value and understand the importance of data quality, and are comfortable cleaning datasets.
-   Excellence in working with different stakeholders to build ecosystems of data sets and tools to meet the needs of the business.
-   Experience in medical informatics or have worked with healthcare data - clinical, insurance, or benefits focused
- Familiar with the regulations or standard file formats that under pin it.
Experience in Medicare an extra bonus.
 
or
this job portal is powered by CATS