Senior Data Analyst – Investigations & BI

City of Chicago Office of Inspector General; Chicago (IL); On-site; USD 79,000 - 128,000; Full time

Job summary

City of Chicago Office of Inspector General is seeking a senior information analyst to develop and apply innovative data analysis techniques, enabling near real-time information extraction to support investigations. The role involves data collection, analysis, and modification of applications and scripts to meet data requests.

The position emphasizes creating dashboards with BI tools, conducting quality reviews, and producing narrative reports to summarize findings for OIG staff.

Qualifications

• Six years of work experience in data analysis/management, including one year in programming and modifying computer applications.
• Associate\'s degree in computer sciences, information technology/systems or related field with four years data analysis/management experience, including one year in programming.
• Bachelor\'s degree in computer sciences, information technology/systems or related field with two years data analysis/management experience, including one year in programming.
• Master\'s degree in computer sciences, information technology/systems or related field with one year data analysis/management and programming experience.

Responsibilities

• Extracts, merges, and analyzes large data sets from multiple sources.
• Performs quality reviews and resolves discrepancies, duplicates, and missing information.
• Compiles, develops, and generates statistical and narrative reports.
• Develops, maintains, and manages dashboards and other BI solutions.
• Develops basic to moderate SQL queries to extract and manage data.
• Recognizes business requirements and devises data solutions.
• Prepares reports, documents processes, and provides project presentations.
• Performs related duties as required.

Skills

Data analysis

Programming

SQL

Data management

Data visualization

Report writing

Education

Associate\'s degree

Bachelor\'s degree

Master\'s degree

Tools

Tableau

Power BI

Python

MySQL

Oracle

Job description

City of Chicago Office of Inspector General is seeking a senior information analyst to develop and apply innovative data analysis techniques, enabling near real-time information extraction to support investigations. The role involves data collection, analysis, and modification of applications and scripts to meet data requests.

The position emphasizes creating dashboards with BI tools, conducting quality reviews, and producing narrative reports to summarize findings for OIG staff.