TS/SCI Data Engineer — ETL & Data Lake Expert

cFocus Software Incorporated; United States; Presencial; USD 120.000 - 180.000; Jornada completa

Descripción de la vacante

cFocus Software Incorporated seeks a Data Engineer to join our program supporting the United States Air Force (USAF). This on-site role is located in Linthicum Heights, Maryland, and requires an Active TS/SCI clearance to handle mission data.

You will design and implement ETL processes, build data warehouses and data lakes, and develop APIs while ensuring data quality, governance, and secure data sharing with government partners.

Formación

• Active TS/SCI clearance is required.
• B.S. in Computer Science, IT, or a related field.
• Experience developing data pipelines, ETL processes, and enterprise data integration solutions.
• Proficiency in SQL and programming or scripting for data ingestion, transformation, and validation.
• Experience with data modeling, data warehouses or lakes, and analytical query development.
• Ability to implement data quality checks, metadata practices, and traceable source-to-target mappings.
• Experience developing or integrating APIs and troubleshooting data-sharing interfaces.
• Experience with automated deployment, source control, configuration management, and testing.
• Understanding of data governance, access controls, and secure handling of mission information.
• Ability to monitor pipeline performance, resolve failures, and maintain clear technical documentation.

Responsabilidades

• Gather and analyze approved data requirements, source characteristics, integration dependencies, and reporting needs with Government stakeholders.
• Assess existing infrastructure and data sources; maintain inventories and identify capability, accessibility, and data quality gaps.
• Design and implement Extract, Transform and Load (ETL) processes, data structures, and integration workflows under approved business intelligence architecture.
• Build, configure, and maintain data warehouse and data lake capabilities in accordance with Government-approved designs and data models.
• Develop repeatable ingestion and transformation pipelines to clean, standardize, validate, and prepare data from approved sources.
• Implement data quality monitoring and remediation processes; investigate incomplete, inconsistent, duplicate, or invalid data and report corrective actions.
• Implement and maintain data tagging and metadata management in accordance with approved standards; document source mappings and transformation lineage.
• Develop, document, test, and maintain Application Programming Interfaces (APIs) and data-sharing interfaces under approved requirements and interagency agreements.
• Optimize authorized data exchange processes and analytical queries; coordinate interoperability and interface changes with mission partners and technical teams.
• Develop queries and datasets supporting reports, interactive dashboards, and Government-approved KPIs, including permitted fusion of external agency data.
• Prepare approved training datasets and support data cleaning, transformation, and feature engineering in collaboration with data scientists.
• Implement data security and access controls through DevSecOps practices consistent with approved system security plans and authorization boundaries.
• Use automated pipelines, version control, and configuration management for data platform changes; test before Government review and authorized production deployment.
• Monitor pipeline and business intelligence environment health and performance; investigate failures, maintain alerts, and provide operational status reports.
• Maintain technical designs, data dictionaries, interface specifications, procedures, and as-built documentation; support approved governance improvements and user training.

Conocimientos

TS/SCI clearance

SQL

ETL pipelines

Data modeling

APIs integration

Scripting

Data quality

Educación

B.S. Computer Science, Information Technology, or related field

Descripción del empleo

cFocus Software Incorporated seeks a Data Engineer to join our program supporting the United States Air Force (USAF). This on-site role is located in Linthicum Heights, Maryland, and requires an Active TS/SCI clearance to handle mission data.

You will design and implement ETL processes, build data warehouses and data lakes, and develop APIs while ensuring data quality, governance, and secure data sharing with government partners.