Public-Safety Data Integration Engineer

Estrada Consulting, Inc; Town of Texas (WI); On-site; USD 110,000 - 150,000; Full time

Job summary

Estrada Consulting, Inc. seeks an Integration Data Engineer to design, develop, implement, and provide production support for complex data integrations within a law-enforcement/public-safety environment.

The role focuses on integrating CAD, RMS, OMS, JMS, and other criminal-justice systems to ensure accurate, timely data exchanges. The candidate will build and maintain ETL/ELT pipelines, ensure data quality and validation, and collaborate with cross-functional teams to support real-time to batch

Qualifications

• Hands-on data engineering and systems integration experience.
• Experience with law-enforcement or public-safety data systems (CAD, RMS, OMS, JMS).
• Strong SQL skills including complex queries, data analysis, ETL/ELT processing, and reconciliation.
• Experience designing and supporting integrations using REST/SOAP APIs, SFTP/file-based exchanges, and DB connections.
• Experience with data validation, quality controls, and production monitoring.

Responsibilities

• Design, develop, implement, and support complex data integrations in a law-enforcement/public-safety environment.
• Develop ETL/ELT pipelines for batch, near-real-time, and real-time exchanges.
• Create and maintain ICDs, interface specifications, and data mappings.
• Collaborate with application teams, DBAs, vendors, and public-safety stakeholders.

Skills

Data integration

SQL

REST/SOAP APIs

ETL/ELT pipelines

Data transformation

Monitoring/logging

Troubleshooting interfaces

Interface Control Documents

Collaboration with teams

CJIS/security familiarity

Job description

Estrada Consulting, Inc. seeks an Integration Data Engineer to design, develop, implement, and provide production support for complex data integrations within a law-enforcement/public-safety environment.

The role focuses on integrating CAD, RMS, OMS, JMS, and other criminal-justice systems to ensure accurate, timely data exchanges. The candidate will build and maintain ETL/ELT pipelines, ensure data quality and validation, and collaborate with cross-functional teams to support real-time to batch