Starting pay for this position is $28.560
to $41.500 per hour (approximately
$59,633 to $86,652 per year) depending on qualifications. This position is in pay
schedule 07, range 33. A six month
probationary period is required.
Are you looking for a Business Intelligence (BI) Business Analyst position? If so, the DPI has a position for you!
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).
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.
Apply Online! 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.