Senior-Level Data Warehouse Analyst(IN PERSON INTERVIEW)(Job ID:WR-2018-1211-BP)
- Linderson Way SW, Tumwater, WA, USA
Computer Consultants International, Inc. (CCI) is an IT Consulting Firm with more than 18 years experience providing effective, expert-level services in industries such as Construction, Technology, Finance, Healthcare, and Government. CCI focuses on building long-term relationships while completing projects from design to delivery. People are CCI's key component for success. Recruiting utmost-quality individuals for our clients, CCI fields a workforce of individuals who are selected not only because of their technical qualifications but also for their achievements as substantial, contributing human beings. In government work and in the commercial market, high standards of ethics and accountability are critical. Therefore our people are chosen for their integrity and ability to maintain relationships, as well as expertise in their field. To learn more about CCI, visit us online at www.cci-worldwide.com.
CCI has a Client who is seeking a Candidate to provide senior level Database Services. Work will initially be focused on requirements gathering, documentation and design, then transition into the technical development and implementation of extract, transform and load processes needed to support the inclusion of the various Materials Lab testing, project estimating, and cost recovery systems into Client’s Data Warehouse.
This project will provide the Materials Lab and its customers an integrated solution allowing for the cross reporting of Materials Lab data in with related engineering and financial data participating in the Data Warehouse.
The scope of work for the Materials Lab Data Mart requires one (1) senior level Data Warehouse Analyst to work with the Information Technology Division (ITD) Data Warehouse Business Intelligence Coordinator and Data Modeler to lead requirements gathering sessions with the State Materials Lab and stakeholders, and develop necessary requirements and technical documentation to support development of the Materials Lab Data Mart.
The Contractor shall then develop and perform the technical tasks required to implement, maintain, enhance performance, and troubleshoot extract, transform and load (ETL) processes that move data from the Materials Lab transactional databases and flat files to the Data Warehouse.
Finally, the Contractor shall develop key reports identified in the requirements gathering sessions and provide support to report analysts and customers to ensure accurate and timely performance of reports utilizing information from the data warehouse.
The Data Warehouse operating environment is SQL Server 2016 on Windows 10 and our ETL tool is Microsoft SQL Server Integration Services (SSIS).
Specific duties include:
Using client requirements and database design specifications, the Contractor shall:
Lead requirements gathering meetings with State Materials Lab staff and stakeholders.
Develop requirements documentation.
Determine how identified data sources can provide the required data
Develop technical spec documentation
Test data structures to verify that the target databases work as designed.
Set up ETL routines; write the code using SSIS packages that move data from the specified sources; transform it as required and write it into the data mart. The outcome of this task shall be error-free ETL routines that meet requirements and design specifications, and are regularly scheduled within WSDOT’s Data Warehouse loading process.
Develop critical reports and provide technical assistance to staff in writing complex datamart queries, based on the detailed knowledge gained during the construction of ETL routines. The outcome of this task shall be the development of key reports needed by the State Materials Lab and the provision of technical information and ideas to support staff and query tool experts who are assisting users with advanced, complex datamart queries.
As part of the Materials Lab Data Mart project, Contractor will be responsible for performing tasks throughout various stages of this project. The following is a list of these tasks that will result in the successful completion of this project. Design Phase
Contractor will work with the State Materials Lab and appropriate stakeholders, with the guidance of the ITD Data Warehouse Business Intelligence Coordinator, to gather requirements
Contractor will create requirements documentation based on collected requirements
Contractor will determine how the data sources identified can provided the required data and work with the ITD Data Modeler who will develop the data model to support meeting the requirements.
Contractor will develop technical spec documentation Implementation Phase
Contractor will test data structures to verify that the target databases work as designed
Contractor will set up ETL routines; write the code using SSIS packages that move data from the specified sources; transform it as required and write it into the data mart. The outcome of this task shall be error-free ETL routines that meet requirements and design specifications, and are regularly scheduled within WSDOT’s Data Warehouse loading process.
Contractor will develop key reports identified in the requirements.
Contractor will provide technical assistance to staff in writing complex datamart queries, based on the detailed knowledge gained during the construction of ETL routines Project Handoff
Contractor will provide WSDOT with all documentation in accordance with the approved project plan. .
- Minimum 5 years of experience in leading requirements gathering sessions and developing requirements and technical documents based on those requirements
- Minimum 5 years of experience in creating and maintaining
- Extract, Transform, and Load (ETL) processes using SQL Server Integration Services (SSIS)
- Minimum 5 years of experience writing complex queries using Transact SQL for reporting and data validation purposes.
- Minimum 5 years of experience using Microsoft SQL Server 2012, 2016 and 2017 software tools to administer and/or manage SQL Server databases.
- Minimum 5 years of experience employing Kimball data warehouse principles and theories, including knowledge of the various tactical approaches to data warehouse development.
- Minimum 5 years of experience report development
- Experience using Informatica Power Center
- Understanding of database modeling and design principles and ability to use a data model diagram.
- Experience using PowerExchange for Mainframe ADABAS.
- Experience using Cognos Business Intelligence for reporting
- Experience using Team Foundation Server
For immediate consideration, please send your resume to hire(at)cci-worldwide.com with "Senior-Level Data Warehouse Analyst(IN PERSON INTERVIEW)(Job ID:WR-2018-1211-BP)WA" as the subject line.