Apply on Employer Site

Air Force Civilian Service · 12 hours ago

Data Engineer

Universal City, TX

Full-time

Onsite

Mid, Senior Level

$108K/yr - $140K/yr

Air Force Civilian Service (AFCS) is seeking a passionate and skilled Data Engineer to join their team at the Digital Transformation Activity (DTA). The role involves designing and building critical ETL pipelines, writing advanced SQL and Python, and developing business intelligence dashboards to provide actionable insights for the U.S. Air Force's personnel data management.

Aerospace

Work & Life Balance

No H1B

Security Clearance Required

U.S. Citizen Only

Hiring Manager

Barry Kowald, M.T.S.

Responsibilities

Design and build the critical Extract, Transform, Load (ETL) pipelines that feed our analytics platforms

Write advanced SQL and Python to wrangle complex datasets

Develop compelling business intelligence dashboards that provide leaders with clear, actionable insights

Qualification

Data ManagementAdvanced SQLETL DevelopmentData WarehousingBusiness IntelligenceDatabase Performance TuningData ModelingDocumentation SkillsProblem Solving

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 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, 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