USAF - Data Engineer

cFocus Software Incorporated; Linthicum (MD); On-site; USD 140,000 - 170,000; Full time

Job summary

cFocus Software Incorporated seeks a Data Engineer to support USAF programs in Linthicum Heights, MD. On-site role requiring Active TS/SCI clearance and experience building ETL pipelines and data platforms.

The position emphasizes data governance, API integration, and secure data handling within government-approved architectures. You will develop and maintain data warehouses, perform data quality checks, and support dashboards and KPIs for mission partners.

Qualifications

• Active TS/SCI clearance required.
• B.S. Computer Science, Information Technology, or related field.
• Experience developing data pipelines, ETL processes, and enterprise data integration.
• Proficiency in SQL and programming or scripting to ingest, transform, and validate data.
• Experience with data modeling, warehouses or lakes, and analytical query development.
• 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

Responsibilities

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

Skills

Active TS/SCI clearance

Data pipelines & ETL

SQL & scripting

Data modeling & warehouses/lakes

Data quality & metadata

APIs & data sharing

DevSecOps & version control

Data governance & security

Pipeline monitoring & documentation

Education

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

Job description

cFocus Software seeks a Data Engineer to join our program supporting the United States Air Force (USAF). This position is on-site in Linthicum Heights, MD. This position requires an Active TS/SCI clearance.

Qualifications

• Active TS/SCI clearance
• B.S. Computer Science, Information Technology, or a related field
• Experience developing data pipelines, ETL processes, and enterprise data integration solutions.
• Proficiency in SQL and programming or scripting used to ingest, transform, and validate data.
• Experience with data modeling, 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

Duties

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