PROJ013458 CDHS_OBH Data Warehous
Apply NowCompany: Advance American Tech, Inc.
Location: Denver, CO 80219
Description:
This project is to provide services to build an Operational Data Store as well as a Data Warehouse using existing data sources. The project will require expertise in Mulesoft, SQL Server Enterprise and Tableau. The deadline for completing the project will be Mid April.
Number Name of Task Deliverables Start Date End Date 1 Data Mapping and Analysis Source to target mappings for ODS and Data Warehouse, ODS Design and Warehouse Design 11/18/2019 12/4/2019 2 ETL to Staging/ODS ODS system in place and ready for review (code, technical, security) 1/2/2020 2/2/2020 3 ETL to Warehouse Data Warehouse system in place and ready for review (code, technical, security) 2/3/2020 3/20/2020 4 Testing Test Scripts 3/24/2020 4/20/2020 5 Data Governance Data Dictionary, Mentoring 1/2/2020 6/20/2020 6 Warehouse to Tableau API Connectivity to Repository and Tableau Server 1/2/2020 4/3/2020 7 Tableau Reporting and Mentoring Mentoring Design and Development of Visualizations 1/2/2020 4/10/2020 8 Project Management Weekly status reports, project plan, status meetings, 12/5/2019 6/20/2020 9 Travel Up to 3 trips allowed - evidence of travel 11/18/2019 6/20/2020 Number Name of Task Deliverables Start Date End Date 1 Data Mapping and Analysis Source to target mappings for ODS and Data Warehouse, ODS Design and Warehouse Design 11/18/2019 12/4/2019 2 ETL to Staging/ODS ODS system in place and ready for review (code, technical, security) 1/2/2020 2/2/2020 3 ETL to Warehouse Data Warehouse system in place and ready for review (code, technical, security) 2/3/2020 3/20/2020 4 Testing Test Scripts 3/24/2020 4/20/2020 5 Data Governance Data Dictionary, Mentoring 1/2/2020 6/20/2020 6 Warehouse to Tableau API Connectivity to Repository and Tableau Server 1/2/2020 4/3/2020 7 Tableau Reporting and Mentoring Mentoring Design and Development of Visualizations 1/2/2020 4/10/2020 8 Project Management Weekly status reports, project plan, status meetings, 12/5/2019 6/20/2020 9 Travel Up to 3 trips allowed - evidence of travel 11/18/2019 6/20/2020 Comment Files Company Origin Viewable Created By Created On Background Verification
Minimum Verification Requirements
Please complete the following verifications with Info Cubic upon candidate's selection. Additional verifications may be identified by the agency.
(Suppliers Only)
To order, click on the link to the right:
Order Standard Background Verification
Number Name of Task Deliverables Start Date End Date 1 Data Mapping and Analysis Source to target mappings for ODS and Data Warehouse, ODS Design and Warehouse Design 11/18/2019 12/4/2019 2 ETL to Staging/ODS ODS system in place and ready for review (code, technical, security) 1/2/2020 2/2/2020 3 ETL to Warehouse Data Warehouse system in place and ready for review (code, technical, security) 2/3/2020 3/20/2020 4 Testing Test Scripts 3/24/2020 4/20/2020 5 Data Governance Data Dictionary, Mentoring 1/2/2020 6/20/2020 6 Warehouse to Tableau API Connectivity to Repository and Tableau Server 1/2/2020 4/3/2020 7 Tableau Reporting and Mentoring Mentoring Design and Development of Visualizations 1/2/2020 4/10/2020 8 Project Management Weekly status reports, project plan, status meetings, 12/5/2019 6/20/2020 9 Travel Up to 3 trips allowed - evidence of travel 11/18/2019 6/20/2020 Number Name of Task Deliverables Start Date End Date 1 Data Mapping and Analysis Source to target mappings for ODS and Data Warehouse, ODS Design and Warehouse Design 11/18/2019 12/4/2019 2 ETL to Staging/ODS ODS system in place and ready for review (code, technical, security) 1/2/2020 2/2/2020 3 ETL to Warehouse Data Warehouse system in place and ready for review (code, technical, security) 2/3/2020 3/20/2020 4 Testing Test Scripts 3/24/2020 4/20/2020 5 Data Governance Data Dictionary, Mentoring 1/2/2020 6/20/2020 6 Warehouse to Tableau API Connectivity to Repository and Tableau Server 1/2/2020 4/3/2020 7 Tableau Reporting and Mentoring Mentoring Design and Development of Visualizations 1/2/2020 4/10/2020 8 Project Management Weekly status reports, project plan, status meetings, 12/5/2019 6/20/2020 9 Travel Up to 3 trips allowed - evidence of travel 11/18/2019 6/20/2020 Comment Files Company Origin Viewable Created By Created On Background Verification
Minimum Verification Requirements
Please complete the following verifications with Info Cubic upon candidate's selection. Additional verifications may be identified by the agency.
- State Criminal Record verification (past 7 years covering each State in which the candidate has resided)
- County Criminal Records (past 7 Year Address History)
- Federal Criminal Records Verification (past 7 years)
- SSN Name Search
- Global Monitor Check (formerly Patriot/OFAC/Terrorist)
(Suppliers Only)
To order, click on the link to the right:
Order Standard Background Verification