Senior Information Analyst

Company: Civilian Office of Police Accountability
Location: Chicago
Posted on: May 17, 2025

Job Description:

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

Qualifications, skills, and all relevant experience needed for this role can be found in the full description below.
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 inhouse 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)

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 excel 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 webbased 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

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

Keywords: Civilian Office of Police Accountability, Joliet , Senior Information Analyst, Professions , Chicago, Illinois