IT Specialist (Data Management

Information Technology Specialist

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.