Sr. Data Integration Specialist

Senior Data Integration Specialist

Position Overview

The Senior Data Integration Specialist supports the FBI CJIS N-DEx data-sharing ecosystem , with responsibility for developing and using automated data-integration tools, standardizing integration processes, supporting ETL solutions, enhancing existing integrations, developing new vendor solutions, and troubleshooting SFTP data connections. The Senior DI Specialist also leads complex integration efforts, provides integration-strategy recommendations, drives technical innovation, and mentors Mid- and Junior-Level DI Specialists.

Key Responsibilities

- Develop and utilize automated tools to enhance data-integration services.

- Implement standardized data-integration practices .

- Develop and support ETL processes and products.

- Enhance existing data-integration projects and develop new vendor integration solutions .

- Troubleshoot SFTP data connections .

- Design new vendor solutions and recommend integration strategies.

- Lead complex data-integration efforts.

- Drive technical innovation and modernization.

- Mentor Mid- and Junior-Level Data Integration Specialists.

- Support N-DEx modernization involving data ingest, data integration, and system federation .

- Map source data to N-DEx and NIBRS XML formats , including N-DEx IEPDs .

- Develop, maintain, test, and validate transformation code.

- Coordinate deployment of transformation code through approved adapters.

- Troubleshoot connections, XML schema issues, and related integration problems.

- Support Criminal Justice Agencies participating in N-DEx.

Required Senior-Level Experience

Minimum 6 years of increasingly responsible experience in:

- Data integration

- ETL development

- SFTP troubleshooting

Required Technical Skills

Integration / Web Services

- SOAP, REST, SFTP

- Data standards and validation tools

- Law-enforcement data

- IEPD specifications

Programming

- Java, Python , C, C#, .NET

Database / SQL

- PL/SQL, T-SQL, Oracle, PostgreSQL, Microsoft Access, MySQL, Sybase, SQL Developer

- Other relational databases

XML / Transformation

- XML, XSLT, XSD, DTD

Clearance / Location

Because there are two Senior DI Specialists but only one is designated Key Personnel :

- Key Senior DI Specialist: Active Top Secret clearance required.

- non-Key personnel perform remotely. Top Secret / onsite in Clarksburg, WV .