Chicago OIG

Visit to apply

The 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, conduct 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 Forensic Data Analyst-Database
Administrator (FDA-DBA) will work with other CITA team members to provide critical support for timely
and accurate data collection and analysis. The FDA-DBA will be responsible for implementing data
models, database designs, database maintenance, and storing data. Responsibilities will include
building and organizing data from a variety of sources and setting up new databases. The FDA-DBA
will also maintain policies and procedures for ensuring the security and integrity of Office databases.
In addition to the above, the FDA-DBA will regularly perform routine tests and modifications to ensure
that the data systems are performing and running correctly. If a problem occurs, the FDA-DBA will
troubleshoot systems.

Manage all OIG database instances, staging, and production environments, handling
installation, configuration, and maintenance

Manage day-to-day maintenance of OIG relational databases and data marts

Map out and document the conceptual design for new database features, design data flow
diagrams, and data models.

Review third-party source databases and develop data dictionaries and SQL queries

Develop, administer, monitor and document ETL processes

Assist technical and non-technical users in the development of SQL queries

Work closely with CITA staff to support all stages of data collection, cleaning, coding, and file
conversion into formats that are useful for analysis

Periodically perform validation for data accuracy

Provide technical and operational assistance to users, troubleshoot and resolve application
and database related problems

Independently analyze, solve, and correct issues in real time, providing problem resolution

Data management, with a strong background in relational database design with knowledge of
Microsoft SQL and MySQL Databases.

Developing Extract, Transform and Load (ETL) processes using Pentaho Data Integration
tools and MS SQL Server Integration Services (SSIS).

Relational data structures, theories, principles, and practices.

Working with Oracle and MySQL.

Data warehousing, dimensional design/modeling and ETL architectures.

Writing and reading complex SQL queries, stored procedures, triggers and views and program
in at least one other programming language (such as Python or Java)

Data sets matching and manipulating large amounts of data from multiple sources                                  • Documenting with superior details and accuracy
• Translating technical issues for non-technical audiences

• Proactivity, flexibility, and customer focused with strong organizational and follow-through
skills to create and execute work plans, prioritize work, manage multiple projects, and meet

• Oracle, Microsoft, etc. data technology environments.

• Data modeling tools such as SQL Developer Data Modeler

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 two years of data analysis or data management work experience, or an equivalent
combination of education, training and experience.

ANNUAL SALARY: Range: $81,552 – $112,164 (annual increases) Starting $81,552 (non-negotiable); Post successful six-month review $85,248

TRAVEL AND SCHEDULE: Travel outside Chicago is not required. Standard work hours are 8:30am-4:30pm, 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 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. Identify a City of Chicago data source you think OIG should analyze. In
less than 500 words, describe: (1) why this data is important, (2) what
aspect of the data you would evaluate, (3) how you would go about
analyzing the information, (4) and what you would expect to learn. You
can find examples of City data sources OIG has analyzed here:

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:

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 Supervisor of Personnel Administration Keyla Vazquez at Please be prepared to provide information in support of your reasonable accommodation request.

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.

To apply for this job please visit