Senior Forensic Data & BI Analyst

Chicago; Chicago, Northern (IL, KY); Hybrid; USD 79,000 - 128,000; Full time

Job summary

The City of Chicago’s Office of the Inspector General is seeking a Senior Information Analyst to develop and apply advanced data analytics, extracting near real-time information to support investigations.

Responsibilities include data extraction from multiple sources, quality reviews, dashboard development, and SQL scripting to meet data requirements, with a focus on analytical decision support and reporting.

Qualifications

• Six years of work experience in data analysis/management.
• Associate’s degree in computer sciences, information technology/systems, or related field with four years of data analysis experience.
• Bachelor’s degree in computer sciences, information technology/systems, or related field with two years of data analysis experience.
• Master’s degree or higher with one year of data analysis/management experience.

Responsibilities

• Extracts, merges, and analyzes large data sets from multiple sources.
• Performs quality reviews and resolves discrepancies in data sets.
• Generates statistical and narrative reports to summarize findings.
• Maintains dashboards and BI solutions.
• Develops SQL queries to extract and manage data.
• Communicates findings and supports investigations.

Skills

Data analysis

Programming

SQL queries

Data management

Education

Associate’s degree

Bachelor’s degree

Master’s degree

Tools

R

Tableau

Python

SPSS

MySQL

Oracle

Job description

The City of Chicago’s Office of the Inspector General is seeking a Senior Information Analyst to develop and apply advanced data analytics, extracting near real-time information to support investigations.

Responsibilities include data extraction from multiple sources, quality reviews, dashboard development, and SQL scripting to meet data requirements, with a focus on analytical decision support and reporting.