Senior information analyst

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 experience in 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: https://www.chicago.gov/city/en/depts/fin/benefits-office.html

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:

1. 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 [email protected]. 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.