datawarehouse Business Intelligence Data Modeler ETL SQL Server 2016 Windows 10 SSIS   Requirement id 95761 Job title Analyst Job location in Tumwater, WA Skills required datawarehouse, Business Intelligence, Data Modeler, ETL SQL Server 2016 Windows 10 SSIS Open Date 01-Aug-2019 Close Date Job type Not specified Duration 22 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Analyst: datawarehouse, Business Intelligence, Data Modeler, ETL SQL Server 2016 Windows 10 SSIS Note: Email Submission Submission Deadline: 8/12/2019 1:00 PM PT Start Date: 9/9/2019 End Date: 6/30/2021 Client: Washington State Department of Transportation Description: Project Description and Background WSDOT is initiating this Work Request to solicit proposals from firms interested in providing senior level Database Services (Category 8). 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 WSDOTs 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. Scope of Work 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 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 WSDOTs 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.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 95761 while calling.   Other jobs in WA: Bellevue (2), Olympia (8), Seattle (18),    datawarehouse job openings in other states Jobs List VDOT Programmer Analyst 4/Datawarehouse (747993) Create date: 23-Oct-2024 **Hybrid Max Submittals by Vendor : 2 Start date : 11/18/2024 End Date : 06/30/2025 Submission deadline : 10/28/2024 Client Info : VDOT Description : ------------------------------------------------------ Data architect to provide data intake, data governance, data transfor.... (This job is for - datawarehouseSQL Jobs in VA Richmond Analyst - (in Richmond, VA)) Business Intel Technical Lead II -113309-SP Create date: 12-Jan-2023 Start date : 02/27/2023 End Date : 06/30/2023 Submission deadline :January 23rd at 4:00PM CST. Client Info :DCF Note : INTERVIEW NOTES: • Phone and web based interviews will be acceptable. • However, an in--person interview may be required. • Interviews will be set up .... (This job is for - datawarehouse Jobs in WI Madison TechLead - (in Madison, WI)) ITSAC 302CSD2205 Software Developer 2 -SP Create date: 17-Feb-2022 Note: RTR form must be signed by the candidate. Note: Total estimated hours per Candidate shall not exceed 750 hours. Submission Deadline: 2/24/2022 5:00 PM CT Start Date: 4/1/2022 End Date : 8/31/2022 Client: Office of the Attorney General of Texas (OAG) Description: Years Required/.... (This job is for - Datalake datawarehouse Jobs in TX Austin Developer - (in Austin, TX)) Data Warehouse Engineer-59214 Create date: 05-Jan-2022 Note:Candidates must be local to central Ohio or relocated by day one for consideration. Description: Our client is seeking a Data warehouse engineer with experience with the Microsoft stack of data warehouse tools (SQL, SSIS, SSAS, SSRS). The contractor will be part of a database team and responsible for participating i.... (This job is for - datawarehouseSSIS Jobs in OH Columbus Engineer - (in Columbus, OH)) INS-Database Administrator4 /DBA4 (673466) Create date: 05-Jan-2022 Start Date :01/31/2022 End Date :06/30/2022 Submison Deadline :01/10/2022 Client Info: INS Description : OITS Data Team It is seeking a Data warehouse engineer with experience with the Microsoft stack of data warehouse tools (SQL, SSIS, SSAS, SSRS). The contractor w.... (This job is for - datawarehouse SSAS SSIS Jobs in OH Columbus Administrator - (in Columbus, OH))     (Analyst: datawarehouse, Business Intelligence, Data Modeler, ETL SQL Server 2016 Windows 10 SSIS in Tumwater, WA)

Featured Jobs AWS .NET FRAMEWORK UI CSS Tester (Jobs in Little Rock, Arkansas) Microsoft Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Nashville, Tennessee) Written Specialist (Jobs in Salem, Oregon) VLAN Subnets Routing Engineer (Jobs in Staunton, Virginia) Training Specialist (Jobs in Atlanta, Georgia) Adobe Analyst (Jobs in Jackson, Mississippi) MS Office EHR Consultant (Jobs in Richmond, Virginia) Information Manager (Jobs in Madison, Wisconsin) Jira UFT Defect Tester (Jobs in Raleigh, North Carolina)