> Markdown version of [/jobs/ext/1970661-business-intelligence-team-lead-information-systems-analyst-ii-option-a](https://www.wearedevelopers.com/jobs/ext/1970661-business-intelligence-team-lead-information-systems-analyst-ii-option-a). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Business Intelligence Team Lead (Information Systems Analyst II, Option A) - **Company:** State of Illinois - **Location:** Springfield, IL, United States - **Experience:** Expert - **Salary:** $96,720.0 - $142,212.0 - **Contract:** Permanent contract - **Skills:** Application Performance Management, Application Services, Microsoft Azure, Big Data, Information Systems, Databases, Continuous Integration, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Warehousing, Relational Databases, Software Debugging, Meta-Data Management, Regression Testing, Power BI, Screenshots, SQL Server Integration Services, Azure Data Factory, Sap Business Objects, Information Technology, Data Analytics, Tools for Reporting, Software Version Control - **Published:** August 7, 2026 - **Apply:** https://illinois.jobs2web.com/talentcommunity/apply/1416995800/?locale=en_US ## About the Role * Requires knowledge, skill, and mental development equivalent to completion of four (4) years of college with course work in computer science or directly related fields. * Requires three (3) years of professional experience in applications services or a related Information Technology field. Specialized Skills * Requires three (3) years of professional experience leading the development, enhancement, and governance of enterprise data warehouse solutions to support complex organizational reporting, analytics, and operational decision-making. * Requires three (3) years of professional experience directing the design and delivery of self-service, ad hoc, and interactive business intelligence reporting using tools including Power BI and Business Objects, with proven success advancing analytics adoption. * Requires three (3) years of professional experience architecting, optimizing, and managing relational database structures, queries, and data models to ensure secure, high-performance analytical and reporting operations. * Requires three (3) years of professional experience designing, developing, and maintaining scalable ETL pipelines using Azure Data Factory and SQL Server Integration Services (SSIS), ensuring accurate and reliable movement of data for dashboards and analytical products., * Three (3) years of professional experience leading the development, enhancement, and governance of enterprise data warehouse solutions to support complex organizational reporting, analytics, and operational decision-making. * Three (3) years of professional experience directing the design and delivery of self-service, ad hoc, and interactive business intelligence reporting using tools including Power BI and Business Objects, with proven success advancing analytics adoption. * Three (3) years of professional experience architecting, optimizing, and managing relational database structures, queries, and data models to ensure secure, high-performance analytical and reporting operations. * Three (3) years of professional experience designing, developing, and maintaining scalable ETL pipelines using Azure Data Factory and SQL Server Integration Services (SSIS), ensuring accurate and reliable movement of data for dashboards and analytical products. * Three (3) years of professional experience using Azure DevOps for source control, CI/CD automation, and project tracking with familiarity managing Azure cloud resources including configuration, provisioning, monitoring, and cost optimization. * Three (3) years of professional experience leading cross-functional teams or managing complex BI and data engineering projects, demonstrating the ability to coordinate multi-level technical and business stakeholders to deliver enterprise-wide solutions. * Ability to perform statistical analysis, identify trends, interpret complex datasets, and translate findings into actional insights that improve operational and strategic decision-making. * Extensive knowledge of implementing or maintaining data governance practices, including metadata management, data quality, and data assurance, architectural standards, and enterprise stewardship of analytical assets. * Extensive knowledge conducting unit, integration, acceptance, and regression testing for data warehouse, ETL, and reporting solutions, along with experience monitoring applications, troubleshooting issues, and responding to urgent operational incidents. * Developed communication and collaboration skills with the ability to gather requirements, translate business needs into scalable data solutions, advocate for analytics maturity, and facilitate the deployment and organization wide sharing of dashboards, reports, and data tools. Conditions of Employment The State of Illinois complies with federal and state disability laws and will make reasonable accommodation for applicants and employees with disabilities. Applicants must possess the ability to meet ALL of the following conditions of employment, with or without reasonable accommodation, to be considered for this position. * Requires the ability to verify identity. * Requires employment authorization to accept permanent full-time position with the State of Illinois. * Requires the ability to pass a position specific, agency required background check and self-disclosure of criminal history. * Requires the ability to use agency supplied equipment such as laptop, personal computer, work cell phone, etc. * Requires the ability to attend seminars, conferences, and training to remain current on methods, tools, ideologies or other industry related topics relevant to job duties. * Requires the ability to lift and carry objects or equipment weighing up to 10 pounds. This is considered sedentary work as defined by the U.S. Department of Labor (20 CFR 404.1567(a)). Sedentary work involves lifting no more than 10 pounds at a time and requires occasional lifting, carrying, walking, and standing. * Requires the ability to travel in performance of duties with overnight stays. * Requires the ability to work outside of normal hours to meet deadlines. * Requires the ability to serve in an on-call capacity. * The conditions of employment listed are incorporated and/or related to any duties included in the position description. ## Description PROOF OF EDUCATIONAL COURSEWORK IS REQUIRED. ACCEPTABLE PROOF OF COURSEWORK INCLUDES UNOFFICIAL TRANSCRIPTS, COPIES OF OFFICIAL TRANSCRIPTS, ACCOUNT RECORDS (INCLUDING SCREENSHOTS) OF ACADEMIC COURSEWORK, AND ANY SIMILAR DOCUMENTS CREATED BY AN ACADEMIC INSTITUTION. Are you looking for a rewarding career with an organization that values their staff? The Department of Innovation & Technology (DoIT) is seeking to hire qualified candidates with the opportunity to work in a dynamic, creative thinking, problem solving environment. This position serves as a Business Intelligence Team Lead supporting the Illinois State Police (ISP) developing and supporting a robust data warehouse portfolio and creation of interactive dashboards and visualizations. The main position objective is to support proactive, data-driven policing by providing quick and accurate business intelligence solutions to assist with operational decision-making. If you possess these knowledges, skills, abilities and experience, we invite you to apply for this position to join the DoIT Team!, * Under administrative direction, serves as Business Intelligence Team Lead for the Department of Innovation & Technology (DoIT) supporting the Business Intelligence Unit of the Illinois State Police (ISP) performing complex professional and advisory functions in Application Services. * Leads the design, development, and governance of database architecture and data engineering initiatives, including defining, documenting, and maintaining departmental metadata and data standards. * Provides design and development of complex reporting solutions and performs debugging, tuning, and documenting of all processes and components. * Interprets complex data and analyzes results using statistical techniques to provide ongoing reports. * Keeps abreast of new developments in the information technology field by continuing education through online training platforms, meetings, training sessions, seminars, and conferences to increase familiarity with and remain current on products, vendors, techniques, and procedures. * Performs other duties as assigned or required which are reasonably within the scope of the duties enumerated above. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [AI for decision-making in Tech Recruiting](https://www.wearedevelopers.com/videos/1074-ai-for-decision-making-in-tech-recruiting) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Gut Feeling Is Dead: Talent Intelligence Drives Workforce Planning](https://www.wearedevelopers.com/videos/1798-gut-feeling-is-dead-talent-intelligence-drives-workforce-planning) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer) - [What Industries Outside of AI Are Hiring The Most AI Experts?](https://www.wearedevelopers.com/magazine/98-what-industries-outside-of-ai-are-hiring-the-most-ai-experts) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)