IT Specialist (Data Management)

Washington, D.C
Jul 20, 2021
Jul 22, 2021
IT, Management
Full Time


Due to the Pandemic and individual states with different phases of reopening, the selectee's report date to the official duty station/facility may be delayed until such time as employees are allowed to report to the workplace. The person selected may telework up to the maximum extent possible, up to and including full time, until it is determined by state and Federal officials that employees are allowed to report to the workplace where this position is located, on a regular basis.

Learn more about this agency


This position is located in the Air Traffic Organization (ATO), System Operations Services, Office of Performance Analysis, System Data & Infrastructure Group, AJR-G200. This Group is responsible for integrating National Airspace System (NAS) flight, weather, facility, and other reference data to generate information and reports that provide the Air Traffic Management community insight into the performance of the NAS.

Uses knowledge of IT principles, methods, and technologies in system lifecycle and data management to manage systems that extract, transform, load, and curate National Airspace System (NAS) data.

Performs multiple, varying, complex assignments under the direction of the team or program manager. This work is critical to the safety and efficiency of the NAS.

System Architecture: Applies knowledge of system architecture patterns and methodologies to align the architectural solution with functional requirements, integrate multiple applications, and to assure data quality.

Evaluates and utilizes government cloud environments, enterprise-level services, and Big Data platforms, to make assessments of data acquisition, migration of existing systems, and the implementation strategies.

Coordinates with multiple Agency information technology stakeholders to design practical, supportable, and efficient solutions.

Applies knowledge of Agile, rapid software development utilizing DevSecOps and Continuous Integration/Continuous Delivery methods.

Project Management : As a project team member assigned to specific activities within the data warehouse,

Applies knowledge of program/project management principles to support the planning, execution, and monitoring of projects.

Tracks milestones and deliverables, conducts risk mitigation, reports on project status, and supports the procurement process.

Data Management : Applies knowledge of data modeling, management frameworks, and governance to support large-scale database management systems throughout the full system lifecycle development to enable data science, visualization, and operational analysis.

Demonstrates ability to design, optimize and administer databases to process high-volume, high-velocity streaming datasets such as flight plans, trajectories, airspace, weather, traffic management, and operational performance metrics.

Develops extract, transform, and load processes, and data integration solutions, applying data stream management technologies such as Apache NiFi and Kafka.

Supports the baseline data architecture and develops data models for the integration of new data elements and interfaces with enterprise-level services.

Data Quality : Demonstrates ability to profile geospatial and operational data, such as Traffic Flow Management System (TFMS), Aviation System Performance Metrics (ASPM), Operations Network (OPSNET), National Traffic Management Log (NTML), and/or NAS Data Warehouse (NDW), and aligns these data assets to operational needs.

Applies skills using analytical techniques, data mining, and software, such as R, Python, full-stack JavaScript, and SQL to analyze data quality within large-scale database management systems such as Oracle or PostgreSQL.

Monitors the data quality baseline and develops metrics on the availability and accuracy of data for proactive data quality improvement.

Travel Required

25% or less - The job may require up to 25% travel.

Supervisory status

Promotion Potential


Conditions of Employment

  • US Citizenship is required.
  • Selective Service Registration is required for males born after 12/31/1959.
  • Management may choose to interview all, some, or none of the referred candidates.
  • This position is covered by the FAA Core Compensation Plan. Additional information about core compensation is available on the website:
  • Please ensure that you answer all questions and follow all instructions carefully. Errors or omissions may impact your rating or may result in you not being considered for the job.
  • Applicants may be asked to verify information they have provided on their application for employment with the FAA.


Candidates must have one year (52 weeks) of SPECIALIZED EXPERIENCE equivalent to at least the next lower grade level (FV-H or FG/GS-12) that is typically related to the line of work of the position to be filled and which has equipped the applicant with the particular knowledge, skills, and abilities to successfully perform the duties of the position. To be creditable, specialized experience must have been at least equivalent to the next lower level in the normal line of progression for the occupation in the organization.

Specialized Experience at the Next Lower Level (FV-H)

--Experience planning, designing, implementing, and optimizing large-scale (millions of records per day and multiple terabytes of data) database management systems (Oracle or PostgreSQL).

--Experience using analytical techniques, data mining, and software, including but not limited to R, Python, full-stack JavaScript, and SQL, to analyze data quality within large-scale database management systems such as Oracle or PostgreSQL.


You should include relevant examples of the specialized experience in your work history. Errors or omissions may impact your rating or may result in you not being considered.

Answer all questions to the best of your ability. DO NOT ASSUME THAT BECAUSE YOU HOLD, OR HAVE HELD THIS POSITION, YOU WILL AUTOMATICALLY BE FOUND ELIGIBLE. You may be asked to provide evidence or documentation that you have this type of experience later in the selection process. Your responses are subject to verification through job interviews, or any other information obtained during the application process. Any exaggeration of your experience or any attempt to conceal information can result in disqualification.

*Applicants who fail to demonstrate possession of any of the above criteria AND who do not provide the required documentation will receive no further consideration for this position.*

