-
ID
#46079002 -
Job type
Contract -
Salary
Depends on Experience -
Source
Digitek Software, Inc. -
Date
2022-09-28 -
Deadline
2022-11-26
SQL Developer
Wisconsin, Madison, 53701 Madison USAContract
Vacancy expired!
One of our clients is looking
SQL/ ETL Developer based on the following skills: Top Skills & Years of ExperienceInterview 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 or hybrid. WI residency is not required. Candidates can be 100% remote. Residents near Madison can choose to come into the office if they desire. Career-Level position within field. Requires experience and proficiency in discipline. Conducts complex work important to the organization. Works with minimal supervision with wide latitude for independent judgment. Typically requires six to nine years experience or equivalent education. ETL Developer Wisconsin Department of Public InstructionData Warehouse and Decision Support teamThis 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 agency’s 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 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 also responsible for the development and maintenance of data processing and building reports and dashboards Power BI. These systems require extensive knowledge and experience developing complex technology and relational design using SQL Server, SSIS, Power BI reporting tools (Desktop and Service). General knowledge the Microsoft Suite of tools and Google Suite is important. 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)
- Power BI developer
- Experience working on an Agile/Scrum team
- Able to work well in a team, but also highly self-motivated
- Experience with K-12 education data sector
- 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.
- 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 performance tuning tasks as necessary.
- Create operational processes including test cases & user documentation
- Using TFS (Visual Studio/Azure Dev Ops) for source code control, project related document sharing and team collaboration
- Regular maintenance of STAR assessment loads in the data warehouse as it includes several districts
- Upgrading the SSIS packages in both file system and package deployment model to latest versions (currently upgraded to 2016)
- Work on generating the EDfacts files used for Federal reporting
- Develop Power BI Desktop reports and public to Power BI service.
- Work with Microsoft Azure databases and SSIS packages
- Other duties as assigned relating to the data warehouse project.
Vacancy expired!
Report job