Air Force Civilian Service · 1 day ago
Operations Data Developer
Air Force Civilian Service (AFCS) is seeking a full-time Information Technology Specialist (Data Management) to serve as a DTA Operations Center of Excellence Data Developer. The role involves designing and constructing data solutions that support the personnel and manpower landscape of the Air Force, focusing on developing complex ETL pipelines and integrating systems via APIs.
Responsibilities
Design and construct data solutions from the ground up
Own the development of complex ETL pipelines in AWS
Write sophisticated Python scripts to integrate disparate systems via APIs
Model data structures that serve as a single source of truth
Qualification
Required
Must be a U.S. Citizen
Must be able to obtain and maintain a Secret clearance
Mastery knowledge of enterprise data management and analysis concepts, techniques, and principles sufficient to establish, plan, analyze, and measure/monitor enterprise data management policies, standards and processes
Mastery Knowledge of advanced Structured Query Language (SQL) and database structures, to include data lakes and data warehouses, and of operating systems software and database concepts to envision problems which would be encountered by applications programmers using various database structures
Skill in implementation and documentation of data sourcing, data dictionaries, data models, file/database designs, Extract, Transform, Load (ETL) processes, user testing, and data development lifecycle
Skill in creating and managing users and roles and managing database, table, object level permissions, database performance monitoring, designing and implementing stored procedures, packages, and triggers for monitoring database performance, database tuning, SQL statements tuning, database backup and recovery, and development of integrated components of the data environment
Ability to envision problems which would be encountered by applications programmers using various database structures, to modify existing systems, and to advise on alternative approaches in operating systems development and/or problem resolution related to database management systems
Ability to analyze complexities of existing technology, review/revise/develop policy, initiate plans for enhancements, and provide management sufficient technical and cost analysis information, through written documentation and oral briefings, to render informed judgments and to maintain an up-to-date awareness of technological advances and predict how management can meet future requirements
Cyberspace Qualification is a condition of employment. This position includes Cyberspace work as a paramount duty requirement. Per Department of Defense Manual (DoDM) 8140.03, para 4.2.a.(2)., requires foundational qualification requirements within 9 months of assignment to a cyberspace work role and resident qualification requirements within 12 months of assignment to a cyberspace work role. A waiver of these requirements may be granted per DoDM 8140.03. Failure to achieve and maintain the proper Cyberspace Qualification may result in removal from this position
Company
Air Force Civilian Service
A mission to support the men and women in uniform of the United States Air Force with our talent and dedication and service.