Eligible applicants meeting the minimum qualification requirements and/or Selective Placement Factor(s) (SPF) may be further evaluated on the Knowledge, Skills and Abilities (KSA) and/or Quality Ranking Factor (QRF) listed in the announcement. Based on this evaluation, applicants will be placed in one of the following categories: (1) score order; (2) category grouping; priority grouping; or (3) alphabetical, and referred to the selecting official for selection consideration.

This is a Level 1 (Low Risk) position requires favorable adjudication of a National Agency Check and Inquiries (NACI) background investigation prior to appointment.

AFSCME Interview Criteria: Article 42, Section 13 states: If the selecting official decides to interview any employee on the selection list for a vacancy, then all who remain under consideration for the position at that point in the process must be interviewed. If the selection list is shortened to a best qualified list through a comparative process, then the best qualified list shall be considered to be the selection list. If it is determined that interviews are required and telephone interviews are not utilized, travel expenses incidental to these interviews will be paid in accordance with the Agency's travel regulations and this Agreement.

**All qualification requirements must be met by the closing date of this vacancy announcement.**


Education cannot be substituted for experience.

Preview Job Questionnaire
Make sure your resume includes detailed information to support your qualifications and answers to the job questionnaire.

Additional information

We may use this vacancy to fill other similar vacant positions.
Position may be subject to a background investigation.
A one-year probationary period may be required.

The person selected for this position may be required to file a financial disclosure statement within 30 days of entry on duty. FAA policy limits certain outside employment and financial investments in aviation-related companies.

The U.S. Department of Transportation strives to ensure that equity, transparency, accountability, collaboration, and communication permeate all that we do for the betterment of the Department, the traveling public, and our nation. As such, DOT values a highly diverse workforce of persons who promote a culture of belonging by respecting the personal dignity and worth of each individual and fostering a positive environment where all feel safe and welcome. If these commitments coincide with your personal ideals and professional aspirations, please consider joining the DOT family.

1. As a part of the Federal-Wide Hiring Reform Initiative (streamlining the hiring process), the FAA is committed to eliminating the use of Knowledge, Skills and Ability (KSA) narratives from the initial application in the hiring process for all announcements. Therefore, as an applicant, you are NOT required to provide a narrative response in the text box listed below each KSA.

In lieu of providing a KSA narrative response in the text box listed below each KSA section, in your work history, please include information that provides specific examples of how you meet the response level or answer you chose for each KSA. Your work history examples should be specific and clearly reflect the highest level of ability. Your KSA answers will be evaluated further to validate whether the level that you selected is appropriate based on the work history and experience you provided. Your answers may be adjusted by a Human Resource Specialist as appropriate.

This is a bargaining unit position.

Links to Important Information: Locality Pay , COLA

How You Will Be Evaluated

You will be evaluated for this job based on how well you meet the qualifications above.

IMPORTANT: Applicants may be rated on the extent and quality of experience, education, and training relevant to the duties of the position(s). All answers provided in the on-line process must be substantiated. Ensure that your application package/resume supports your responses.

Background checks and security clearance

Security clearance

Drug test required

Required Documents

Only supplemental documentation (e.g. transcript, certifications, SF-50, and/or veterans' documentation) will be accepted in combination with your on-line application. These documents must be uploaded or emailed on or before the closing date of the announcement. All submitted documents must reference the announcement number.

All Veterans: If you are claiming veterans' preference, you must submit either a DD Form 214 Certificate of Release or Discharge from Active Duty (Member 4 Copy or equivalent), or a document from the armed forces certifying that within 120 days you are expected to be discharged or released from active duty service under honorable conditions. If you are claiming 10 point preference, you must also submit a completed SF-15, Application for 10-Point Veteran's Preference, and supporting documents outlined on the SF-15. Documents must be uploaded or faxed to the Servicing Human Resource Management Office listed in this announcement and all documents must be received by the closing date of the announcement. If you fail to submit documentation, you will be assessed as a non-veteran.

If you are claiming 10 point preference but fail to submit the supporting documents outlined on the SF-15, you will be tentatively assessed as a 5 point preference eligible provided your DD Form 214 reflects that you have the service required to qualify for preference. Documents must be uploaded or faxed to the Servicing Human Resource Management Office listed in this announcement and all documents must be received by the closing date of the announcement. If you fail to submit documentation, you will be assessed as a non-veteran.

Veterans currently on active duty claiming veterans' preference: You will be granted tentative preference if you submit a document from the armed forces certifying that within 120 days you are expected to be discharged or released from active duty service under honorable conditions and your application shows that you have the required service. Prior to being appointed, you must provide to the Servicing Human Resource Management Office a DD Form 214 documenting discharge/release and showing that the service was honorable or general. If you are on terminal leave, you must provide documentation certifying authorized terminal leave.

If you are relying on your education to meet qualification requirements:

Education must be accredited by an accrediting institution recognized by the U.S. Department of Education in order for it to be credited towards qualifications. Therefore, provide only the attendance and/or degrees from schools accredited by accrediting institutions recognized by the U.S. Department of Education .

Failure to provide all of the required information as stated in this vacancy announcement may result in an ineligible rating or may affect the overall rating.

Similar jobs