What are the responsibilities and job description for the USAF - Data Engineer position at cFocus Software Incorporated?
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.