Job Description :
Title :Enterprise Data Warehouse Architect
Location: Elk Grove, CA
Duration: 2 year+
Need at least 10-12+ years’ experience.
Required Skills:
1. Designing Enterprise Data Warehouses;
2. Working with SQL Server Business Intelligence Architecture (BIA) (top-down and/or bottom-up approach);
3. Developing and designing Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) databases;
4. Designing and implementing data extract using Replication, Stored Procedures and SQL Server Integration Services (SSIS);
5. Creating procedures and policies for data warehouses;
6. Supporting cross-platform compatibility;
7. Installing, maintaining, administering Microsoft SQL Server;
8. Creating requirements documents, systems architecture and interfaces, data models, configuration management documents and procedural manuals; and,
9. Maintaining database structures to support the Software Development Life Cycle (SDLC) phases
10. Experience in developing and designing Microsoft Azure SQL Data Warehouses; and,
11. Experience in developing and maintaining SQL Server 2016.
Desired Skills:
1. Additional years with Mandatory qualifications
2. Experience using Team Foundation Server (TFS)
3. Experience in supporting enterprise solutions within a health care and/or correctional environment
4. Experience providing guidance to people with various skill levels
5. Experience working in Agile/Scrum framework