Systems Analyst II — Data, Apps & Analytics

Cook County State's Attorney; Chicago, Northern (IL, KY); Hybrid; USD 60,000 - 85,000; Full time

Job summary

The Cook County State's Attorney's Office (CCSAO) seeks an Entry Level System Analyst for the MIS Department to support requirements gathering, development, testing, and implementation across multiple applications. You will coordinate with MIS teams to ensure solutions align with enterprise architecture and deliver thorough documentation.

Expect involvement in data interchange, collaboration with partner agencies, and ongoing training of staff.

Qualifications

• Bachelor’s degree preferred in Information Technology, Data Sciences, or other relevant program or other equivalent professional experience.
• Three (3) years of experience working with SQL Server databases.
• Three (3) years of experience developing and maintaining data pipelines.
• Strong knowledge of data structures and system design.
• Creative problem solver with the ability to self-teach.
• Organized with high attention to detail.
• Experience with data management/analysis.
• Solid understanding of multi-relational data structures.
• Comfortable working in an iteration-based environment.
• Candidate must have excellent communication skills both verbal and written.
• Strong interpersonal and communication skills, specifically the ability to communicate technical concepts to a non-technical audience.
• Self-starter who is comfortable working both independently and with a team.
• Candidate must have the ability to multi-task and work in a high paced environment.

Responsibilities

• Work with business units throughout the State’s Attorney’s Office to design, develop, and improve both current and new applications.
• Use industry-standard relational database best practices including but not limited to primary keys, logical deletes, update timestamps, changelogs, data normalization, and clear naming conventions.
• Create proper software development documentation, using best practices for product documentation, as well as QA, technical design, source code, API documentation, as needed for the project. Also maintain existing documentation through change processes. Create front-end interfaces based in user-centered design principles, for ease of use, consistency and helping completion of processes.
• Design and implement data replication from applications into a reporting and analysis database.
• Work with outside vendors employed to help the State’s Attorney’s Office as a team develop and implement applications such as case management systems.
• Work with other System Analysts to help the team develop high-quality products.
• Train staff on how to use applications.
• Provide maintenance and issue resolution support for applications.
• Stay current on the latest application development technologies.
• Regular access to confidential information; follow strict confidentiality protocols.
• Perform other duties or special projects, as assigned

Skills

SQL Server

Data pipelines

Data structures

System design

Communication skills

Self-starter

Education

Bachelor’s degree in Information Technology / Data Sciences

Master’s degree preferred

Tools

Power Platform

Dynamics 365 CE/CRM

Job description

The Cook County State's Attorney's Office (CCSAO) seeks an Entry Level System Analyst for the MIS Department to support requirements gathering, development, testing, and implementation across multiple applications. You will coordinate with MIS teams to ensure solutions align with enterprise architecture and deliver thorough documentation.

Expect involvement in data interchange, collaboration with partner agencies, and ongoing training of staff.