Senior Forensic Data Analyst

Accepting applications until filled.

To apply, please complete the application here.

Office of the Inspector General’s (OIG) Center for Information Technology & Analytics (CITA) conducts data analytics in support of OIG’s mission and manages OIG’s structural and operational IT infrastructure. In addition, CITA compiles large data sets for statistical models, trends, predictions, and analyses that enable OIG to develop cases, conducts citywide program reviews and audits, and monitor citywide hiring practices. CITA is also responsible for the implementation and ongoing support and maintenance of the infrastructure and applications which support OIG’s departments and mission.

Under the supervision of the Chief Forensic Data Analyst, the Senior Forensic Data Analyst (SFDA) will work with other CITA team members to provide critical support for timely and accurate data collection and analysis. The SFDA will conduct data analysis with both structured and unstructured large data sets, conduct data validation, create reports, and develop user-friendly dynamic Tableau dashboards to promote economy, effectiveness, efficiency, and integrity in City government. The SFDA will also assist with development, administration, and optimization of ETL processes.

DUTIES:

  • Develop advanced statistical models and techniques to analyze large, complex transactional and operational data extracted from City source databases to assist in the evaluation of deviations and trends in support of investigative and regulatory activities
  • Develop and employ innovative techniques for data mining and exploratory analytics resulting in the extraction of critical, near real-time information
  • Design and conduct data quality testing of source data; review data flow and usage to identify risks due to poor data quality and processing inefficiencies
  • Assist in troubleshooting and maintaining office data storage systems and provide technical expertise with external database connections
  • Review third-party source databases, develop data dictionaries, SQL queries, and ETL processes
  • Assist in developing project ideas, identifying training needs, and ensuring quality control of work product
  • Work with Chief Data Analysts to implement a consistent process for receiving and delivering data analytical services
  • Mentor and provide guidance to fellow team members as directed by the Chief Data Analyst
  • Perform related duties as required

MINIMUM QUALIFICATIONS: Graduation from an accredited college or university with a Bachelor’s degree in Computer Sciences, Information Technology/Systems, Business Administration or a directly related field, plus five years of data analysis or data management work experience, or an equivalent combination of education, training and experience. 

PREFERRED QUALIFICATIONS:

  • Advanced degree in data analytics, data science, predictive analytics, statistics, mathematics, or related field
  • Work experience in an investigatory or law enforcement organization
  • Work experience conducting statistical analysis

COMPREHENSIVE KNOWLEDGE OF:

  • Applicable computer software packages, including visualization software
  • Methods and techniques of data base analysis and design
  • Tools and techniques 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
  • Quantitative data analysis methods
  • Predictive data analysis methods

ANNUAL SALARY: Range $89,076 – $119,400 (annual increases)

Starting: $89,076 non-negotiable; Post successful six-month review $93,000

KNOWLEDGE SKILL AND ESSAY REQUIREMENT: A passing score on a knowledge skill test(s) and/or essay may be required.

Your application must include answers to the following two prompts:

  1. In less than 500 words, describe a specific life experience(s) or circumstance(s) in which you encountered adversity, resistance, obstacles, or failure. Describe how you overcame and/or handled the situation(s), with further consideration of what you learned that you believe gives you insights into the lived experience of residents and/or operations of institutions in a city like Chicago.
  2. In less than 500 words, describe a City of Chicago data source you think OIG should analyze: (1) why the data is important, (2) what aspect of the data you would analyze, (3) how you would visualize the information, (4) and what you would expect to learn. You can find examples of City data sources OIG has analyzed here: informationportal.igchicago.org.

TRAVEL AND SCHEDULE: Travel outside Chicago is not required.

Standard work hours are 8:30 a.m. – 4:30 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.

Employee Vaccination Requirement: City of Chicago employees must, as a condition of employment, be fully vaccinated against COVID-19 effective October 15, 2021. This Policy applies to all City employees. If you are not able to receive the vaccine for medical or religious reasons, you may seek approval for an exemption in accordance with applicable City processes. For more information on the vaccine policy please visit: www.chicago.gov/city/en/depts/dhr/supp_info/city-of-chicago-employee-vaccination-policy.html.

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 the OIG’s Chief Administrative Officer Keyla Vazquez at kvazquez@igchicago.org. 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 Office of Inspector General is contingent upon a satisfactory criminal background check.