Integration Data Engineer (Ref: 5817)
Estrada Consulting Incorporated
- Houston, Texas
- 7 days ago
- Remote
- $50–$70
Highlights
Highly Desired: 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. 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.
Numbers & Facts
| Location | Houston, Texas (Remote) |
| Industry | Computer/IT Services |
| Salary | $50–$70 |
| Company Size | 20 to 49 employees |
| Year Founded | 2000 |
| Website | http://www.estradaci.com |
Description
Integration Data Engineer – Law Enforcement / Public Safety (Ref: 5817)
Location: Texas preferred.
Employment: W2 strongly preferred.
Employment: W2 strongly preferred.
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.
Required Experience:
- 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.
Highly Desired:
- 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.
Important: Resumes should clearly identify the specific CAD, RMS, OMS, JMS, law-enforcement, corrections, or criminal-justice systems supported and describe the candidate's hands-on role in the associated data integrations.
About Company
Estrada Consulting, Inc. is a delivering technology-enabled services and solutions to clients throughout the USA. We provide system integration, custom application development, project management, custom reporting solutions and consulting services to mid-size and large enterprises in all major industries. The Company headquarters in Sacramento, California, was established in year 2000. ECI also holds an active CMAS and MSA for State of CA. ECI is continually searching for highly skilled consultants with public sector project experiences in Project Management / PMP, Solutions and Enterprise Architecture, IT Systems Analysts, Business Analysts and Agile Scrum. Please reach out to jacquelinep@estradaci.com
Similar Job Searches
Data Manager Jobs in Houston, TXData Specialist Jobs in Houston, TXBusiness Intelligence Manager Jobs in Houston, TXData Analyst Jobs in Houston, TXDirector Of Information Systems Jobs in Houston, TXData Coordinator Jobs in Houston, TXDatabase Manager Jobs in Houston, TXData Consultant Jobs in Houston, TXBusiness Intelligence Analyst Jobs in Houston, TXData Engineer Jobs in The Woodlands, TX