Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
SSIS Data Mapping Data Structures Troubleshooting MS SQL Server 2016 Visual Studio
 
Requirement id 137553
Job title Developer
Job location in Madison, WI
Skills required Agile/Scrum Environment, SQL Database, SSIS, Data Mapping Data Structures Troubleshoo
Open Date 15-Nov-2022
Close Date
Job type Contract
Duration 6 Months
Compensation DOE
Status requirement ---
Job interview type ---
   Email Recruiter: coolsoft
Job Description Developer: Agile/Scrum Environment, SQL Database, SSIS, Data Mapping Data Structures Troubleshoo

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.

* Onsite or Remote: This position can either be on-site, hybrid or 100% remote. WI residency is not required. Residents near Madison can choose to come into the office if they desire.

Description:

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, WISE data, the Wisconsin State Assessment System, and data reported in WISEdash. WISEdash is powered by PowerSchool Unified Insights (formerly known asEdvantage tool underHoonuit 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 procedures as needed

• Complete perfor
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 137553 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),
Agile/Scrum Environment job openings in Madison, WI
Jobs List

Sr Internal Business Systems Analyst II - 110256 - SP
Create date: 12-Oct-2022
start date:11/7/2022
End date:06/30/2023

submission deadline: 10/19 at 4:00PM CST.

client info : DPI

Note:

* Interview Process: Will be virtual through Microsoft Teams.

* Duration: 06/30/2023 with potential to extend

* Position may work up to 100% remote. May require on-site o.... (This job is for - job Jobs in WI Madison Analyst - (in Madison, WI))

Project Manager III - 107470 - SP
Create date: 29-Jul-2022
start date:8/29/2022
End date:06/30/2023

submission deadline: 8/5 at 4:00PM CST.

client info : DPI

Note:

* Interview Process: Teams Interview with camera and audio ON - 1 round.

* Duration: 06/30/2023

* Remote or On-site? Currently 100% remote until 9/30/22. Potential to stay .... (This job is for - Quality Assurance Jobs in WI Madison Manager - (in Madison, WI))

Project Manager III - 107180 - SP
Create date: 21-Jul-2022
start date:8/15/2022
End date: At least 1 Years from projected start date

submission deadline: 7/29/2022 4:00:00 PM

client info : DFI

Note:

* Interview Process: Face to Face Teams Interview, Candidates must be available in camera with audio on.

* Duration: I year project

* On.... (This job is for - job Jobs in WI Madison Manager - (in Madison, WI))

Project Manager III - 103109 - SP
Create date: 18-Apr-2022
start date:5/16/2022
End date: At least 2 Years from projected start date

submission deadline: 04/22 at 4:00PM CST.

client info : DFI

Note:

* Interview Process: Face to Face Teams Interview, Candidates must be available in camera with audio on.

* Duration: I year and potential extension.... (This job is for - Jira Jobs in WI Madison Manager - (in Madison, WI))

Quality Assurance Analyst III - 95909 - SP
Create date: 19-Nov-2021
start date:12/6/2021
End date:06/30/2023

submission deadline:11/26/2021 4:00:00 PM

client info : DPI

Note:

* Interview Process: Microsoft Teams or Zoom with Camera On, 1-2 rounds.

* Duration: 6/30/2022 with possibility of renewal through 6/30/2023
Onsite or Remote? Local candidates.... (This job is for - job Jobs in WI Madison Analyst - (in Madison, WI))
 
 Agile/Scrum Environment job openings in other states
Jobs List

Programmer Analyst 6 -126847
Create date: 05-Feb-2024
Start date : 03/04/2024

End Date : 1 Years from projected start date

Submission deadline : 2/9/2024 at 10am EST.

Client Info : DHHS

Note :

* Interview Process: Virtual Interview via MS Teams video. Please use laptop and be prepared so share screen if asked. Use of headphones is strongly disc.... (This job is for - API Jobs in MI Lansing Analyst - (in Lansing, MI))

PROJECT MANAGER - 10790-1
Create date: 18-Apr-2023
start date : MAY 17, 2023

End date : 12 MONTHS from the start date.

submission deadline : 4/25/2023

client info : Department of Health and Human Services

Note :

* INTERVIEW PROCESS (phone, video or in-person, how many rounds of i/vs, etc.)

- Video for initial interview. In-person .... (This job is for - PMP Jobs in SC Columbia Manager - (in Columbia, SC))

Automation Developer Analyst III (Senior) - 20230117120238
Create date: 17-Jan-2023
start date:1/30/2023
End date:6+months from start date

submission deadline:1/24/2023

Note:

* Job : On-Site

Description:

Analyze and translate functional requirements to create and execute test cases for large business initiatives. Automate these test cases, and execute on regular bas.... (This job is for - job Jobs in OH Columbus Developer - (in Columbus, OH))

ITSAC 529210080C Business Analyst 3 -SP
Create date: 30-Mar-2022
Bid URL:

Note: Total estimated hours per Candidate shall not exceed 688 hours.

Submission Deadline: 4/5/2022 5:00 PM CT
Start Date: 5/2/2022
End Date : 8/31/2022

Client: Texas Health and Human Services Commission (HHSC)

Description:

Years Required/Preferred Experience
8 Require.... (This job is for - Waterfall Jobs in TX Austin Analyst - (in Austin, TX))

Scrum Master - 98659 - SP
Create date: 02-Feb-2022
start date:2/28/2022
End date:06/30/2023

submission deadline:2/8/2022 4:00:00 PM

client info : BOE

Description:

we are working on a comprehensive modernization initiative to replace our legacy systems, referred to as the Utah Schools Information Mana.... (This job is for - Kanban Jobs in UT SaltLakeCity Consultant - (in Salt Lake City, UT))
 
 
(Developer: Agile/Scrum Environment, SQL Database, SSIS, Data Mapping Data Structures Troubleshoo in Madison, WI)
   
 
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
    About Us     Services    Privacy policy    Legal     Contact us     Copyright JobsInHand.com All Rights Reserved