Cook County State's Attorney Office
Data Integration Analyst
Cook County State's Attorney Office, Chicago, Illinois, United States, 60290
Should you have any questions concerning:
The Administrative Services Bureau, please call 312-603-1880
oremail to HRCC.SAO@cookcountyil.gov
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.
Clicking on the links below will redirect you to ClearCompany for application submission.
Reports To Chief Data Officer/Deputy CIO
Grade/Step 19/E
Location While the location is posted as 69 W Washington, this role will be expected to travel to various courthouse locations throughout Cook County
Bureau Administrative Services
Division/Unit MIS
Working Environment Hours: Monday – Friday 8:30 a.m. to 4:30 p.m.
General Description The Management Information Systems Department of the Cook County State’s Attorney’s Office is looking for a Data Integration Analyst to collaborate with staff across the office and help design data systems and processes that enhance data collection, transfer, insight generation, and operational implementation related to the work of the Cook County State’s Attorney. A DIA transforms raw data into actionable insights to support business decisions. They collect, clean, analyze, and visualize data using tools like Excel and Tableau. Key responsibilities include identifying trends, creating reports, and collaborating with teams to inform strategies. DIAs will be responsible for identifying and executing opportunities to increase public transparency about the office's activities, as well as developing innovative visualizations to improve user experience.
Working Environment and Reporting Structure The Data Integration Analyst will engage with prosecutors, administrative staff, and investigators throughout the office. They will report directly to the Chief Data Officer.
Duties and Requirements 1. Data Quality and Integrity
Ensure that data is accurate, consistent, and reliable throughout its lifecycle, which is critical for making valid and trustworthy decisions
Cleanse data and scrutinize computer-generated reports and outputs to identify and rectify coding errors
2. Collecting Data from Various Sources
Gather data from various sources, including databases, APIs, and third‑party sources, and ensure the upkeep of databases and data systems.
3. Developing and Supporting Reporting Processes
Create and maintain processes to generate accurate and timely reports that help stakeholders understand and act on key data insights
Identify opportunities for process enhancements
Engage with managers from various departments to specify data requirements for analysis projects tailored to their unique business processes
4. Developing Automated Processes for Data Scraping
Design scripts and tools to automatically extract large volumes of data from websites or other digital sources, improving efficiency and availability.
Detect, examine, and decode trends or patterns within intricate datasets
Employ statistical techniques to scrutinize data and produce actionable business insights
Your analyses will help extract meaningful insights and trends, which can then inform business decisions and strategies
Develop data dashboards, charts, and visual aids to support decision‑making across departments
6. Performs Complex Analyses
Conduct in-depth data analyses using advanced statistical methods and tools to uncover patterns, correlations, and insights
7. Maintaining Databases
You will be entrusted with the responsibility of managing and updating databases to ensure they are secure, accessible, and functioning properly. Your role is crucial in supporting ongoing data storage and retrieval needs.
Coordinate with management to align business and informational priorities
Collaborate with the management team to determine and rank the needs of different business units.
Beyond developing better internal systems around data, DIAs will also be responsible for helping develop and improve data sets and analysis for the public and as well as researchers who are working with the office. DIAs will spend part of their time providing technical training to individuals both within and outside of the office to better understand our methodologies and utilization of best practices as it relates to data sources, extraction, analysis, and visualization.
Minimum Qualifications
A bachelor's degree in Computer Science, Information Management, Statistics, or a comparable discipline from an accredited educational institution of higher learning is required.
A minimum of 2 years of experience in data services or sciences supporting data infrastructure, SQL scripting, analytics, and/or visualization.
Python or SQL Certification from an accredited vendor or educational institution.
Able to manipulate large data (100,000+ rows) sets in Microsoft Excel, SQL, R, STATA
Two or more of the following disciplines:
Experience building out and maintaining data pipelines/ETL jobs
Proficiency with data visualization tools such as Power BI or Tableau
Proficiency in programming, particularly with PowerShell and SQL
Experience developing workflow systems focused on capturing high‑quality data
Familiarity with programming languages such as Python, PowerShell, R, SQL, STATA, VBA
Preferred Qualifications
A master’s degree in Computer Science, Information Management, Statistics, or a comparable discipline from an accredited educational institution of higher learning.
3 years’ experience in technology support focused on desktops, Microsoft applications, and other prosecution‑related technologies.
Expert level of proficiency in programming, particularly with PowerShell and SQL
Knowledge, Skills & Abilities
Organized with high attention to detail
Experience with data management/analysis
Creative problem solver with the ability to self‑teach
Solid understanding of multi‑relational data structures
Comfortable working in an iteration‑based environment
Ability to build relationships and trust across departments
Ability to manage multiple tasks and projects concurrently
Self‑starter who is comfortable working both independently and with a team
Strong interpersonal and communication skills, specifically the ability to communicate technical concepts to a non‑technical audience
An understanding of criminal justice systems
An understanding of how to design a meaningful data visualization
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. Jobs are sedentary if walking and standing are required occasionally, and other sedentary criteria are met.
EEO Message 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 HRCC.SAO@Cookcountyil.gov
#J-18808-Ljbffr
The Administrative Services Bureau, please call 312-603-1880
oremail to HRCC.SAO@cookcountyil.gov
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.
Clicking on the links below will redirect you to ClearCompany for application submission.
Reports To Chief Data Officer/Deputy CIO
Grade/Step 19/E
Location While the location is posted as 69 W Washington, this role will be expected to travel to various courthouse locations throughout Cook County
Bureau Administrative Services
Division/Unit MIS
Working Environment Hours: Monday – Friday 8:30 a.m. to 4:30 p.m.
General Description The Management Information Systems Department of the Cook County State’s Attorney’s Office is looking for a Data Integration Analyst to collaborate with staff across the office and help design data systems and processes that enhance data collection, transfer, insight generation, and operational implementation related to the work of the Cook County State’s Attorney. A DIA transforms raw data into actionable insights to support business decisions. They collect, clean, analyze, and visualize data using tools like Excel and Tableau. Key responsibilities include identifying trends, creating reports, and collaborating with teams to inform strategies. DIAs will be responsible for identifying and executing opportunities to increase public transparency about the office's activities, as well as developing innovative visualizations to improve user experience.
Working Environment and Reporting Structure The Data Integration Analyst will engage with prosecutors, administrative staff, and investigators throughout the office. They will report directly to the Chief Data Officer.
Duties and Requirements 1. Data Quality and Integrity
Ensure that data is accurate, consistent, and reliable throughout its lifecycle, which is critical for making valid and trustworthy decisions
Cleanse data and scrutinize computer-generated reports and outputs to identify and rectify coding errors
2. Collecting Data from Various Sources
Gather data from various sources, including databases, APIs, and third‑party sources, and ensure the upkeep of databases and data systems.
3. Developing and Supporting Reporting Processes
Create and maintain processes to generate accurate and timely reports that help stakeholders understand and act on key data insights
Identify opportunities for process enhancements
Engage with managers from various departments to specify data requirements for analysis projects tailored to their unique business processes
4. Developing Automated Processes for Data Scraping
Design scripts and tools to automatically extract large volumes of data from websites or other digital sources, improving efficiency and availability.
Detect, examine, and decode trends or patterns within intricate datasets
Employ statistical techniques to scrutinize data and produce actionable business insights
Your analyses will help extract meaningful insights and trends, which can then inform business decisions and strategies
Develop data dashboards, charts, and visual aids to support decision‑making across departments
6. Performs Complex Analyses
Conduct in-depth data analyses using advanced statistical methods and tools to uncover patterns, correlations, and insights
7. Maintaining Databases
You will be entrusted with the responsibility of managing and updating databases to ensure they are secure, accessible, and functioning properly. Your role is crucial in supporting ongoing data storage and retrieval needs.
Coordinate with management to align business and informational priorities
Collaborate with the management team to determine and rank the needs of different business units.
Beyond developing better internal systems around data, DIAs will also be responsible for helping develop and improve data sets and analysis for the public and as well as researchers who are working with the office. DIAs will spend part of their time providing technical training to individuals both within and outside of the office to better understand our methodologies and utilization of best practices as it relates to data sources, extraction, analysis, and visualization.
Minimum Qualifications
A bachelor's degree in Computer Science, Information Management, Statistics, or a comparable discipline from an accredited educational institution of higher learning is required.
A minimum of 2 years of experience in data services or sciences supporting data infrastructure, SQL scripting, analytics, and/or visualization.
Python or SQL Certification from an accredited vendor or educational institution.
Able to manipulate large data (100,000+ rows) sets in Microsoft Excel, SQL, R, STATA
Two or more of the following disciplines:
Experience building out and maintaining data pipelines/ETL jobs
Proficiency with data visualization tools such as Power BI or Tableau
Proficiency in programming, particularly with PowerShell and SQL
Experience developing workflow systems focused on capturing high‑quality data
Familiarity with programming languages such as Python, PowerShell, R, SQL, STATA, VBA
Preferred Qualifications
A master’s degree in Computer Science, Information Management, Statistics, or a comparable discipline from an accredited educational institution of higher learning.
3 years’ experience in technology support focused on desktops, Microsoft applications, and other prosecution‑related technologies.
Expert level of proficiency in programming, particularly with PowerShell and SQL
Knowledge, Skills & Abilities
Organized with high attention to detail
Experience with data management/analysis
Creative problem solver with the ability to self‑teach
Solid understanding of multi‑relational data structures
Comfortable working in an iteration‑based environment
Ability to build relationships and trust across departments
Ability to manage multiple tasks and projects concurrently
Self‑starter who is comfortable working both independently and with a team
Strong interpersonal and communication skills, specifically the ability to communicate technical concepts to a non‑technical audience
An understanding of criminal justice systems
An understanding of how to design a meaningful data visualization
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. Jobs are sedentary if walking and standing are required occasionally, and other sedentary criteria are met.
EEO Message 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 HRCC.SAO@Cookcountyil.gov
#J-18808-Ljbffr