Business Intelligence Team Lead

Job Title: Business Intelligence Team Lead

Job Requisition ID: 51322

Closing Date: 12/02/2025

Salary: $7,787/month

Work Location: Springfield, IL

Union Position: Yes

Work authorization: US work authorization required at time of application. No sponsorship available. Not eligible for STEM OPT. Positions are W2 only and cannot be converted to a contract position. 

Questions? Email doit.recruitment@illinois.gov

Transcripts are required for consideration.

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!

As a State of Illinois employee, you receive a comprehensive benefits package including:

• Competitive Group Insurance benefits including health, life, dental and vision plans
• Flexible work schedules (when available and dependent upon position)
• 10 -25 days of paid vacation time annually (10 days for first year of state employment)
• 12 days of paid sick time annually which carryover year to year
• 3 paid personal business days per year
• 13-14 paid holidays per year dependent on election years
• 12 weeks of paid parental leave
• Pension plan through the State Employees Retirement System
• Deferred Compensation Program – voluntary supplemental retirement plan
• Optional pre-tax programs -Medical Care Assistance Plan (MCAP) & Dependent Care Assistant Plan (DCAP)
• Tuition Reimbursement Program and Federal Public Service Loan Forgiveness Program eligibility

For more information regarding State of Illinois Benefits follow this link: https://www2.illinois.gov/cms/benefits/Pages/default.aspx

Essential Functions

• Under administrative direction, serves a 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 efforts for defining, documenting, and maintaining departmental metadata.
• 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.

Minimum Qualifications

• 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.

Preferred Qualifications (In Order of Significance)

• Three (3) years of professional experience leading the development and maintenance of enterprise data warehouse solutions to support organizational reporting and analytics.
• Three (3) years of professional experience leading the development of self-service and interactive reporting solutions using Business Intelligence Tool Sets such as Power BI and Business Objects.
• Three (3) years of professional experience with Relational Databases, including designing queries, optimizing performance, and managing data structures to support reporting and analytics.
• Three (3) years of professional experience utilizing ETL Frameworks such as Azure Data Factory and SQL Server Integration Services (SSIS) to design, develop, and maintain dashboards and reports.
• Three (3) years of professional experience utilizing Azure DevOps for managing code repositories, CI/CD pipelines, and project tracking; familiarity with Azure cloud services including resource provisioning and cost management.
• Three (3) years of experience leading cross-functional teams or managing projects in a data analytics or business intelligence environment, with the ability to coordinate the activities of multi-level teams to achieve desired results.
• Extensive knowledge of implementing or maintaining data governance practices, including metadata management, data quality, and data stewardship.
• Ability to analyze data logically and exercise sound judgment in defining, evaluating, and solving difficult administrative, organizational, technical, or operational problems where solutions may be of a precedent-establishing or research nature.
• Developed verbal and written communication skills with the ability to clearly convey complex technical information to diverse audiences, along with a demonstrated ability to establish and maintain effective working relationships with agency officials, colleagues, vendors, and clients.
• Strong organizational skills with a demonstrated ability to manage multiple, high-priority tasks and deadlines in a fast-paced environment.

Conditions of Employment

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.