Sr. Data Integration Specialist (Top Secret Required)

i3

$100K — $120K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Minimum 6 years of experience in data integration and ETL development
  • Proficient in SFTP troubleshooting
  • Strong technical skills in SOAP, REST, and SFTP protocols
  • Experience with programming languages such as Java, Python, C, C#, and .NET
  • Familiarity with PL/SQL, T-SQL, and various relational databases like Oracle and MySQL
  • Knowledge of XML, XSLT, XSD, and DTD for data transformation

Responsibilities

  • Develop and utilize automated tools to enhance data-integration services
  • Implement standardized data-integration practices
  • Enhance existing data-integration projects and create new vendor solutions
  • Lead complex data-integration efforts and recommend integration strategies
  • Troubleshoot SFTP data connections and XML schema issues
  • Support Criminal Justice Agencies within the N-DEx ecosystem
  • Mentor Mid- and Junior-Level Data Integration Specialists

Benefits

  • Opportunities for technical innovation and modernization
  • Position involves mentorship opportunities
  • Support for participating Criminal Justice Agencies
  • Engagement in a meaningful data-sharing ecosystem with law enforcement
  • Potential for remote work arrangements for non-Key personnel
Full Job 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.

Similar Jobs

More Jobs at i3

More Information Technology Jobs

Find similar Sr. Data Integration Specialist (Top Secret Required) jobs: