Senior information analyst

City of Chicago Office of Inspector General; Chicago (IL); In loco; USD 79.000 - 128.000; Tempo pieno

Descrizione del lavoro

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.

Competenze

• 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.

Mansioni

• 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.

Conoscenze

Data analysis

Programming

SQL

Data management

Data visualization

Report writing

Formazione

Associate\'s degree

Bachelor\'s degree

Master\'s degree

Strumenti

Tableau

Power BI

Python

MySQL

Oracle

Descrizione del lavoro

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.

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:

• 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.