SSIS Developer (Jobs in Madison, WI)   Requirement id 153754 Job title Developer Job location in Madison, WI Skills required SQL Database, SSIS, Agile/Scrum Environment, Open Date 06-Jun-2025 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type --- Apply    Email Recruiter: coolsoft Job Description Developer: SQL Database, SSIS, Agile/Scrum Environment, Start Date :07/01/2025 End Date :06/30/2026 Submission Deadline :6/10/25 4:00 PM CST Client Info : DPI Note: * Interview Process: Microsoft Team, 1 round, with audio and video on, also be prepared to share your screen. * Duration: Until June 30, 2026 with possibility of extension * Onsite or Remote: This position can either be on-site, hybrid or 100% remote. Must be a WI resident or willing to relocate. Residents near Madison can choose to come into the office if they desire. Description: ETL Developer Wisconsin Department of Public Instruction Data Warehouse and Decision Support team This position is responsible for providing technical expertise and services regarding the extract, transfer, and load of data for the Department, including creating SSIS packages for the nightly build of the agencys data warehouse. This includes but is not limited to data collected through enterprise applications such as the WISEid, WISEdata, the Wisconsin State Assessment System, and data reported in WISEdash. WISEdash is powered by PowerSchool Unified Insights (formerly known as Edvantage tool under Hoonuit and Versifit). The position is also responsible for creating EDFacts federal reporting files and fulfilling other state and federal data reporting requirements. The person in this position is responsible for peer testing of the work of their teammates including other ETL developers and dashboard developers. Objectives, priorities, and deadlines are established in consultation with the user, director and division leadership and discussed biweekly during Agile/Scrum sprint retrospective and planning sessions. Required qualifications: • Expert knowledge and use of SQL • Expert knowledge and use of SSIS (SQL Server Integration Services) • Experience working on an Agile/Scrum team (able to work well in a team, but also highly self-motivated) Preferred qualifications: • Experience with K-12 education data sector • Knowledge of Power BI Candidate Qualities: • Organized, self-motivated, independent worker needing limited managerial oversight. • Team player who can communicate clearly and thoroughly. • Enthusiastic in learning new technologies with excellent problem solving and analytical skills. • Very good communication and interpersonal skills and has the ability to work independently as well as in a team environment. Example tasks: • Complete SSIS programs for the Edvantage/WISEdash data warehouse based on completed ETL data mappings. • Complete automation and schedules for extraction and load process. • Provide recommendations and solutions for business rules, SSIS package development, and data structures. • Support / troubleshooting of the development and production environments. • ETL developer on high priority cross agency projects such as the Digital Equity Gap collection and reporting project. • Gather and analyze end user requirements for new data loads for the data warehouse. Complete functional & technical specifications to load data from disparate source systems into the data warehouse for reporting and analysis. • Design and develop Microsoft SSIS packages required to extract, transform, and load data into the data warehouse. Complete testing of packages and deploy to production. • Maintain master build and the scheduling / automation for the nightly SSIS load. Add new packages to master build and scheduler as needed. • Complete SSIS configuration tasks, troubleshooting of failed jobs and/or processes, issue identification and resolution. • Knowledge about the scrum methodologies and agile practices • Working with MS SQL Server 2016+ and Oracle databases • Write queries /views/functions/stored procedur   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 153754 while calling.   Other jobs in WI: De Pere (2), Green Bay (8), Kenosha (2), Madidson (1), Madison (36), Menomonee Falls (19), Milwaukee (59), Sun Prarie (1), Unknown (2), Waukesha (2), SQL Database job openings in Madison, WI Jobs List Data Warehouse Developer III - 111384 - SP Create date: 15-Nov-2022 start date:12/19/2022 End date:06/30/2023 submission deadline:11/22/2022 4:00PM CST client info : DPI Note: * Interview Process: Microsoft Team, 1 round, with audio and video on, also be prepared to share your screen. * Duration: Until June 30, 2023 with possibility of extension. <.... (This job is for - SSIS Jobs in WI Madison Developer - (in Madison, WI)) Database Administrator III - 107663 - SP Create date: 04-Aug-2022 start date:9/12/2022 End date:06/30/2023 submission deadline:8/11/2022 4:00:00 PM client info: DPI Note: * Interview Process: 1 round virtual interview w/camera on * Duration: 1 year contract, intent to renew * Remote or On-site? full time remote, does not need to be WI resi.... (This job is for - job Jobs in WI Madison Administrator - (in Madison, WI)) Junior System Administrator Create date: 17-Apr-2020 Description: Working as part of the Server Support team, the System Administrator 1 is a support position installing new software releases; performing system upgrades; evaluating and installing new frameworks, operating systems, and server applications; and resolving software related problems. Performs system backups/recoveries and utili.... (This job is for - job Jobs in WI Madison Administrator - (in Madison, WI)) Database Architect 3 - WISCJP00016567 Create date: 23-Mar-2020 start date:4/13/2020 End date:06/30/2020 submission deadline : Due to SCS 03/27/2020 by 8:00 AM CT client info : DOJ – Department of Justice Note: * Interview option is Web based. We are all working remotely. The candidate will be working remotely for now due to covid 19. .... (This job is for - Python Jobs in WI Madison Architect - (in Madison, WI))    SQL Database job openings in other states Jobs List NCDOT - AASHTOWare Project Technical Specialist (751135) Create date: 20-Nov-2024 No of Submissions: 2 Start Date: 12/2/2024 End Date: 12/17/2025 Submission deadline: 11/26/2024 Client info: NCDOT Note: * Remote work from home * Either Webcam Interview or In Person * The candidate will need to use their own equipment from home to remote into.... (This job is for - job Jobs in NC Raleigh Specialist - (in Raleigh, NC)) GA DOR - Applications Developer 1 (751588) Create date: 20-Nov-2024 Onsite No of Submissions : 2 Start date : 12/16/2024 End Date : 06/30/2025 Submission deadline : 12/02/2024 Client Info : DOR - IT Note: * Agency Interview Type: In Person Only Description : *THE TAX CLEARANCE LETTER COMPLIANCE ITEM, IS DUE AT THE TIM.... (This job is for - Analytical Skills Jobs in GA Atlanta Developer - (in Atlanta, GA)) Programmer 6 - 136923 Create date: 04-Nov-2024 No of Submissions : 1 Start date : 12/02/2024 End Date : 12/01/2025 Submission deadline : 11/14/2024 10:00:00 AM Client Info : MDOT Note: * Interviews: MS Teams video interview with camera ON. * Duration: 1 year with possible extension * Position locatio.... (This job is for - GitHub Jobs in MI Lansing Consultant - (in Lansing, MI)) DHHS- SQL Server Administrator (748082) Create date: 30-Sep-2024 Hybrid No of Submissions : 1 start date :09/30/2024 End date :03/26/2025 submission deadline : 10/04/2024 client info : NCDHHS-AM Note: * Agency Interview Type: Webcam Interview Only Description : Due to.... (This job is for - Troubleshooting Jobs in NC Raleigh Administrator - (in Raleigh, NC)) GA DOR - Applications Developer 1 (740631) Create date: 02-Jul-2024 No of Submissions :2 Start date :7/22/2024 End Date :06/30/2025 Submission deadline :07/15/2024 Client Info :DOR - IT Description : *THE TAX CLEARANCE LETTER COMPLIANCE ITEM, IS DUE AT THE TIME OF CANDIDATE SUBMISSION* (pls review the compliance tab on how the candidate can obtain th.... (This job is for - Java Jobs in GA Atlanta Developer - (in Atlanta, GA))    SQL Database job openings in WI Jobs List Database Administrator IV-104810 Create date: 23-May-2022 start date:07/01/2022 End date:06/30/2023 submission deadline: 5/27/2022 client info : DOA Note: * Duration: 6/30/2023 likely to extend * Wisconsin resident candidates only or willing to relocate at the candidates expense. * This position is 100% remote, with an optio.... (This job is for - Troubleshoot Jobs in WI Wisconsin Administrator - (in Wisconsin, WI)) (Developer: SQL Database, SSIS, Agile/Scrum Environment, in Madison, WI)

Featured Jobs SDLC Microsoft Analyst (Jobs in Richmond, Virginia) PostgreSQL NIST Architect (Jobs in Madison, Wisconsin) ArcGIS .NET FRAMEWORK Python Developer (Jobs in Madison, Wisconsin) Tracking Consultant (Jobs in Madison, Wisconsin) SSIS Developer (Jobs in Madison, Wisconsin) ASP.Net MVC RESTful Analyst (Jobs in Madison, Wisconsin) Analysis DB2 Engineer (Jobs in Madison, Wisconsin) ArcGIS Data Developer (Jobs in Madison, Wisconsin) Agile Consultant (Jobs in Madison, Wisconsin) IT Project Management Visio Microsoft Consultant (Jobs in Atlanta, Georgia