Data Integration Specialist

SOS International LLC; Florida; On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

CDMP

Azure Data Engineer Certification

Job summary

SOS International LLC in Doral, FL is seeking a Data Integration Specialist to develop and sustain a scalable, federated data ecosystem for a DoD customer. The role focuses on real-time and batch data processing, ETL workflows, and governance to enable interoperable analytics.

The qualified candidate will hold an active TS/SCI clearance and have experience with NiFi, Databricks, and SQL-based warehouses, bridging data across cloud and on-prem environments to support mission-critical decisions.

Qualifications

• Active TS/SCI clearance required.
• Bachelor's degree or 5 years of equivalent experience in data integration.
• Experience building ETL workflows across multiple sources.
• Experience with NiFi, Databricks, and SQL-based data warehouses.
• Ability to manage data ingestion across cloud and on-prem environments.
• Familiarity with data governance, metadata tagging, and schema alignment.

Responsibilities

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

Skills

TS/SCI clearance

ETL pipelines

Real-time data processing

Data governance

Cross-source data integration

API development

Education

Bachelor's degree in Data Science/Information Management or related field

5 years of equivalent data integration experience

Tools

Apache NiFi

Databricks

SQL-based data warehouses

Job description

Doral, FL, USA

Full-time

Clearance Requirement: Top Secret/SCI

Company 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.

Essential Job Duties:

• 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 in data integration.

• 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.

SOSi is an equal employment opportunity employer and affirmative action employer. All interested individuals will receive consideration and will not be discriminated against on the basis of race, color, religion, sex, national origin, disability, age, sexual orientation, gender identity, genetic information, or protected veteran status. SOSi takes affirmative action in support of its policy to advance diversity and inclusion of individuals who are minorities, women, protected veterans, and individuals with disabilities.