Integration Data Engineer (Ref: 5817)

Estrada Consultingorporated•Harris County, TX

1d•Onsite

About The Position

Estrada Consulting, Inc. is seeking an experienced Integration Data Engineer to support the design, development, implementation, and production support of complex data integrations within a law-enforcement/public-safety environment. The ideal candidate will have hands-on experience integrating data from Computer-Aided Dispatch (CAD), Records Management Systems (RMS), Offender/Offense Management Systems (OMS), Jail Management Systems (JMS), and other criminal-justice or public-safety source systems.

Requirements

Strong hands-on data engineering and systems integration experience.
Demonstrated experience working with law-enforcement, criminal-justice, or public-safety data systems, including CAD, RMS, OMS, JMS, or comparable source systems.
Strong SQL skills, including complex queries, data analysis, extraction, transformation, reconciliation, and troubleshooting.
Experience designing and supporting integrations using REST/SOAP APIs, SFTP/file-based exchanges, database connections, and other system-to-system integration methods.
Experience developing and maintaining ETL/ELT and data integration pipelines for batch, scheduled, near-real-time, and/or real-time data exchanges.
Experience with source-to-target mapping, data transformation, normalization, synchronization, and reconciliation across disparate systems.
Ability to implement data validation and quality controls to ensure accuracy, completeness, consistency, and integrity of integrated data.
Experience implementing monitoring, logging, alerting, exception handling, retry/recovery, and reprocessing procedures for production integrations.
Ability to troubleshoot failed interfaces, missing or duplicate records, synchronization issues, schema changes, malformed data, connectivity failures, and other integration problems.
Experience developing and maintaining Interface Control Documents (ICDs) and related technical documentation, including interface specifications, source-to-target mappings, data flows, field definitions, transformation rules, dependencies, error handling, and operational procedures.
Experience testing integrations and validating data across source and target systems.
Ability to work collaboratively with application teams, database administrators, vendors, business stakeholders, and law-enforcement/public-safety technical teams.

Nice To Haves

Experience integrating data across multiple independent justice/public-safety systems or agencies, particularly involving dispatch, incident/offense, arrest, booking, inmate/jail, warrant, case, court, or other criminal-justice information.
Knowledge of CJIS/security requirements, NIEM, XML, JSON, message-based integrations, data exchange standards, and secure handling of criminal-justice information.
Familiarity with modern justice-system integration requirements including real-time, near-real-time and batch exchanges, documented APIs, data validation/reconciliation, and CJIS-compliant exchanges.

Responsibilities

Design, development, implementation, and production support of complex data integrations.
Integrate data from Computer-Aided Dispatch (CAD), Records Management Systems (RMS), Offender/Offense Management Systems (OMS), Jail Management Systems (JMS), and other criminal-justice or public-safety source systems.
Design and support integrations using REST/SOAP APIs, SFTP/file-based exchanges, database connections, and other system-to-system integration methods.
Develop and maintain ETL/ELT and data integration pipelines for batch, scheduled, near-real-time, and/or real-time data exchanges.
Implement source-to-target mapping, data transformation, normalization, synchronization, and reconciliation across disparate systems.
Implement data validation and quality controls to ensure accuracy, completeness, consistency, and integrity of integrated data.
Implement monitoring, logging, alerting, exception handling, retry/recovery, and reprocessing procedures for production integrations.
Troubleshoot failed interfaces, missing or duplicate records, synchronization issues, schema changes, malformed data, connectivity failures, and other integration problems.
Develop and maintain Interface Control Documents (ICDs) and related technical documentation, including interface specifications, source-to-target mappings, data flows, field definitions, transformation rules, dependencies, error handling, and operational procedures.
Test integrations and validate data across source and target systems.
Collaborate with application teams, database administrators, vendors, business stakeholders, and law-enforcement/public-safety technical teams.