Job Title: IT Specialist (Data Management)

Summary
This position is located in the Air Traffic Organization (ATO), Safety and Technical Training, Policy & Performance Directorate, Safety Analysis Group, (AJI-3300). The Safety Analysis Group is responsible for managing the development of safety performance targets, automated tools, and data integration efforts in support of the risk identification, assessment, and mitigation efforts.

Learn more about this agency

Overview Accepting applications
Open & closing dates
11/08/2023 to 11/22/2023

Salary
$88,791 - $137,651 per year The salary shown reflects the basic pay only. Locality pay will be added for the respective location.

Pay scale & grade
FV J
Locations 2 vacancies in the following locations:

Washington, DC

Atlantic City, NJ

Fort Worth, TX

Telework eligible
Yes-as determined by the agency policy.

Travel Required
Occasional travel - The job may require travel from time-to-time, but not on a regular basis. The travel may be for training or other work-related duties.

Relocation expenses reimbursed
No

Appointment type
Permanent -

Work schedule
Full-time -

Service
Excepted

Promotion potential
NA

Job family (Series)
2210 Information Technology Management

Supervisory status
No

Security clearance
Other

Drug test
No

Announcement number
AWA-AJI-24-8709KN-87168

Control number
759567900

This job is open to

Federal employees - Competitive service
Current or former competitive service federal employees.

Federal employees - Excepted service
Current excepted service federal employees.

Veterans

Clarification from the agency
Also open to former permanent excepted service federal employees eligible under an interchange agreement. Current or former permanent federal employees must have met a one year probationary period or trial period in the competitive or excepted service. Applications will also be accepted from preference eligibles and veterans who are honorably discharged from the Armed Forces after completing at least 3 years of continuous active-duty service.

Duties The IT Data Management Specialist applies experience and comprehensive technical knowledge of Data Management principles, procedures, and tools of data management to solve complex problems and develop improved technical processes or systems. Applies skill performing capacity planning, database design, migration, performance monitoring, data security, troubleshooting, backup and data recovery to manage and administer Cloud and On-premises Databases to support application development. Applies experience using PostgreSQL and MySQL to configure, design, develop, and administer, a variety of relational database services on-premises or in the cloud. This work is critical to the development of a viable and secure infrastructure to identify, track, and monitor emerging trends or risk in the National Airspace System (NAS).

Uses experience in data profiling, metadata, quality rules and metrics development to serve as a project manager or team leader in the development of analytical products and dashboards. Plans, coordinates, and conducts studies to develop, integrate, and implement solutions to diverse, complex problems. Applies skill evaluating and selecting data management tools to direct and oversee data quality to ensure analytics products have a high degree of reliability and trust.
Applies skill using .NET, Angular/node.js, or Drupal platforms to support cloud-based web application development efforts. Applies skill using a variety of different services within the AWS platform, such as Kinesis, EC2, RDS, S3 and GLUE, to collect, extract, transform, load, and analyze data in support of such development.
Contacts are internal and external. Often represents FAA as a senior technical point of contact on projects, programs and other work activities. Communicates results to all levels internally within AJI and externally. Applies skill using SharePoint and MS Power Platforms, data gateways and Power BI dashboards to administer, configure, develop and troubleshoot to support collaboration and reporting platforms for management decision making. Presents briefings to obtain consensus/approval on policies. Coordinates significant technical matters with representatives of external organizations.

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)

Qualifications

To qualify for this position, you must demonstrate in your application that you possess at least one year of specialized experience equivalent to the FV-I, FG/GS-13 level. This experience 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 is defined as:
- Experience using PostgreSQL and MySQL to configure, design, develop, and administer, a variety of relational data services on-premises or in the cloud.
- Experience using data profiling, metadata, quality rules and metrics development to serve as a project manager or team leader in the development of analytical products and dashboards.
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. *
Applicants may be asked to verify information on your application for employment with the FAA.
**All qualification requirements must be met by the closing date of this vacancy announcement. **
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; (3) alphabetical; or (4) priority grouping and referred to the selecting official for selection consideration.

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.

Selectees will be assigned to either the Safety Data Team, AJI-3320 or Safety Support Tools Team, AJI-3340.
NOTES:
1. This position is covered by the FAA Core Compensation plan. Additional information about Core Compensation is available at: https://www.faa.gov/jobs/working_here/benefits.
2. 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.
3. 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.
4. This Level 5 (Moderate Risk; Public Trust) position requires favorable adjudication of a Minimum Background Investigation (MBI) background investigation prior to appointment, unless a waiver is obtained.

This is a bargaining unit position. This position is represented by AFSCME Local 1653.

Links to Important Information: Locality Pay , COLA

A career with the U.S. government provides employees with a comprehensive benefits package. As a federal employee, you and your family will have access to a range of benefits that are designed to make your federal career very rewarding. Opens in a new windowLearn more about federal benefits.

Review our benefits

Eligibility for benefits depends on the type of position you hold and whether your position is full-time, part-time or intermittent. Contact the hiring agency for more information on the specific benefits offered.

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.

A career with the U.S. government provides employees with a comprehensive benefits package. As a federal employee, you and your family will have access to a range of benefits that are designed to make your federal career very rewarding. Opens in a new windowLearn more about federal benefits.

Review our benefits

Eligibility for benefits depends on the type of position you hold and whether your position is full-time, part-time or intermittent. Contact the hiring agency for more information on the specific benefits offered.

As a new or existing federal employee, you and your family may have access to a range of benefits. Your benefits depend on the type of position you have - whether you're a permanent, part-time, temporary or an intermittent employee. You may be eligible for the following benefits, however, check with your agency to make sure you're eligible under their policies.
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 faxed to 202-267-7032 or 1-866-291-3009 on or before the closing date of the announcement. All submitted documents must reference the announcement number. For guidance on how to create a Federal resume, visit http://www.archives.gov/careers/jobs/forms/resume-guide.pdf. Failure to submit all required documents by the closing date will result in a finding of ineligible. We are not responsible for incomplete, illegible or missing documents. Please DO NOT email your application documents. We cannot accept documents received via the email system. Documents sent via email will NOT receive consideration.

Applicants claiming eligibility for the Expanded Veterans Hiring Opportunity (EVHO), MUST submit a DD Form 214 reflecting character of service to verify eligibility by the closing date of the announcement as requested by the Human Resource Office. Eligibility for EVHO will be considered based on applicable documentation submitted by the closing date.

If you are a current or former Federal employee (including a current 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 a current Federal employee and need a current copy of your SF-50, please contact your personnel office. 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 a former Federal employee, you can obtain a copy of your SF-50 by writing the National Personnel Records Center Annex, 1411 Boulder Boulevard, Valmeyer, IL 62295. Additional information is available from this link: http://www.archives.gov/st-louis/civilian-personnel/.

Expanded Veterans Hiring Opportunity (EVHO) are thoseveterans who are honorably discharged from the Armed Forces after completing at least three (3) years of continuous active service.Applicants claiming eligibility for EVHO, MUST submit a DD Form 214 reflecting character of service to verify eligibility by the closing date of the announcement as requested by the Human Resource Office. Eligibility for EVHO will be considered based on applicable documentation submitted by the closing date.

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.