Public Instruction, Department ofBusiness Intelligence (BI) Business Analyst - IS Systems Development Services Specialist - - Re-Announcement
Job Announcement Code(s): 14-00094
The Department of Public Instruction (DPI) is committed to ensuring every child graduates ready for further education and the workforce. We must align our efforts so students are learning the skills and knowledge necessary to become contributing members of our communities. To build on our long-standing commitment to public education, we strive to recruit and retain quality employees. Our employees are vital to the success of our students, schools and communities. For more information about DPI, please go to http://www.dpi.wi.gov.
The Department of Public Instruction, the Division for Libraries and Technology, is currently seeking a BI Business Analyst. This position is located at 125 South Webster Street, Madison.
The IT team within DPI plays a vital role in meeting the department’s mission. More than ever before, the transformation of education hinges on technology. Our teams are leading many cutting edge efforts to realize the potential of technology in schools and classrooms. Whether it is to create new possibilities through personalized learning experiences for students or by simply creating efficiencies for the educators who serve children, our goal is to support our districts, schools, and classrooms wherever and however we can. You can learn more about our IT efforts here: https://www.youtube.com/watch?v=dJp1yT-l1Ao.
This is a reannouncement which was previously published 1/9 to 2/3, 2/5 to 2/24, and 4/10 to 4/29. Job Duties:
This position is responsible for building relationships and acting as a liaison between other technical teams and content areas. This position is also responsible for providing technical expertise and assistance regarding the analysis, development and maintenance of components for various data warehouse and decision support projects including those that support school districts, schools, and classrooms as well as state and federal reporting. The primary framework for the environment is the Edvantage K-12 data warehouse model, extract, transformation and load (ETL) framework, and dashboards and the Microsoft business intelligence toolset, i.e., SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). This position will be responsible for developing dashboards and reports; working with the SQL Server data warehouse; conducting ad hoc data analysis; creating SQL queries and scripts; and working with SQL Server and Oracle technologies in addition to SSIS, SSRS, and Team Foundation Server (TFS).
A criminal background check will be conducted prior to an offer of hire.
Knowledge of Agile/Scrum methodologies and practices; data analysis techniques; data warehouse infrastructure including application servers, web servers, product configuration including security administration; SQL Server and Oracle database technologies; data verification and problem solving techniques; ETL solutions using batch processing and job stream development; complex data analysis and reporting technique; metadata frameworks; data warehouse and decision support systems design and development; and security administration in business intelligence products. Ability to code using SQL and PL/SQL functions; to create SSIS packages, SSRS reports, and data dashboards; to use Team Foundation Server for source control; to perform systems analysis and design; to retrieve, analyze, and interpret data from a variety of sources; to perform quality assurance; to work in a team collaborative environment; and to communicate effectively verbally and in writing.
If you have not already done so, you will need to create an account. After you are logged in and are viewing the announcement, click "Apply Now." You will be asked to provide your personal information, attach a resume, and complete the online exam. You can preview the exam questions by clicking on the “Preview Exam” link above. After reviewing the exam questions, prepare detailed written responses to each of the three (3) exam questions. Submit your exam responses by copying and pasting your responses into the appropriate fields in the online exam. Your response to the exam questions will be used along with your resume to determine your eligibility for this position. Online applications that do not include all of the requested materials will NOT be considered.
state agency directory
|Contact Us | Legal Notices | Privacy Notice ||
|If you are experiencing difficulty on this site due to a disability, please contact the WiscJobs help desk at firstname.lastname@example.org or TTY relay 711.|
State of Wisconsin
Office of State Employment Relations
101 East Wilson Street PO Box 7855 Madison, WI 53707
WiscJobs © 2001 - 2014