Data Integration Engineer

Cook County

Sheriff

Job Code: 6085

Job Title: Data Integration Engineer 

Salary Grade: 23

Department: Sheriff’s TechOps Bureau – Data Operations

Bargaining Unit: Not Applicable

Position Details: Civilian (non-sworn) / non-merit ranked / internal & external candidates

FLSA Status:Exempt

Probation Period: 12 Months

Designation – SEAM EE: Technical

Characteristics of the Position

General Overview

Under the direction of the Executive Director of Data Operations / Designee, responsible for providing operational database services to the Cook County Sheriff’s Office; ensures accuracy/integrity of data and applications through analysis, coding, writing clear documentation and problem resolution; analyzes and translates functional specifications and changes requests into technical specifications; develops, tests and implements program logic; translates business needs into end user applications; performs data analyst and modeling activities for a business-driven operational layer which integrates multiple master data domains and reference data and exposes the integrated data to enterprise wide applications via web services.

Key Responsibilities and Duties

Works with external agencies to integrate data into the Cook County Sheriff’s Office, maintaining and ensuring that data integrated into the Cook County Sheriff’s Office is normalized and accurate.

Collaborate with business analysts, data analyst, SQL Developers, and IT team members to understand data requirements and the end-to-end data flow.

Use a combination of programming languages, databases, and ETL tools to design and construct data integration and ETL processes.

Using ETL tools and scripting languages to develop and implement data integration workflows and routines.

Perform complex data analysis, data quality checks, and troubleshoot data issues.

Ensure high levels of data availability and quality, maintaining optimal performance of the data integration infrastructure.

Optimize data integration platforms for increased efficiency and performance.

Document data integration procedures, including data lineage and ETL processes.

Monitor data integration jobs and proactively respond to system alerts and issues, ensuring that data flows are accurate and timely.

Keep abreast of industry trends and advancements in data integration technologies.

Performs production support activities as needed for this operational environment.

Performs other related assignments and duties as directed.

Knowledge, Skills and Abilities

Expertise with SQL, PL/SQL and/or T-SQL.

Experience in data processing and data integration development (RESTful APIs and JSON)

Expertise in Extract, Transform, Load (ETL) processes using SSIS.

Knowledge of proficiency in cloud platforms like Microsoft Azure and AWS.

Understanding data modeling concepts and practices for designing efficient databases and data architectures.

Understanding of data governance principles and security best practices.

Ability to communicate effectively in the business environment, using tact and courtesy and use sound judgment in interpreting problems and issues related to work assignment.

Ability to create and prepare reports, including technical documentation, as required.

Ability to multi-task and prioritize, handling multiple projects and meeting deadlines while effectively managing changing priorities, as needed.

Ability to troubleshoot by analyzing data and situations, reason logically and creatively, identify problems, draw valid conclusions and develop effective solutions.

Ability to effectively handle stressful situations and meet prescribed deadlines.

Ability to adapt to a structured environment, following necessary techniques and procedures.

Ability to demonstrate initiative and leadership and to supervise and lead others.

Ability to work independently or as part of a team.

Thorough working knowledge of or ability to quickly and effectively grasp and utilize the policies, protocols, systems, procedures, and technical vernacular of the agency, department and County, as they are applicable to assigned duties and responsibilities.

Ability to effectively participate in staff meetings or other forums aimed at developing constructive ideas, observations, audit findings and recommendations.

Skill in interacting with others to investigate, gather and review confidential materials, information and incidents of record.

Ability and willingness to participate in development and training programs in order to upgrade skills and knowledge.

Ability to travel to work assignments by providing own means of transportation.

Minimum Qualifications

Possession of a Bachelor’s degree in computer science, Information Systems, or related discipline, from an accredited college or university, AND/OR minimum five (5) years in data integration, data warehousing, or a similar role.

Expertise with ETL tools and data integration platforms such as Informatica, Talend, or SSIS.

Strong proficiency in SQL and experience with SQL Server relational databases.

Strong proficiency with indexing and query optimization.

Knowledge of data modeling and data architecture principles.

Possession of a valid Driver's License and proof of vehicle insurance, with the ability to operate a motor vehicle.

Ability to work any shift assigned, including days, afternoons or midnights; must be capable of working Holidays and weekends; must be capable of working mandatory overtime, as required.

Preferred Qualifications

Familiarity with big data technologies (Hadoop, Spark) and cloud services (AWS or Azure)

