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

We continually strive for a workforce that reflects the growing diversity within the State of Illinois. A variety of employee backgrounds, perspectives, ideas and experiences are crucial to our ability to most effectively serve the public. Bilingual skills welcome

Reasonable Accommodation Statement

The State of Illinois is committed to working with and providing reasonable accommodations to people with disabilities. Further, federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job, interview for a job, or for any other activity related to the hiring process. Examples of reasonable accommodation include, but are not limited to, making a change to the application process (if possible), providing documents in an alternate format, using a sign language interpreter, or using specialized equipment.

To be provided a Reasonable Accommodation during the hiring process, you will need to provide a certification of disability from a physician, psychiatrist, school official or an Illinois Department of Human Services (DHS) Division of Rehabilitation Services (DRS) Vocational Rehabilitation (VR) Counselor. Supporting documentation should be uploaded underMy Documents Additional Documentssection for each application.

Any questions on Reasonable Accommodations can be directed to Central Management Services Disability Resource Center at CMS.DisabilityResCen@illinois.gov or call (217) 524-7514 for further information and to request or discuss an accommodation.

Sponsorship for Employment

The State of Illinois does not provide sponsorship for employment visa status (e.g. H-1B visa status). To be considered for permanent employment with the State of Illinois, applicants must be currently authorized to work in the United States on a full-time basis.

Disclosure of Salary Information

In compliance with the Illinois Equal Pay Act, 820 ILCS 112/1 et seq., the State does not seek, request, or require a job applicant's wage or salary history. Employment decisions are not made based on an applicant's wage or salary history. To that end, pleasedo not include wage or salary information in your resume or other profile or application materials.

Springfield, IL, US, 62703

Agency: Department of Innovation and Technology

Posting Date:3/22/2024
Closing Date/Time:04/04/2024
Salary:$6,975 - $10,591 monthly
Job Type:Salaried
County:Sangamon
Number of Vacancies:2
Plan/BU:RC063

This position is a union position; therefore, provisions of the relevant collective bargaining agreement/labor contract apply to the filling of this position.

All applicants who want to be considered for this positionMUSTapply electronically through the illinois.jobs2web.com website. State of Illinois employees should click the link near the top left to apply through the SuccessFactors employee career portal.

Applications submitted via email or any paper manner (mail, fax, hand delivery) will not be considered.

Transcripts are required. If you don’t upload transcripts you will not be considered for the position.

Posting Identification Number36185

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

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

Minimum Qualifications

1. 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.
2. Requires three (3) years of professional experience in Applications Services, Business Intelligence, or a related Information Technology field.

Specialized Skills

1. Requires three (3) years of professional experience with Data Analytics.
2. Requires three (3) years of professional experience with Business Intelligence Tool Sets such as Power BI and Business Objects.
3. Requires three (3) years of professional experience with Relational Databases.
4. Requires three (3) years of professional experience with ETL Frameworks such as Azure Data Factory and SSIS.

Preferred Qualifications

1. Three (3) years of professional experience with Data Analytics.
2. Three (3) years of professional experience with Business Intelligence Tool Sets such as Power BI and
3. Business Objects.
4. Three (3) years of professional experience with Relational Databases.
5. Three (3) years of professional experience with ETL Frameworks such as Azure Data Factory and SSIS.
6. Extensive knowledge of Azure DevOps and the Azure subscription resources.
7. Ability to coordinate the activities of multi-level teams to achieve desired results.
8. 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.
9. Ability to gain and maintain effective working relationships with agency officials, associates, vendors, clients, and others.
10. Developed verbal and written communication skills to present information to others with clarity and precision.
11. Demonstrated organizational skills to manage multiple competing priorities.

Employment Conditions

• NOTE: 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 pass a position specific, agency required background check and self-disclosure of criminal history.
• 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.
• Requires the ability to use agency supplied equipment such as laptop, personal computer, work cell phone, etc.
• 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.

The conditions of employment listed are incorporated and/or related to any duties included in the position description.

Work Hours:8:30AM - 5:00PM M-F
Work Location:801 S 7th St Springfield, IL 62703-2487
Agency Contact:

Hilary Weston

Email: Hilary.Weston@illinois.gov

Posting Group:Science, Technology, Engineering & Mathematics; Public Safety

This position DOES contain “Specialized Skills” (as that term is used in CBAs).

The Department of Innovation & Technology (DolT) is the state's IT agency delivering an enterprise approach to statewide technology, innovation and telecommunication services, as well as policy and standards development, lifecycle investment planning, and cybersecurity services. With over 1,500 employees, DolT delivers IT services and innovative solutions to customer agencies to improve services provided to Illinois residents, DolT offers employees the opportunity to advance their careers, develop new skills and reach their potential, both personally and professionally. DoIT is committed to promoting and preserving a workplace culture that embraces diversity and inclusion. We welcome and value employees with different backgrounds, life experiences and talents. It is the collective sum of our individual differences that provides a broad perspective, leading to greater innovation and achievement. In recruiting for our team, we recognize the unique contributions of each applicant regardless of culture, ethnicity, race, national origin, sex, gender identity and expression, age, religion, disability, and sexual orientation.