Computer Scientist (Data Management)
Description
Basic Requirements: Bachelor's degree in computer science or bachelor's degree with 30 semester hours in a combination of mathematics, statistics, and computer science. At least 15 of the 30 semester hours must have included any combination of statistics and mathematics that included differential and integral calculus. All academic degrees and course work must be from accredited or pre-accredited institutions. Evaluation of Education: Applicants should have sufficient knowledge to understand the fundamental concepts and techniques of computer science. Courses designed to provide an introduction to computer science techniques and methodologies, to problems of system design, and to other specialized fields are acceptable. Courses or experience in teaching elementary, business, or shop mathematics are not acceptable. In addition to the above, to qualify for this position you must demonstrate in your application that you possess at least one year of specialized experience equivalent to FV-H, FG-12 grade levels. Specialized experience is experience that has equipped you with the particular knowledge, skills, and abilities to perform successfully the duties of the position. Specialized Experience includes administering, developing, delivering, and supporting information technology (IT) systems and services; e.g., data management and storage, software applications, and networking. Experience writing highly complex queries to extract, manipulate, and analyze massive datasets. Qualifications must be met by the closing date of this vacancy announcement.
The position performs multiple, varying, and complex assignments under the limited direction of a manager, project/program manager, team leader, or more experienced technical specialist. May act as a contributing specialist on large work activities or as a team leader for single or small work activities complex projects/programs based on the objectives of Flight Standards/Division/Functional Office. Applies experience and advanced technical knowledge applicable to his/her discipline to accomplish assignments and to develop plans and techniques to improve programs and policies. Administers, develops, delivers, and supports information technology (IT) systems and services; e.g., data storage, software applications, and networking. Systems and services include Automated acquisition, storage, manipulation, management, movement, control, display, witching, interchange, transmission, assurance, or reception of information. Information technology includes computers, network components, peripheral equipment, software, firmware, services, and related sources. May act as a key point of contact for both internal and external audiences. May communicate the overall results of a study to FAA management, the aviation and aerospace industries, other transportation segments, and other external parties. May act as a key technical point of contact for assigned activities. Contributes to the preparation of management/technical reports or contractual documents and may communicate the overall results of a project or work activity to FAA management, the aviation and aerospace industries, and other external parties. Provides guidance to lower-level staff on how to solve difficult analytical problems. Provides policy guidance and instruction to others, both internally and externally. Resolves all but unique technical problems without the intervention of management or a more experienced technical specialist. Designing and Building Data Pipelines: Designs, constructs, installs, and maintains highly scalable data management systems. Builds systems that extract data from various sources, transform it into a clean and usable format, and load it into a central repository. Creates automated scripts and processes to ensure data flows seamlessly and consistently without manual intervention. Develops streaming data pipelines. Data Storage and Architecture Management: Sets up and manages both relational (SQL) and non-relational (NoSQL) databases. Designs and maintains cloud-based storage solutions. Ensures the storage architecture can scale up as the volume of data grows over time. Plans and manages the migration of databases to new technologies in a FAA office, such as the migration from client-server to Web-enabled databases. Plans and oversees the installation or re-installation process and coordinates with specialists in other functional areas to resolve connectivity, compatibility, reliability, security, and related issues. Ensuring Data Quality and Governance: Ensures data is trustworthy. Implements rules to clean and format raw data so it is ready for analysis. Sets up systems to monitor data pipelines for failures, bottlenecks, or data corruption. Ensures data storage and transfers comply with security policies and privacy regulations. Performance Optimization: Tunes databases and complex SQL queries to run faster and use fewer computing resources. Optimizes cloud resource allocation to balance high performance with cost-efficiency. Cross-Functional Collaboration: Supports Data Scientists and other analysts by providing the clean, formatted data required for a wide range of analytics, LLMs and AI. Works with analysts to ensure business intelligence (BI) tools are connected to reliable data source for dashboards and organizational metrics. Work is reviewed periodically, for technical compliance and alignment with the requirements of the project or other work activity. In some areas, the work may affect the safety and security of customers.
Skills
Sign in to read and join the discussion.