Senior information 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

Under the guidance of a chief forensic data analyst, this position develops and employs innovative techniques for data analysis, resulting in the extraction of critical, near real-time information. Senior information analysts are responsible for collecting and analyzing data to support OIG staff in the conduct of assigned investigations and develops and modifies computer applications and scripts to extract requested information.

DUTIES:

• Extracts, merges, and conducts analysis of large data sets from multiple external data sources
• Performs quality reviews of large volumes of data sets, resolves discrepancies, duplicates, missing information, and validates information
• Compiles, develops, and generates statistical and narrative reports to summarize findings
• 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 solutions to meet data requirements
• Prepares reports, documents process, and provides project presentations
• Performs related duties as required

MINIMUM QUALIFICATIONS:

• Six (6) years of work experience in data analysis/management, of which one (1) year work experiencein programming and modifying computer applications, OR
• Graduation from an accredited college with an associate’s degree in computer sciences, information technology/systems or a directly related field, plus four (4) years of work experience in data analysis/management, of which one (1) year is in programming and modifying computer applications, OR
• Graduation from an accredited college or university with a bachelor’s degree in computer sciences, information technology/systems or a directly related field, plus two (2) years of work experience in data analysis/management, of which one (1) year is in programming and modifying computer applications, OR
• Graduation from an accredited college or university with a master’s degree or higher in computer sciences, information technology/systems or a directly related field, plus one (1) year of work experience in data analysis/management and programming and modifying computer applications

PREFERRED QUALIFICATIONS:

• Graduation from an accredited college or university with a degree in data science, predictive analytics, statistics, mathematics, or information management
• Work experience in an investigatory or law enforcement organization
• Work experience with data visualization software products, e.g. Tableau, Power BI, etc.

MODERATE KNOWLEDGE OF:

• Quantitative data analysis methods
• Methods and techniques of database analysis and design
• Tools to query and analyze data in a relational database
• Software and data management tools such as R, Tableau, Python, SPSS, MySQL, Oracle or other similar tools
• Structured Query Language (SQL) and reporting platforms
• Data mining processes and tools
• Report writing to summarize findings/results

ANNUAL SALARY:

Range: $78,768 – $128,316 (annual increases). Starting $78,768 (non-negotiable); Post six-month review $82,524.

BENEFITS:

For information on City of Chicago employees’ benefits, please visit our benefits website .

TRAVEL AND SCHEDULE:

Travel outside Chicago is not required. Standard office hours are 9:00 a.m. – 5:00 p.m., flexibility permitted.

RESIDENCY REQUIREMENT:

Employees must be a resident of the City of Chicago and proof of residency is required at the commencement of employment.

KNOWLEDGE SKILL AND ESSAY REQUIREMENT:

A passing score on a knowledge skill test(s) and/or essay may be required. Your application must include a response to the following prompt:

In about 500 words, describe a time when you analyzed complex information to identify an important trend, issue, or opportunity. Explain the approach you took, how you communicated your findings, and how your analysis informed a decision or next step.

WE VALUE DIVERSITY

The Office of the Inspector General (OIG) is an equal opportunity employer.

OIG is an inclusive organization that hires and develops all its staff of all levels regardless of race, religion, color, ethnicity, national origin, ancestry, marital or parental status, sex, gender expression or identity, sexual orientation, physical or mental ability, age, veteran status, and all other characteristics protected by law.

OIG strives to create the kind of workplace where a socially diverse mix of people can thrive professionally. We pride ourselves in meeting our legal charge to promote economy, effectiveness, efficiency, and integrity in government. Through the hard work of our passionate and innovative team, OIG aims to serve every community with equity, respect, and dignity.

If you would like to request a reasonable accommodation due to disability or pregnancy to participate in the application process, please contact OIG’s Manager of Human Resources Eloise Markham at [e-mail] . Please be prepared to provide information in support of your reasonable accommodation request.

THE CITY OF CHICAGO IS AN EQUAL OPPORTUNITY AND MILITARY FRIENDLY EMPLOYER

In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire. The City of Chicago does not participate in E-Verify (Employment Eligibility Verification System). In addition, employment at the OIG is contingent upon a satisfactory criminal background check.

NOTIFICATION REGARDING USE OF ARTIFICIAL INTELLIGENCE (AI)

The submission of written materials (e.g., writing sample, essay, cover letter) generated in-part or fully by AI is strongly discouraged. Candidates who submit AI generated written materials may be disqualified from further consideration.