SSIS DQS ETL Applications Reports Schedule Management Database Design SQL Project P   Requirement id 111283 Job title Consultant Job location in Grayling, MI Skills required State Government Experience., Data Management, SSIS, DQS ETL Applications Reports Schedule Ma Open Date 02-Nov-2020 Close Date Job type Contract Duration 8 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Consultant: State Government Experience., Data Management, SSIS, DQS ETL Applications Reports Schedule Ma Start Date : 11/16/2020 End Date : 06/22/2021 Submission Deadline : 11/13/2020 Client Info: DTMB Agency Services Description: A small, agile IT Data Warehouse Team (DWT) is needed for the implementation of a Master EGLE Interests data warehouse environment. 1.02 The DWT will be responsible for developing Master EGLE Interests DW, including DBdesign, development of ETL logic and processes (primarily transform & load), and creating ability for eusers to query/report/view data. Client is looking for a vendor to provide resources for the Quality of Life DW and Master Data Project. These positions will include: DATA WAREHOUSE ARCHITECT 3 1) Ability to create write ETL jobs using SSIS, DQS, and other tools. 2) Strong ability to work in a SQL environment. 3) Ability to create scheduler jobs. 4) Ability to model and create reports. DATABASE ARCHITECT 4 1) Ability to create database design based on customer needs. 2) Strong ability to work in SQL. 3) Strong data architecture principles and expertise. SOFTWARE SOLUTION ARCHITECT 1) Ability to lead and understand all technical components and integration necessary for successful delivery. 2) Ability to ensure timely delivery of work. 3) Contributes to current state analysis / documentation. 4) Leads Execution Project Planning Activities. Suppliers must respond with candidates for all positions. Those candidates must be on-boarded and ready to start on the designated start date. • This requirement will remain open for two weeks so that the supplier community has an opportunity to submit a response. CAI will forward all complete responses to SOM for review. All of the following criteria must be met for a submittal to be considered complete: • Vendor must attach a company profile that answers all questions listed within the "Company Qualifications" document located in the "Reference" section of this requisition. • Vendor must submit candidate resumes for each of the proposed resources that will be starting on the designated start date. • Electronic Right-to-Represent (E-RTR) emails must be submitted by all proposed candidates. Candidates will not receive screening calls from CAI. The State may choose to interview any or all companies who respond. 2.01 The Master EGLE Interests data warehouse will be implemented through governance of an EGLE IT Core Team, the EGLE Information Management Division, and client. 2.02 The DWT services are required to augment existing resources and provide leadership and expertise in the creation of a sustainable data warehouse model. 2.03 EGLE has a large number of disparate systems that track information on similar, or in some cases the same, site locations throughout Michigan. The goal of this effort is to establish a data warehouse environment that allows EGLE to track high level information and associations on sites, facilities, and locations over time. 2.04 The scope of work for DWT resources include, but is not limited to, designing SQL database, building SQL Data Quality Services processes, loading data into the data warehouse and developing reports on the data. 2.05 This engagement will include work on the following deliverables: 1) Design SQL Database. EGLE and the corresponding clients Team use SQL environments and intend to do so for this project as well. 2) Build a load process for a spreadsheet template. Some data sources exist on network drives and may be in Microsoft Access or Excel formats. There is a need to build load functionality for this data, such that any source data in the template will be able to be loaded. 3) Build SQL Data Quality Services (DQS) Process. DQS is envisioned to be a core component of the overall effort. It will be used to help meet   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 111283 while calling.   Other jobs in MI: Ann Arbor (5), Detroit (2), Dimondale (1), Lansing (29), Pontiac (1), Southfield (1), TROY (1), Warren (1),    State Government Experience. job openings in other states Jobs List Stafford County - Project Manager (730646) Create date: 20-Mar-2024 Hybrid start date :03/18/2024 End date :11/18/2024 submission deadline :3/25/2024 client info : Stafford County Description : ·Four or more years of project management experience ·Strong attention to deadlines and budgetary g.... (This job is for - Project Manager Jobs in VA Stafford Manager - (in Stafford, VA)) SOW / Project - 114098 - NSP Create date: 07-Feb-2023 start date : 03/27/2023 submission deadline : 2/9/2023 4:00:00 PM client info : DHHS Description : DHHS has access to a large amount of data, but needs a strategy to turn data into actionable information to improve outcomes. The agency also needs to develop .... (This job is for - Services Implementation Jobs in UT Taylorsville Consultant - (in Taylorsville, UT)) MNSITE-2456 MNIT/DPS DVS Projects PM 84962 -SP Create date: 22-Jul-2022 Bid URL: https://solutions.sciquest.com/apps/Router/SourcingResponseSummary?ResponseId=2663811&tmstmp=1658509173302 Note: Online Submission Incumbent: No Incumbent Submission Deadline: 8/5/2022 2:00 PM CDT Start Date: 8/15/2022 End Date : 1/31/2023 Client: Department of Public Safety (DPS) Stakeholders Jobs in MN StPaul Manager - (in St Paul, MN)) NC - DIT Project Manager II (660956) Create date: 17-Sep-2021 Start Date :09/15/2021 End Date :09/14/2022 Submission Deadline :09/23/2021 Client Info: NCDIT Note : * Agency Interview Type: Either Webcam Interview or In Person Description ***The candidate will be allowed to work remotely for the duration of the enga.... (This job is for - PMBOK Jobs in NC Raleigh Manager - (in Raleigh, NC)) Project/Program Manager - Level 3 - 8020 Create date: 26-Jan-2021 start date:2/8/2021 End date:02/08/2022 submission deadline:01/29/2021 client info : CT DOL Note: ** At this time due to COVID 19 it will be remote. Moving forward there may be days in Central Office. Description: 6.... (This job is for - job Jobs in CT Hartford Manager - (in Hartford, CT))     (Consultant: State Government Experience., Data Management, SSIS, DQS ETL Applications Reports Schedule Ma in Grayling, MI)

Featured Jobs Java Kafka Microservices Developer (Jobs in Orange County, California) Software Analyst (Jobs in Richmond, Virginia) Business Analyst (Jobs in Bismark, North Dakota) QA Analyst (Jobs in Madison, Wisconsin) Data Manager (Jobs in Columbus, Ohio) Business Analyst (Jobs in Columbus, Ohio) Cross Manager (Jobs in Des Moines, Iowa) TOMCAT Consultant (Jobs in Columbia, South Carolina) - Consultant (Jobs in Knoxville, Tennessee) .Net Engineer (Jobs in Columbus, Ohio)