Data Integration Engineer

Cook County • Chicago, IL

16h • Onsite

About The Position

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.

Requirements

• 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.
• 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.
• 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).

Nice To Haves

• 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.

Responsibilities

• 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.

Benefits

• Health Insurance Program – 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 1st) also qualify for a floating holiday.
• Sick Leave – 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.
• Life Insurance – 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.
• Pension Plan – 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.
• Deferred Compensation Program – Employees may elect to enroll in a deferred compensation plan, a tax deferred plan which may be used as a supplemental retirement option.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level