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 Security Analyst II - 160252 - Rebid Create date: 22-Jun-2026 Start date :7/1/2026 End Date :06/30/2027 Submission deadline :06/24/2026 at 4 pm CST Client Info : DWD Note: * Interview Process: Teams with camera on. PLEASE NOTE: A Realtime Screenshot Photo of the candidate MUST be uploaded to candidates bid upon confirming the interview. Please see "DWD Realt.... (This job is for - Jobs in WI Madison Analyst - (in Madison, WI)) Data Warehouse Developer III - 159210 - Rebid Create date: 26-May-2026 Start date :7/1/2026 End Date : 06/30/2027 Submission deadline :5/28/2026 4:00 PM CST. Client Info : DOC Note: * Interview Process: MS Teams Interviews, with video on. * Duration: 6/30/27 with option to extend * WI residency is required. Description: .... (This job is for - PowerShell Jobs in WI Madison Developer - (in Madison, WI)) Data Warehouse Developer I - 159050 - Rebid Create date: 21-May-2026 Start date :7/1/2026 End Date :06/30/2027 Submission deadline :5/26/26 at 4 CST. Client Info : DPI Note: * Interview Process: Via Teams * Onsite or Remote: Candidate must be a CURRENT WI resident. No relocation allowed. This position is 100% remote within the state of Wisconsin. job Jobs in WI Madison Developer - (in Madison, WI)) .NET Web Developer II - 156058 Create date: 05-Mar-2026 Start date :4/6/2026 End Date :06/30/2026 Submission deadline :3/12/2026 at 4:00 PM CST. Client Info : DCF Note: * Onsite, hybrid or remote: No WI residency required. Open to nationwide candidates. 90-100% remote but can require staff to come onsite as necessary with sufficient notice. Onsite wo.... (This job is for - MVC Jobs in WI Madison Developer - (in Madison, WI)) 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))    SQL Database job openings in other states Jobs List Programming Analyst - 164250 Create date: 06-Aug-2026 Start date :9/2/2026 End Date : At least 3 Years from projected start date Submission deadline :8/13/2026 3:00:00 PM Client Info : MDHS Note: * 100% Onsite required Description: Client is currently seeking an experienced application developer with a minimum of 10+ years expe.... (This job is for - ADABAS NaturalSDLC Jobs in MS Jackson Analyst - (in Jackson, MS)) System Software Programmer - Consultant - 12836 Create date: 17-Jul-2026 Start date :8/27/2026 End Date :12 Months from projected start date Submission deadline :July 24th, 2026, 5:00 PM EST Client Info : SCDOR Note: * Interview Process: 1 Round of Onsite Interviews * Work Location: Fully Onsite - NO potential for remote work * Candidate loca.... (This job is for - job Jobs in SC Columbia Consultant - (in Columbia, SC)) System Software Programmer - Advanced - 12766 Create date: 15-Jul-2026 Start date :8/19/2026 End Date :12 Months from projected start date Submission deadline :7/22 at 5:00 PM EST. Client Info : DSS Note: * Interview Process: 1 round, in person * Work Location: Role is hybrid (3 days onsite per week) - this is subject to change to fully onsite with littl.... (This job is for - job Jobs in SC Columbia Consultant - (in Columbia, SC)) DCS - Sr. Oracle SQL Analyst (807268) Create date: 15-Jul-2026 Start date : 8/10/2026 End Date : 06/30/2027 Submission deadline : 7/27/2026 Client Info : DCS Note: *Agency Interview Type : In Person Only *Work Arrangement : Hybrid *ON-SITE INTERVIEWS ONLY! *Candidate MUST come ON-SITE Day 1 for Orientation and Equipment Pick up. The Clie.... (This job is for - Jobs in GA Atlanta Analyst - (in Atlanta, GA)) CAPPS HR/PY Human Resources Analyst - 304FM202719 Create date: 18-Jun-2026 Bid URL: https://dir.my.site.com/itsacvendor/s/itsac-vendor-response/a58cs00000ONiZyAAL/304fm202719?tabset-57d77=3 Note:Online Submission Note:Total estimated hours per Candidate shall not exceed 1920 hours. Note: RTR form must be signed by the candidate Note: The primary work location(s) will be at Texas Comptroll.... (This job is for - NIST Jobs in TX Austin Analyst - (in Austin, TX))    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 - - Consultant (Jobs in Tennessee, Tennessee) Communication Quality Assurance Tourbleshooting Analyst (Jobs in Tallahass J2EE Curam Technical Developer (Jobs in Raleigh, North Carolina) Migration Engineer (Jobs in Raleigh, North Carolina) datawarehouse Requirements Analyst (Jobs in Richmond, Virginia) - Consultant (Jobs in Nashville, Tennessee) Written Consultant (Jobs in Nashville, Tennessee) Jira Manager (Jobs in Madison, Wisconsin) Cobol JCL CICS DB2 Consultant (Jobs in Madison, Wisconsin) ARIA HTML. Developer (Jobs in Des Moines, Iowa)