- Location
- Clarksburg, WV
- Workplace
- Remote, Onsite
- Experience
- 6+ years
- Clearance
- Required
- Source
- ApplicantStack
Description
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.