Business Intelligence Team Lead (Information Systems Analyst II Option A)

at Illinois Department of Innovation & Technology in Springfield, Illinois, United States

Job Description

40%    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): 

• Serves as a Team Lead in the development and maintenance of a robust data warehouse portfolio serving the analytical and reporting needs of the Illinois State Police (ISP).  
• Serves as an ambassador for analytics and facilitates all development of new analytical capabilities.
• Monitors applications, answers technical questions, and responds to emergency requests when problems arise.  
• Serves as a resource and contact for users.

25%    Leads efforts for defining, documenting, and maintaining departmental metadata:

• Leads efforts for the creation, maintenance, and dissemination of ad hoc, self-service, and interactive reports and visualizations
• Facilitates the production and sharing of analytical tools and dashboards. 
• Utilizes Business Intelligence Tool Sets such as Power BI and Business Objects, Relational Databases, Extraction, Transformation, and Loading (ETL) Frameworks such as Azure Data Factory, SQL Server Integration Services (SSIS), Azure DevOps, and the Azure subscription resources in performance of duties. 
• Performs evaluations of user requirements for new and existing reports and dashboards.

10%    Provides design and development of complex reporting solutions:

• Performs debugging, tuning, and documenting of all processes and components.  
• Performs unit, integration, acceptance, and regression testing to verify that reporting processes function correctly and meet requirements.

10%    Interprets complex data and analyzes results using statistical techniques and provides ongoing reports:

• Mines data sources, identifies trends, and crucial data. 
• Communicates findings and recommends solutions for more meaningful analysis and interpretation.

10%    Keeps abreast of new developments in the Information Technology (IT) field:

• Continues education by attending meetings, training sessions, seminars, and conferences to increase familiarity with and remain current on IT products, vendors, techniques, and procedures.
• Attends demonstrations and exhibitions related to assigned operations.

5%    Performs other duties as assigned or required which are reasonably within the scope of the duties enumerated above