SENIOR INFORMATION ANALYST

JOB/BID ANNOUNCEMENT

Senior Information Analyst

Civilian Office of Police Accountability

Number of Positions: 1 (Additional vacancies possible pending budget approval)

This position is open to the public and all current city employees covered under the City's Collective Bargaining Agreement with AMERICAN FEDERATION OF STATE, COUNTY, AND MUNICIPAL EMPLOYEES (AFSCME) - BARGAINING UNIT 1, 3, 4 & 5. Only employees in City job titles in this bargaining unit are eligible to bid.

BID INSTRUCTIONS: Apply on the bid site: https://chicago.taleo.net/careersection/103/jobsearch.ftl?lang=en AND

1. Check the box on your profile titled "Currently employed by the City of Chicago"

2. Enter your employee ID (located on your pay stub labeled 'payee/employee number')

3. Select your correct bargaining unit

FAILURE TO FOLLOW THESE INSTRUCTIONS WILL RESULT IN A REJECTED BID APPLICATION

This position with the Civilian Office of Police Accountability (COPA) and has a core responsibility that includes creating, running and enhancing SQL queries to extract data from COPA's data warehouse in response to internal and external data requests. Related responsibilities include collaborating with technical and non-technical staff to understand the agency's work flows, investigative processes, and related data needs as well as documenting and sharing knowledge about the data warehouse. The job will also require frequent development and updating of summary data reports and data visualizations (e.g. annual reports and dashboards) used to monitor and assess organizational performance and communicate with the public.

ESSENTIAL DUTIES:

• Receives, reviews, and prioritizes internal and external information requests (e.g., e-discovery, freedom of information, investigative) for electronically stored data, images, and documents.
• Creates data reports, builds dashboards, builds data models, analyzes datasets and administers PowerBI tools.
• Connect data sources, import data and transform data for business intelligence.
• Write optimized SQL queries for integration with other applications.
• Develops scripts, procedures, and triggers for application development.
• Maintains data quality and backups.
• Follows established guidelines and requirements in validating requests for information and consults with COPA in-house attorneys.
• Tracks and manages information requests from various sources and ensures expectations and deadlines are met.
• Extracts, indexes, merges, and manipulates large and multiple data sets into database sources.
• Performs technical and analytical functions using electronic software tools.
• Performs data quality reviews and validates converted information in preparation for database creation.
• Converts data and images into various formats for reporting purposes.
• Prepares tables, charts and graphs and forwards information to the requestor.
• Summarizes findings and prepares narrative reports to explain data results.
• Proactively analyzes data to identify trends and support pattern and practice investigations.
• Supports data analysis needs of the Policy and Legislative Affairs and Public Affairs groups.
• Performs other duties, as required.

NOTE: The list of essential duties is not intended to be inclusive; there may be other duties that are essential to particular positions within the class.

Location: Civilian Office of Police Accountability (COPA)

1615 W. Chicago Ave, 4^th floor, Chicago, IL 60622

Days: Monday - Friday

Hours: 9:00am to 5:00pm

Salary: $73,140 (non-negotiable)

THIS POSITION IS IN THE CAREER SERVICE

Graduation from an accredited college or university with a Bachelor's degree, plus one year of experience in data analysis/management OR one year of experience performing fact finding research, analysis and reporting, or an equivalent combination of education, training and experience.

Selection Requirement: This position requires applicants to complete an interview which will include an SQL skills assessment test as part of the interview. The interviewed candidate(s) possessing the qualifications best suited to fulfill the responsibilities of the position, based on the oral and written parts of the interview will be selected.

Preference will be given to candidates possessing the following:

• Master's Degree in a related Social Science discipline such as Statistical Analysis, Big Data, Public Policy, Criminal Justice, etc.
• Previous experience with SQL Server Management Studio (SSMS), PowerBI, Python, Microsoft Azure, and web-based code repositories.
• Previous experience writing code to query relational databases.
• Previous experience developing, refining, and documenting data governance standards.
• Previous experience performing data analysis and management, preparing statistical reports and producing and describing summary tables, charts, and graphs.
• Previous experience collaborating with data scientists, data engineers, and/or database developers.
• The ability to read, write and speak any language other than English fluently.

Residency Requirement: All employees of the City must be actual residents of the City as outlined in 2-152-050 of the City Chicago Municipal Code. Proof of residency will be required.

ALL REFERENCES TO POLITICAL SPONSORSHIP OR RECOMMENDATION MUST BE OMITTED FROM ANY AND ALL APPLICATION MATERIALS SUBMITTED FOR CITY EMPLOYMENT.

Please note, all positions with the City of Chicago close promptly at 11:59pm C.S.T. Applications for this position will be accepted from May 16, 2025, until 11:59p.m. CST on May 30, 2025. No exceptions will be made.

The City of Chicago is an Equal Employment Opportunity and Military Friendly Employer

The City of Chicago is committed to providing fair chance hiring and welcomes applicants with past convictions, recognizing the value of a diverse workforce and the potential for growth and positive change.

City of Chicago

Brandon Johnson, Mayor