Systems Analyst II

Cook-County-State; Chicago (IL); On-site; USD 85,000 - 105,000; Full time

Job summary

Cook County State's Attorney Office is seeking a System Analyst to lead requirements gathering, development, testing, and implementation across multiple applications. You will coordinate with MIS, Data, and Infrastructure teams, ensure SDLC discipline, and engage with partner agencies for data interchange.

The role emphasizes data architecture, documentation, and collaboration to deliver robust solutions while maintaining confidentiality and aligning with agency goals.

Qualifications

• Bachelor's degree or equivalent professional experience in IT/Data fields.
• 3 years of experience with SQL Server databases.
• 3 years building and maintaining data pipelines.
• Strong knowledge of data structures and system design.
• Excellent communication and self-teaching abilities.
• Detail-oriented with strong organizational skills.
• Experience with data management/analysis and relational data.
• Ability to work iteratively and multi-task in a fast-paced environment.

Responsibilities

• Collaborate with business units to design, develop, and improve applications.
• Apply relational database best practices: keys, deletes, timestamps, data normalization.
• Create and maintain software documentation, including QA and API docs.
• Develop front-end interfaces grounded in user-centered design.
• Design and implement data replication to a reporting/analytic DB.
• Work with external vendors to develop and implement systems.
• Collaborate with team members to deliver high-quality products.
• Train staff on using applications and provide support for maintenance.
• Stay current on latest development technologies and best practices.
• Handle confidential information with strict privacy protocols.
• Perform other duties or special projects as assigned.

Skills

SQL Server

Data pipelines

Data structures

System design

Communication skills

Data management

Relational data

Multi-tasking

Education

Bachelor's degree in IT/Data-related field

Master's degree preferred

Tools

Power Platform

Dynamics 365 CE/CRM

Job description

Should you have any questions concerning:

The Administrative Services Bureau, please call 312-603-1880

oremail to [e-mail]

Legal hiring for State Attorneys can be directed to

Careers At Cook County State's Attorney Office

Welcome to the Cook County State's Attorney Office Job Board. As one of the largest legal services providers in the nation employing over 700 attorneys, we are committed to not only upholding the law and safeguarding the rights of all citizens, but also fostering a diverse and inclusive work environment that reflects the community we serve.

Whether you are a seasoned professional or just starting your career, the Cook County State's Attorney's Office provides a wealth of opportunities to make a difference and serve the community. We are looking for dedicated individuals who are passionate about justice, equity, and public service.

Our Job Board is regularly updated with opportunities across a range of roles, from legal and administrative to investigative. Each role is integral to our mission and contributes significantly to our office's effectiveness.

By joining our team, you will be part of a dynamic workforce that values integrity, professionalism, and collaboration. You will have the chance to work on meaningful cases, learn from experienced colleagues, and contribute to creating a safer and more just Cook County.

Explore our current openings below and find where you fit in our mission to pursue justice and serve the public.

To do justice in the pursuit of thriving, healthy, and safe communities.

Our Vision:

We're committed to creating a safer, stronger Cook County. That means approaching every case with integrity, demanding accountability, and increasing our presence in the community. Our success is not measured convictions. We believe in doing what's right - fighting for the best, fairest outcomes, whatever form that takes. It's our responsibility to address the historic inequities in our justice system. Everyone deserves a fair shot at justice, regardless of their zip code, paycheck, or the color of their skin.

Level: Entry (This may vary for internal candidates)

Location: MIS Department/Various Locations

Bureau: Administrative Services

Division/Unit: MIS

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 applications or platforms, both new and existing. They coordinate with MIS internal teams, such as Infrastructure, to ensure the solution is aligned with the organization architecture and establish support plans, Project Management Office, to provide deliverables to projects, and Data, to understand data collection needs, discuss data structures and capabilities. They engage with different business practices to understand needs, gather requirements and collaborate on development work. 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:
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 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

Qualifications:

Required

• 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

Preferred Qualifications:

• Master's degree preferred in Information Technology, Data Sciences, or other relevant program or other equivalent professional experience
• Experience with Microsoft Power Platform and/or Dynamics 365 CE/CRM as a Developer or Administrator.
• Previous experience working for a local, county, state, or federal government agency in information technology, especially with legal or justice focused agencies, such as courts or law enforcement.
• An understanding of how to design meaningful data visualization

The Cook County State's Attorney's Office (CCSAO) is an equal opportunity employer, which seeks to recruit, develop, and retain the most talented people from a diverse candidate pool. The CCSAO does not discriminate on the basis of race, color, religion, sex, pregnancy, national origin, age, physical and mental disability, sexual orientation, gender identity, gender expression, and any other characteristic protected by federal, state, or local law. Upon request, the CCSAO will provide reasonable accommodation for qualified individuals due to a disability or pregnancy. The EEOP report can be found on our website at www.cookcountystatesattorney.org.

Any problems with your application can be directed towards [e-mail]