INFORMATION TECHNOLOGY SPECIALIST (DATA MANAGEMENT)

You will serve as a INFORMATION TECHNOLOGY SPECIALIST (DATA MANAGMENT) in NCIS. All Naval Criminal Investigative Service (NCIS) positions are in the excepted service. This position is in the excepted service and does not confer competitive status.

Major duties

• You will lead in building infrastructure and processes required for optimal extraction, transformation, and loading of data from a wide variety of data sources.
• You will develop and maintain data applications programming interfaces (APIs), extract-transform-load (ETL) processes, and data integration systems.
• You will Identify, design, and implement internal process improvements – automate manual processes, optimize data delivery, and re-design infrastructure for greater scalability, reliability, and quality.
• You will identify opportunities for data acquisition.
• You will keep abreast of new information technologies applicable to NCIS systems and data engineering.
• You will implement continuous improvements to efficiency and effectiveness,experience, knowledge, or skills required for each level.

Qualifications

Your experience must reflect skill in the following areas: 1. Attention to Detail - IT-related experience demonstrating this competency include: Refining existing guidelines to complete specific work assignments or resolve issues and problems. 2. Customer Service - Works with clients and customers (that is, any individuals who use or receive the services or products that your work unit produces, including the general public, individuals who work in the agency, other agencies, or organizations outside the Government) to assess their needs, provide information or assistance, resolve their problems, or satisfy their expectations; knows about available products and services; is committed to providing quality products and services. IT-related experience demonstrating this competency include: Analyzing system design and services alternatives to determine related costs and benefits of alternative automation methods. 3. Oral Communication - Expresses information (for example, ideas or facts) to individuals or groups effectively, taking into account the audience and nature of the information (for example, technical, sensitive, controversial); makes clear and convincing oral presentations; listens to others, attends to nonverbal cues, and responds appropriately. IT-related experience demonstrating this competency include: Providing problem resolution with offsite users. 4. Problem Solving - Identifies problems; determines accuracy and relevance of information; uses sound judgment to generate and evaluate alternatives, and to make recommendations. IT-related experience demonstrating this competency include: Resolving system issues through system testing and evaluation methods. 5. Information Technology Customer Support- Provide functional and/or technical support to customers to ensure validation of requirements and delivery of Information Technology capabilities. 6. Information Technology Specifications Analysis- Define the information technology specifications needed to execute tasks to support end user functional requirements. AND GS-13 Your resume must demonstrate at least one year of specialized experience at or equivalent to the GS-12 grade level or pay band in the Federal service or equivalent experience in the private or public sector. Specialized experience must demonstrate the following:

• Building, maintaining, and monitoring data pipelines using orchestration and streaming tools (such as Apache NiFi, Apache Airflow, Kafka, Celery, RabbitMQ, or AWS Kinesis/SQS) to integrate data from diverse sources including APIs, web services, and file systems.
• Querying, modeling, and managing relational and non-relational databases using SQL to diagnose and resolve data retrieval, interface, or data management issues.
• Applying ETL (Extract, Transform, Load) processes and data integration standards to support enterprise database operations, including capacity management, backup, and system recovery.

GS-12 Your resume must demonstrate at least one year of specialized experience at or equivalent to the GS-11 grade level or pay band in the Federal service or equivalent experience in the private or public sector. Specialized experience must demonstrate the following:

• Designing, developing, and implementing complex data modeling methodologies and enterprise-level ETL (Extract, Transform, Load) processes to integrate unstructured and structured data from disparate sources (such as web services, APIs, and file systems).
• Architecting and optimizing automated data pipelines and message-streaming systems using industry-standard tools (such as Apache NiFi, Apache Airflow, Kafka, RabbitMQ, AWS Kinesis, or Redis) and programming languages (such as Python or Java).
• Serving as a senior technical resource to diagnose and resolve highly complex data analysis, database management, retrieval, or interface issues across relational and non-relational database environments.

Additional qualification information can be found from the following Office of Personnel Management website: http://www.opm.gov/qualifications/Standards/group-stds/gs-admin.asp. https://www.opm.gov/policy-data-oversight/classification-qualifications/competency-based-policy/general-schedule/2200/2210-competency-based-policy/competency-based-qualification-standard/ Experience refers to paid and unpaid experience, including volunteer work done through National Service programs (e.g., professional, philanthropic, religious, spiritual, community, student, social). Volunteer work helps build critical competencies, knowledge, and skills and can provide valuable training and experience that translates directly to paid employment.