Data Integration Specialist

SmartRecruiters, Inc.; Town of Florida, Northern (NY, KY); Hybrid; USD 120,000 - 180,000; Full time

Job summary

SOSi seeks a Data Integration Specialist to build scalable data pipelines and ETL workflows, enabling real-time and batch processing for a DoD customer. You will drive data governance, schema alignment, and interoperability across cloud and on-prem environments, partnering with AI/ML engineers for model training.

Required TS/SCI clearance and a bachelor’s degree or five years of equivalent data integration experience; strong experience with NiFi, Databricks, and SQL data warehouses is expected.

Qualifications

• Active TS/SCI clearance is required.
• Experience developing and managing ETL workflows across multiple sources.
• Proficient in data quality and metadata management.

Responsibilities

• Develop and maintain scalable data pipelines for real-time and batch processing.
• Implement ETL workflows to enable data interoperability across cloud and on-premises environments.
• Manage schema alignment, metadata tagging, and data governance.
• Coordinate with AI/ML engineers to meet model training requirements.
• Submit the Data Ingestion & Transformation Report documenting sources and optimizations.

Skills

ETL pipelines

Data integration

SQL databases

Data governance

Cloud environments

API development

Education

Bachelor's degree in Data Science or related field

Five years of data integration experience

Tools

Apache NiFi

Databricks

SQL-based data warehouses

Job description

Founded in 1989, SOSi is among the largest private, founder-owned technology and services integrators in the defense and government services industry. We deliver tailored solutions, tested leadership, and trusted results to enable national security missions worldwide.

Job Description

**This position is contingent upon award of contract**

SOSi is seeking a Data Integration Specialist to support mission requirements for a structured approach to further develop, integrate, and sustain a scalable, federated data ecosystem that enhances interoperability, governance, and mission-driven analytics for a DoD customer. The primary objective of the program is to bridge the operational gaps between DoD, IC, interagency, and non-traditional international partners to enable real-time information sharing, dynamic data integration, and mission-tailored analytical capabilities.

• Develop and maintain scalable data pipelines that enable real-time and batch processing of structured and unstructured data.
• Implement Extract, Transform, Load (ETL) workflows that facilitate data interoperability across cloud and on-premises environments.
• Manage schema alignment, metadata tagging, and data governance to ensure data quality and traceability.
• Coordinate with the AI/ML Engineer to ensure data transformations meet model training and analytical requirements.
• Submit the Data Ingestion & Transformation Report, documenting data sources, pipeline optimizations, and integration updates

Qualifications

• Active TS/SCI clearance.
• Bachelor's degree in Data Science, Information Management, or a related field, OR five (5) years of equivalent experience indataintegration.
• Demonstrated experience in developing and managing ETL workflows, integrating data from multiple sources, and ensuring data quality and consistency.
• Experience with tools such as Apache NiFi, Databricks, and SQL-based data warehouses is required.
• Possess the knowledge and capability to manage data ingestion, transformation, and interoperability across cloud-based and on-premises environments.
• Personnel must be proficient in data integration tools, API development, ETL pipelines, and schema management.

Preferred Qualifications

• Certifications include Certified Data Management Professional (CDMP) or Microsoft Certified: Azure Data Engineer Associate.

Additional Information

Working Conditions

• Normal office conditions.

Working at SOSi

All interested individuals will receive consideration and will not be discriminated against for any reason.