Data Warehouse BI Analyst | Policy-to-Reporting Expert

Position: Business Analyst (Principal Consultant #1082) Location: Springfield Union: IFSOE Department: Software Solutions Anticipated Starting Salary Range: $62,449 - $78,917 Full Salary Range: $62,449 - $106,278 Office Hours: Monday – Friday 8:00 a.m. – 5:00 p.m. Posted Date: May 22, 2026 Duties and Responsibilities Engages with internal ISBE data owners, data stewards, data specialists and external partners to gather, clarify, and document business requirements for data warehouse enhancements and reporting needs. Translates educational policy requirements, state mandates, and federal reporting guidelines into clear technical specifications for development teams. Analyzes complex reports to identify trends, data quality issues, and opportunities for improved reporting. Collaborates with cross functional teams to align project goals, timelines, and technical solutions. Collaborates with data architects and data engineers to ensure data models support accurate, efficient, and scalable reporting. Executes data validation procedures to ensure accuracy, completeness, and data integrity across ISBE data systems. Documents business processes, data flows, data definitions, and system requirements to support transparency and continuity. Contributes to data governance efforts, ensuring adherence to privacy, security, and data strategy policies. Performs other duties as assigned. Required Qualifications Bachelor's degree or Associates degree in any field plus four years of business analyst experience in the last five years. (COPY OF TRANSCRIPTS REQUIRED AT TIME OF APPLICATION) Demonstrated ability to translate business requirements into technical specifications, including functional requirements, process flows, and reporting needs. Experience conducting business process analysis and workflow evaluation. Minimum 2-4 year experience in data warehouse architecture, BI tools, and SQL skills. Minimum 2-4 year experience with writing BRD/user stories. Basic understanding of ETL process. Experience documenting data warehouse architecture, data workflows, and technical procedures. Strong communication skills with the ability to present technical concepts in business friendly language. Preferred Qualifications Bachelor's degree in Business Administration, Information Technology (IT) or Computer Science. Experience with BI tools, including dashboard development and data model optimization. ISBE provides equal employment opportunities to all applicants without regard to race, color, religion, sex, national origin, age, disability, or genetics. We actively foster a culture of inclusion and encourage individuals of all backgrounds to apply. Illinois has an urgent and collective responsibility to achieve educational equity by ensuring that all policies, programs, and practices affirm the strengths that each and every child brings within their diverse backgrounds and life experiences, and by delivering the comprehensive supports, programs, and educational opportunities they need to succeed. #J-18808-Ljbffr