Summary
Incumbent serves as a IT Specialist (Data Management) within AJV-T340.
Duties
The Information Technology Specialist (IT) applies experience and comprehensive knowledge of information technology (IT) principles, concepts, and methods, such as data storage, software applications, and networking, to develop, deliver, and support Air Traffic Organization (ATO) sensitive and confidential human capital reporting IT systems and services. The Specialist performs multiple and varying assignments to develop complex technical designs, identify systems requirements, and to validate data sources under the minimal direction of the team manager. This work impacts the ATO's ability to determine staffing standards for the air traffic and technical operations workforce and, ultimately, the safety of the National Airspace System (NAS). As a principal technical specialist utilizes the Staffing and Payroll System (SAP) Business Objects universe to build visualization dashboards and analytics applications to assess risk, and improve efficiencies. Uses automated databases, web-based applications, and information management systems to input data, track progress against milestones, and to provide periodic and ad-hoc reports. Uses a variety of operating systems, web browsers and software tools such as Java, Structured Query Language (SQL), Oracle Stored Procedure, PL/SQL, SQL Loader, or SAP Data Services to manage and manipulate data efficiently in human capital reporting systems. Uses web report builders to create, customize, and generate reports for identifying trends and outliers that provide accurate assessment of facility staffing levels and support organization in making data-driven decisions. Configures network protocols and manages network connectivity on systems and servers. Manipulates relational database management systems, such as the FAA1 Data Warehouse, Enterprise Data Repository (EDR), Staffing Workbook and Business Objects Universe to acquire, store and retrieve data to support ATO technical staffing teams. Identifies air traffic operational functions to enter information into and retrieve data from aviation database systems. Uses extract, transform, load (ETL) to copy data from a variety of different databases to assist in the process of integrating multiple staffing related standalone tools into Staffing Workbook. Utilizes database normalization processes to review and structure ATO staffing databases to reduce data redundancy and improve data integrity. Develops and implements new data management schema. Introduces new types of data or adjustments to the classification index without changing or compromising the current structure of the system. Contacts are internal and external and include representatives from all ATO Service Units, corporate IT office and other FAA lines of business. As a senior technical point of contact, the Specialist communicates at all levels internally and externally to Management Services on issues related to the Staffing Workbook. Plays a lead role in drafting, reviewing, and editing reports final approval prior to external distribution. Presents briefings to obtain consensus/approval on policies. Coordinates significant technical matters with representatives of external organizations. Broad policies and objectives provide general guidance for addressing issues, but allow considerable discretion to develop new and innovative approaches. Provides guidance to senior management on creating guidelines and standards, and develops insights for address current and anticipated trends, problems, and issues. Works with management to solve problems. Provides guidance to lower-level staff on how to solve difficult technical issues. Considers the objectives of the ATO when developing, integrating, and implementing solutions to diverse, complex problems that impact the aviation/transportation industry. Performs other duties as assigned.
Requirements
We are not accepting applications from noncitizens.
Education
KSA Information: As a part of the Federal-Wide Hiring Reform Initiative (streamlining the hiring process), the FAA is committed to eliminating the use of the Knowledge, Skills and Ability (KSA) narratives from the initial application in the hiring process for all announcements. Therefore, as an applicant for this announcement, 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, 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. Eligible applicants meeting the minimum qualification requirements and selective factor(s), if applicable, may be further evaluated on the Knowledge, Skills and Abilities (KSA) and Other Factors listed in the announcement. Based on this evaluation, applicants will be placed in one of the following categories: score order, category grouping, or alphabetical and referred to the selecting official for consideration.
How you will be evaluated
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.