Skilled in scripting languages (Python, Java, or C#) for automation of data processes.

Skilled in Batch Data Processing

Skilled in Online Transaction Processing

Possession of ITIL Foundation Certification.

The duties listed are not set forth for purposes of limiting the assignment of work. They are nottobeconstruedasacompletelistofthemanydutiesnormallytobeperformedunderajob title or those to be performed temporarily outside an employee’s normal line of work.

**ArticleEE,Civilian SelectionProcess,oftheSheriff’sEmployment Action Manual (SEAM), applies to this employment process and can be found at the followinglink:

https://cookcountysheriffil.gov/wp-content/uploads/2025/11/SEAM-Article-EE-Civilian-Selection-Process-updated-11-15-25.pdf

Pleasenotethattherearenoremotejobopportunities, allpositionsarelocated onsite.

All Cook County Sheriff’s Office employees must apply on the internal employment page to be considered; the application may be accessed via the SheriffNet site on the Human Resource page.

*Note: All Internal Applicants are subject to Cook County Promotional salary rules if selected.

ICertifythatnoPoliticalReasonsorFactorswereconsideredinanydecisionImadeoraction I took related to this Employment Action.Further, I do not know of or have any reason to believe that anyone else considered or took action based on Political Reasons or Factors with respect to this Employment Action.

EEO Statement

The Cook County Sheriff’s Office is an equal opportunity employer and prohibits all unlawful discrimination in its hiring and promotional process. The Cook County Sheriff’s Office employment decisions will not be based on race, color, ancestry, religion, national origin, age, gender identity, sexual orientation, family or parental status, disability, genetic information, or any other basis prohibited by applicable law.

Benefits

HealthInsuranceProgram – Health insurance coverage includes medical, dental and vision care and is available for an employee and his/her eligible dependents.

Holidays – Thirteen (13) Holidays are granted in each Fiscal Year. Employees who are active at the beginning of the fiscal year (December 1^st) also qualify for a floating holiday.

SickLeave – Granted sick leave is earned and accrued at the rate of one (1) day for each month of service and may be accumulated up to one hundred and seventy-five (175) working days.

Vacation Leave – Granted Vacation leave is earned and accrued, with employees having the opportunity to accrue fifteen (15) days within the Fiscal Year; Vacation leave accruals increase based on an employee’s anniversary date of employment.

LifeInsurance – Basic term life insurance, equal to one (1) time the employee’s annual salary, is offered to every employee at no cost and the employee may elect to purchase supplemental coverage.

PensionPlan – Employees contribute into the Cook County Pension Fund and earn a prescribed percentage for each year of service; employees may be eligible for an annual annuity after ten

(10) years of service and upon reaching a certain age based on when the employee started employment.

DeferredCompensationProgram – Employees may elect to enroll in a deferred compensation plan, a tax deferred plan which may be used as a supplemental retirement option.

The 2025 Cook County Employee Benefits Overview can be viewed at:

https://www.cookcountyil.gov/sites/g/files/ywwepo161/files/documents/2025-09/OE26.Employee Benefits Overview (EBO)_County.pdf

DrugandAlcohol-FreeWorkplace

It is the policy of the Cook County Sheriff’s Office to provide a drug- and alcohol-free workplace for all members.

It is imperative that all Sheriff’s Office members are capable of devoting constant and uninterrupted attention to the performance of all assigned duties without risk to safety and security for themselves, other members, or the public. To ensure the goals of this policy are met, all Sheriff’s Office members shall be subject to drug and alcohol testing, whether mandatory, random, or based on reasonable suspicion.

*Must be legally authorized to work in the United States. *

This position requires successful completion of post-offer tests, which may include a background check, drug screen and/or medical examination. Falsification of any information in the application process will result in disqualification and ineligible for appointment to, or employment in, a position in the County service for a period of five years. For current Cook County Sheriff’s employees, such falsification may result in discipline, up to and including termination, and ineligible for appointment to or employment in a position in the County service for a period of five years. See Cook County Code of Ordinances, Article II, Sections 44-54 Unlawful Practices Relating to Employees and Employment - Penalty, 44-56 Political Discrimination; Cook County Employment Plan, Section V.N. Pre-Interview License and Certification Verification; Supplemental Policy No. 2014-2.13 Ineligible for Rehire List; and Cook County Personnel Rules 3.3(b) (7) (8) (18).

Sheriff’s Employment Action Manual (SEAM)

The Cook County Sheriff’s Office hiring process is governed by the Sheriff’s Employment Action Manual (SEAM) which prohibits employment actions from being influenced by any Political Reasons or Factors for Non-Exempt Positions. Cook County Sheriff’s officials and employees who become aware of or receive a complaint that involves an allegation of Political Reasons or Factors being considered in the hiring process of Non-Exempt positions are obligated to refer the complaint to the Cook County Sheriff’s Director of Compliance. If the Cook County Sheriff’s Director of Compliance sustains allegations of Political Reasons or Factors being considered, the Cook County Sheriff’s Office will disqualify the Applicant or Candidate from consideration for employment and disciplinary action will be imposed on any involved Cook County employees, if applicable.”

The advertisement of this position by any individual does not constitute an offer or promise of employment, promotion, or any other employment action and shall not influence the Cook County Sheriff’s Office hiring decision.