[Hiring] Integration Data Engineer @Estrada Consultingorporated

Role Description

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)
• Other criminal-justice or public-safety source systems

Qualifications

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

Requirements

• Experience integrating data across multiple independent justice/public-safety systems or agencies is highly desirable, 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 is also highly desirable.
• Modern justice-system integration requirements commonly include real-time, near-real-time and batch exchanges, documented APIs, data validation/reconciliation, and CJIS-compliant exchanges.

Candidate Preference

• Candidates located in Texas are preferred.
• W2 candidates are strongly preferred.