Systems Analyst II

The Cook County State's Attorney's Office (CCSAO) is a diverse and dedicated team of professionals committed to justice and safety for over five-million residents. As the second-largest prosecutor's office in the U.S., the CCSAO prosecutes criminal and regulatory violations across six bureaus and four units with a staff of over 1,200.

To uphold justice and public safety in Cook County by fairly, ethically, and effectively prosecuting crime, supporting victims, and protecting the rights of all residents.

We are seeking individuals who share our passion for justice, diversity, and the well-being of the community. Whether you are a legal professional, an investigator, or an administrative specialist, we value dedication, integrity, and a commitment to our values of accountability, respect, and fairness. Join our team if you are ready to make a tangible impact, work collaboratively, and uphold the principles of justice with unwavering dedication.

At the Cook County State's Attorney's Office, your skills and values will help shape a safer and stronger Cook County.

Job Title: Systems Analyst II (2 positions) #430

Reports to:

Chief Data Officer/Deputy CIO

Grade:19 (union)

Level: Entry (This may vary for internal candidates)

Location: MIS Department/Various Locations

Bureau: Administrative Services

Division/Unit: MIS

Final date to receive applications: February 11, 2026

Working Environment:

Hours:

Monday – Friday 8:30 a.m. to 4:30 p.m.

Primary Function:

System Analysts will perform requirements gathering, development, testing, and implementation on multiple data collection solutions, both new and existing. They will coordinate solutions and support across multiple business units within the State’s Attorney’s Office. They engage with different business units and Chief Data Officer to understand data collection needs, discuss data structures, and capabilities. They also engage with partner agencies to establish and execute data interchange processes when necessary.

It is important they utilize SDLC best practice to establish a complete and thorough approach to developing solutions.

Physical Requirements:
Sedentary work. Sedentary work involves lifting no more than 10 pounds at a time and occasionally lifting or carrying articles like docket files, ledgers, and small tools. Although a sedentary job is defined as one which involves sitting, a certain amount of walking and standing is often necessary in carrying out job duties.

Duties and Responsibilities:

• Work with business units throughout the State’s Attorney’s Office to design, develop, and improve both currently existing data collection systems as well as new data collection data systems
• Use industry-standard relational database best practices including but not limited to primary keys, logical deletes, update timestamps, change logs, data normalization, and clear naming conventions
• Design frontend interfaces that are user-centric, allowing users to enter data quickly as well as modify data once it has been entered
• Design and implement data replication from the data collection systems into a reporting and analysis database
• Work with outside vendors employed to help the State’s Attorney’s Office develop and implement data collection tools such as case management systems
• Work with other System Analysts to help them develop high-quality products
• Train staff on how to use the interface for data collection systems
• Develop training documentation around interface for data collection systems
• Maintain interface and data collection systems as unforeseen issues impact them
• Stay current on the latest data collection technologies
• Regular access to confidential information; follow strict confidentiality protocols.
• Perform other duties or special projects as assigned

Qualifications

• Bachelor’s degree preferred in Information Technology, Data Sciences, or other relevant program or other equivalent professional experience
• Three (3) years of experience in Dynamics 365 CE/CRM experience as Administrator and/or Developer
• Three (3) years of experience working with SQL Server or Oracle databases
• Three (3) years of experience developing and maintaining data pipelines
• Strong…