Systems Analyst II

Cook County State's Attorney Office•Chicago, IL

About The Position

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 States Attorneys 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. Working Environment: Hours: Monday Friday, 8:30 4:30 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.

Requirements

Bachelors 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 in developing .NET, C#, ASP.NET, Oracle Application Express & JavaScript programming (web services & web API applications)
Three (3) years of experience working with SQL Server or Oracle 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

Nice To Haves

Masters degree preferred in Information Technology, Data Sciences, or other relevant program or other equivalent professional experience
Previous experience working for a local, county, state, or federal government agency in information technology
An understanding of how to design meaningful data visualization

Responsibilities

Work with business units throughout the States Attorneys 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, changelogs, 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 States Attorneys 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