Warehouse MS SQL Server Databases SSIS Data Modelling Analysis Tools Kimball MS SQL   Requirement id 94207 Job title Developer Job location in Roseville, MN Skills required Database Development, Warehouse, Business Intelligence Reporting, MS SQL Server Databases SSIS Data Modell Open Date 24-Jun-2019 Close Date Job type Not specified Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Developer: Database Development, Warehouse, Business Intelligence Reporting, MS SQL Server Databases SSIS Data Modell Note: This is a reposting of MNSITE 1492 Note: This request is for 1 full time staff augmentation resource. Note: Each vendor is allowed to submit 1 resource. Incumbent: No, there are no incumbents for this Event. Submission Deadline: 7/9/2019 2:00 PM CDT Start Date: 7/29/2019 End Date: 7/28/2020 Client: MDE Description: This is a reposting of MNSITE 1492. Changes have been made to the Minimum Qualifications and Desired Skills to better reflect the needs of the position. The Database Developer will be working on two projects that will build up an Early Childhood Data Warehouse and move data from the warehouse to an application called Early Childhood Education Outcomes. This resource will be responsible for ETL into the warehouse, developing a scheduling mechanism to easily load new data into the warehouse and manage the dependencies between data sources. New data marts will be needed to support Tableau reporting. In addition, optimization on existing ETL and Stored Procedures needs to be done to allow procedures to be called from Java Applications. Also, the resource will need to improve documentation and data dictionary for end users. The Database Developer should be proficient and capable of warehouse design and architecture. Work is to be on-site at 1500 Highway 36 W, Roseville, MN. Sample Tasks • Design a stable, reliable and effective warehouse • Optimize and maintain legacy procedure scripts • Modify, fix and create warehouse structures to support visual analytical reporting • Solve database usage issues and malfunctions • Write ETL for new data sources • Work with the business analyst to design and identify new features • Develop technical and training materials on new and existing functionality • Provide data management support to users, • Ensure all database programs meet company and performance requirements • Develop Reporting structures such as data marts and cubes to support Tableau Minimum Qualifications • Five (5) years experience working in a Warehouse/Database Development role o A Masters degree substitutes for three years of experience, or a Bachelors degree substitutes for two years, or an Associates degree substitutes for one year • Two (2) engagements lasting more than six (6) months in Warehouse Development role • Five (5) years experience with business intelligence reporting • Five (5) years combined experience with MS SQL Server databases and SSIS • Five (5) years combined experience with data modeling and analysis tools • Five (5) years experience with warehouse data modeling using the "Kimball" approach. • Five (5) years experience working independently on data warehousing Desired Skills • Proven work experience as a Database developer • In-depth understanding of data management (e.g. permissions, recovery, security and monitoring) • Hands on experience with some of these database languages: MySQL, MSSQL, DB2, Oracle, MS SQL or MS Access • Strong skills in ETL and scripting • Excellent analytical and organization skills • Ability to understand front-end users requirements and a problem-solving attitude • A self-starter able to code as well as advise on design and architecture • Subject matter knowledge in Early Learning or K-12 education • Business requirements analysis and specifications   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 94207 while calling.   Other jobs in MN: Coon Rapids (2), Duluth (6), Eagan (1), Edina (3), Little Falls (1), Maplewood (4), Mineapolis (1), Minneapolis (69), Minnesota (1), North Saint Paul (1), Plymouth (1), Roseville (2), Saint Cloud (3), Saint Paul (41), St Cloud (1), St Paul (5), Unknown (1), Database Development job openings in Roseville, MN Jobs List MNSITE-1492 MNIT/MDE ECR-TDW Database Dev (RC RDW) 62186 -SP Create date: 17-Apr-2019 Incumbent: No, there are no incumbents for this Event Note: Each vendor is allowed to submit 1 resource Note: RTR form must be submitted. Submission Deadline: 5/1/2019 2:00 PM CDT Start Date: 5/20/2019 End Date: 5/21/2020 Client: MDE Description: The Data Developer will be working on t.... (This job is for - job Jobs in MN Roseville Developer - (in Roseville, MN))    Database Development job openings in other states Jobs List VDOT ERP Developer 4 (731179) Create date: 18-Mar-2024 Hybrid start date :03/25/2024 End date :06/30/2024 submission deadline :3/21/2024 client info :VDOT Description : **Mgr requests vendors ONLY submit candidates who already live in Richmond, VA **ALL interviews ONSITE <.... (This job is for - job Jobs in VA Richmond Developer - (in Richmond, VA)) PennDOT - FA1 A4 SC3 (Sr. IOS Developer) (728931) Create date: 02-Feb-2024 start date :02/26/2024 End date :06/30/2024 submission deadline : 02/07/2024 client info :PennDOT Description : This is a position as a senior developer supporting all lines of service within the Commonwealth of PAs Office of Administration – Offi.... (This job is for - job Jobs in PA DauphinCounty Developer - (in Dauphin County, PA)) ITSAC 529300526 Database Administrator 3 -SP Create date: 29-Mar-2023 Bid URL: https://dir.my.site.com/itsacvendor/s/itsac-vendor-response/a588z0000000oDvAAI/529300526?tabset-57d77=3 Note: Online Submission Note: RTR form must be signed by the candidate Note: Total estimated hours per Candidate shall not exceed 720 hours Submission Deadline: 4/6/2023 5:00 pm CT Start Date: 5/1/202.... (This job is for - Oracle Jobs in TX Austin Administrator - (in Austin, TX)) VDH Data System Specialist (663932) Create date: 06-Oct-2021 Start Date :10/18/2021 End Date :10/18/2021 Submission Deadline :10/12/2021 Client Info : VDH Note : * Agency Interview Type: Web Cam Interview Only Description : *local candidates strongly preferred *candidate selected must come onsite to pick u.... (This job is for - job Jobs in VA Richmond Specialist - (in Richmond, VA)) Database Administrator - 366 Create date: 21-Apr-2021 Start Date :05/10/2021 Submission Deadline :04/28/2021 Description : Database Administrator. Administers and controls the activities related to database development, installation, security, maintenance, and utilization. Sets and monitors standards. Develops and tests disaster recovery procedures. P.... (This job is for - Installation Jobs in MI Pontiac Administrator - (in Pontiac, MI))    Database Development job openings in MN Jobs List MNSITE-253 DHS Database Developer-253533 -SP Create date: 13-Mar-2023 Bid URL: https://solutions.sciquest.com/apps/Router/SourcingResponseSummary?ResponseId=2920101&tmstmp=1678726701603 Note: Email Submission Submission Deadline: 3/17/2023 2:00 PM CDT Start Date: 4/10/2023 End Date: 4/9/2024 Client: The Department of Human Services (DHS) Description: Sc.... (This job is for - Database Developer Jobs in MN StPaul Developer - (in St Paul, MN)) MNSITE-1526 DHS Database Developer 217319 (RK)- Re-Post -SP Create date: 16-May-2019 Note: Each vendor is allowed to submit 1 resource. Incumbent: Yes. If the incumbent is submitted, they will be evaluated in the same way as all other candidates, using the criteria set forth in this Event. Submission Deadline: 5/31/2019 2:00 PM CDT Start Date: 7/1/2019 End Date: 6/30/2021 Client: DHS .... (This job is for - job Jobs in MN StPaul Developer - (in St Paul, MN)) MNSITE-1447 DHS Database Developer MRIS-EIOR 217319 (RK) -SP Create date: 02-Apr-2019 Incumbent: Yes incumbent exists. Note: Each vendor is allowed to submit 1 resource. Submission Deadline: 4/16/2019 2:00 PM CDT Start Date: 5/1/2019 End Date: 4/30/2021 Client: State of Minnesota Description: Sample Tasks • Work with program staff to create technology solutions to meet .... (This job is for - job Jobs in MN StPaul Developer - (in St Paul, MN)) Apps Systems Engineer - 26422 Create date: 03-Aug-2017 Candidate must be our W2 Employee Job Description : APPLICATION SYSTEMS ENGINEER Location: Downtown Minneapolis, MN Length: 12 months, potentially a month or two longer Notes from Manager: Background on Project: This managers group stood up a web .... (This job is for - job Jobs in MN Minneapolis Engineer - (in Minneapolis, MN)) (Developer: Database Development, Warehouse, Business Intelligence Reporting, MS SQL Server Databases SSIS Data Modell in Roseville, MN)

Featured Jobs System Analyst (Jobs in Madison, Wisconsin) Consultant (Jobs in Dauphin County, Pennsylvania) Project Analyst (Jobs in Lincoln, Nebraska) - Consultant (Jobs in Lincoln, Nebraska) Business Analyst Written Analyst (Jobs in COLUMBIA, South Carolina) .Net Developer (Jobs in Nampa, Idaho) Agile TFS Analyst (Jobs in COLUMBIA, South Carolina) Pega Case Consultant (Jobs in Trenton, New Jersey) SQR Billing Consultant (Jobs in COLUMBIA, South Carolina) Workflow Health Consultant (Jobs in Jackson, Mississippi)