IT Specialist (Data Management)

Employer
USAJobs
Location
Washington, D.C
Posted
Jul 20, 2021
Closes
Jul 22, 2021
Function
IT, Management
Hours
Full Time
Duties

Summary

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

Responsibilities

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

Not required - The job does not require any travel.

Supervisory status
No

Promotion Potential
NA

Requirements

Conditions of Employment

  • US Citizenship is required.
  • Selective Service Registration is required for males born after 12/31/1959.
  • Must submit an SF50 (See Required Documents)
  • 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: https://employees.faa.gov/org/staffoffices/ahr/policy_guidance/hr_policies/hrpm/comp/comp_ref?
  • 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.


Qualifications

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

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. www.faa.gov/jobs/working_here/financial_disclosure_requirements

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
Other

Drug test required
No

Required Documents

All applicants MUST submit the following:

(1)resume with complete work history; and
(2)a copy of your most recent SF-50 (Notification of Personnel Action)

If you are an FAA employee, you MUST provide a copy of your SF-50 (Notification of Personnel Action) containing information in Blocks 15, 17, 18, 19, 22, and 24 so it can be used to verify your position title, series, grade, tenure, and organization of record by the closing date of the announcement. You may fax your SF-50 or upload it into the on-line application. If faxing the SF-50, please ensure you include the vacancy announcement number on the faxed copy.

If you are an FAA employee, you can access and print your SF-50 from the eOPF system https://eopf.opm.gov/dot/ .

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