SQL Server 2012 And Later SQL Server DBA Maintainence Report Development Database   Requirement id 86348 Job title Analyst Job location in Tumwater, WA Skills required SQL Server Integration Services, ETL Process, Data Validation, SQL Server 2012 And Later SQL Server DBA Open Date 12-Dec-2018 Close Date Job type Not specified Duration 5 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Analyst: SQL Server Integration Services, ETL Process, Data Validation, SQL Server 2012 And Later SQL Server DBA Note: Email Submission Submission Deadline: 1/3/2019 10:00 AM PT Start Date: 1/30/2019 End Date: 6/30/2019 Client: Washington State Department of Transportation (WSDOT) 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. a. Location Work awarded under this contract will be performed at the Edna Lucille Goodrich Building (ELG) 7345 Linderson Way SW, Tumwater, WA 98501, and the WSDOT State Materials Lab - 1655 South Second Ave, Tumwater, WA 98512, with occasional travel as required. Work Station: The selected vendor will be assigned an Agency workstation and assessed a workstation fee of $108.00 per month. b. 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 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 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. c. Period of Performance The period of performance for the Materials Lab Data Mart project is five (5) months beginning on January 30, 2019 through June 30, 2019. The   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 86348 while calling.   Other jobs in WA: Bellevue (2), Olympia (8), Seattle (18), SQL Server Integration Services job openings in Tumwater, WA Jobs List Data Warehouse Analyst - WR-14-32 - SP Create date: 14-Oct-2013 Description: Required Skills: *Creating and maintaining Extract, Transform, and Load (ETL) processes using SQL Server Integration Services. *Writing complex queries using Transact SQL for reporting and data validation purposes. *Administering and/or managing Microsoft SQL Server 2000, 2005, 2008 r2, 2012 databases. Transact SQL Jobs in WA Tumwater Analyst - (in Tumwater, WA))    SQL Server Integration Services job openings in other states Jobs List ITSAC 70123029 Developer/Programmer Analyst 3 -SP Create date: 16-Dec-2022 Bid URL: Note: Total estimated hours per Candidate shall not exceed 1374 hours. Submission Deadline: 12/30/2022 5:00 PM CT Start Date: 1/16/2023 End Date : 8/31/2023 Client: Texas Education Agency (TEA) Description: Years Required/Preferred Experience 8 Required Power BI .... (This job is for - job Jobs in TX Austin Analyst - (in Austin, TX)) ITS63 FY19-EHS-008- DPH Bfsb -Sr Applications Developer -SP Create date: 21-Mar-2019 Note: Maximum number of resumes per ITS63 Vendors:3 Note: RTR form must be signed by the candidate. Submission Deadline: 3/29/2019 Start Date: 4/9/2019 End Date: 6/30/2019 Client: EOHHS Description: Early Intervention provides family centered services to help children (0-3 years of age) who.... (This job is for - job Jobs in MA Boston Developer - (in Boston, MA)) Senior SQL Server Database Administrator Create date: 07-Apr-2016 Start Date : 04/19/2016 Submission Deadline : 04/13/2016 Description : Document/ProjectWise/ Business Systems Senior SQL Server Database Administrator US Citizen/GC Holder - Data Engineer. This position requires high availability on call support, and a self-directed SQL Server DBA Subject Matter Ex.... (This job is for - SSAS Network Admin Jobs in TX ElPaso Administrator - (in EL PASO, TX)) SAP Business Objects Create date: 23-Jun-2015 NOTE : START DATE : 06/30/2015 SUBMISSION DEADLINE : 06/26/2015 CLIENT INFO : HP Description: Client: HP Location: Herndon, VA ( 100% Remote position) Duration: 3 Months Rate: 55 hr C2C Skills/Experience R.... (This job is for - job Jobs in VA Herndon Analyst - (in Herndon, VA)) ERP Developer 3 - 408369 Create date: 22-May-2015 Description: The Client is in need of an integration specialist to work on a platform shift for the countys financial enterprise resource planning (ERP) system. Candidates should have graduated from an accredited college with a degree in Information Systems or Computer Science and/or progressive IT data and integration experience..... (This job is for - job Jobs in VA CHESTERFIELD Developer - (in Chesterfield, VA))     (Analyst: SQL Server Integration Services, ETL Process, Data Validation, SQL Server 2012 And Later SQL Server DBA in Tumwater, WA)

Featured Jobs Z/Os Specialist (Jobs in Raleigh, North Carolina) Problem Analyst (Jobs in Chelsea, Massachusetts) SQL PostgreSQL Analyst (Jobs in Atlanta, Georgia) PEOPLESOFT Customer Analyst (Jobs in Atlanta, Georgia) TCL Consultant (Jobs in Jackson, Mississippi) Email Supervision Administrator (Jobs in Nashville, Tennessee) LMS MS Developer (Jobs in Durham, North Carolina) Communication Process Manager (Jobs in Lincoln, Nebraska) Healthcare Specialist (Jobs in Raleigh, North Carolina) Oracle Architect (Jobs in Madison, Wisconsin)