The Role
Data Engineer supporting a United States Air Force program. Responsibilities include designing ETL pipelines, data warehouses and lakes, APIs, data quality controls, metadata and lineage practices, analytical datasets, security controls, automated deployments, monitoring, troubleshooting, and technical documentation. The role collaborates with government stakeholders, mission partners, technical teams, and data scientists while maintaining compliance with approved architectures, governance standards, and security boundaries.
Summary Generated by Built In
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:
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
- 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 Required
- Active TS/SCI security clearance
- Bachelor’s degree in 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 for data ingestion, transformation, and validation
- Experience with data modeling, data warehouses or data lakes, and analytical query development
- Ability to implement data quality checks, metadata practices, and 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 technical documentation
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Established in 2006, cFocus Software automates FedRAMP compliance and develops government chatbots for the Azure Government Cloud, Office 365, and SharePoint. cFocus Software is the exclusive vendor of ATO (Authority To Operate) as a Service™, which automates FedRAMP compliance for the Azure Government Cloud and Office 365. Contact Us for a demo of ATO as a Service™ or a FREE government chatbot proof of concept project today!
