IT SPECIALIST (DATAMGT)

Summary

This position is located in the Enterprise Technology & Data | Data and AI Division. The incumbent serves as IT Specialist (DATAMGT) for the Data Engineering branch, responsible for developing and supporting enterprise data-management, data-engineering, data-science, analytics, and application-development capabilities. The position analyzes complex data sets using statistical and exploratory methods, develops data-processing solutions and reporting, supports database and system performance.

Duties

This IT SPECIALIST (DATAMGT) position is located Data Engineering branch, Transportation Security Administration, Department of Homeland Security (DHS). Duties include but are not limited to: Drives innovations, efficiencies, and new capabilities into Secure Flight and other Transportation Security Administration (TSA) vetting, credentialing and risk assessment systems, and leverages technical and domain expertise to identify and solve complex problems. Conveys answers to questions requiring a comprehensive and sophisticated understanding of relevant security information and data sets, serves as a subject matter expert (SME), and acts as principle technical specialist or as project manager or team leader for large work activities. Provides advice, critical insight, and delivers support to system users, developers, and other stakeholders regarding the technical and operational impacts of proposed system and process changes. Develops and facilitates data-gathering methods, strategic insights from large data sets, presents technical information to technical and nontechnical audiences, and applies experience and comprehensive technical knowledge including an understanding of new technologies and methodologies to solve complex problems and develop improved technical processes or systems. Supports operations to ensure, protect, and restore IT systems, services, and capabilities; assists with conducting system security vulnerability assessments; and provides guidance to lower-level staff on difficult technical issues. Assists in monitoring, evaluating, and ensuring data and system compliance with IT security requirements. Performs data analysis and supports data-processing workflows using SQL, Python, R, Java, Scala, or similar languages with industry-leading relational database management systems, such as Oracle, MSSQL, or DB2, and cloud platforms, such as AWS or Azure. Develops and administers data standards, policies, and procedures, and performs code reviews to ensure industry standards and best practices are met. Performs technical reviews of standard operating procedures (SOPs) and knowledge base articles before they are introduced into the production environment. Examines data from multiple disparate sources with the goal of providing security and privacy insight. Designs and implements custom algorithms, workflow processes, and layouts for complex, enterprise-scale data sets used for modeling, data mining, and research purposes. Note: The duties are listed at the full performance level of SV-J band.

Qualifications

FOR ALL IT POSITIONS: To qualify, you must have IT-related experience demonstrating each of the four competencies listed below. Attention to Detail - Is thorough when performing work and conscientious about attending to detail. 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. 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. Problem Solving - Identifies problems; determines accuracy and relevance of information; uses sound judgment to generate and evaluate alternatives, and to make recommendations. Technical Competence - Uses knowledge that is acquired through formal training or on-the-job experience to perform one's job; works with, understands, and evaluates technical information related to the job; advises others on technical issues. Information Management - Identifies a need for and knows where or how to gather information; organizes and maintains information or information management systems. In addition to the minimum qualifications described above, you must meet the following requirement(s) to be considered qualified for the position:To qualify for the SV-I band (equivalent to GS-13), you must have one year of specialized experience at the SV-H band or GS-12 in the Federal service or equivalent experience in the private sector. Specialized experience is defined as experience that has equipped you with the knowledge, skills and abilities to successfully perform the duties of the position. Specialized experience is defined as: Experience utilizing Agile methods (i.e., SAFe or Scrum) to support complex data-management, analytics, and application-development environments. Applies data mining, data-warehousing, data-storage, exploratory data-analysis, and statistical methods to assess customer requirements; gather and validate data; develop custom tools, scripts, and queries using SQL, Python, R, Java, Scala, or similar languages; optimize data-processing performance; and aggregate, categorize, summarize, and present data for operational and management use. Experience investigating application issues, system outages, web-service problems, and data anomalies by applying structured problem-solving, statistical analysis, and root-cause-analysis techniques to make recommendations for improvement. Experience troubleshooting and optimizing SQL queries and data-processing code written in Python, R, Java, Scala, or similar languages; reviewing execution or optimization plans; debugging stored procedures and scripts; and analyzing database tables, indexes, and data structures in on-premises or AWS/Azure cloud environments. To qualify for the SV-J band (equivalent to GS-14), you must have one year of specialized experience at the SV-I band or GS-13 in the Federal service or equivalent experience in the private sector. Specialized experience is defined as experience that has equipped you with the knowledge, skills and abilities to successfully perform the duties of the position. Specialized experience is defined as: Experience serving as a technical advisor for complex data-management, analytics, database, application-development, and data-science activities. This includes using SQL, Python, R, Java, Scala, or similar languages and applying data mining, data warehousing, exploratory analysis, predictive modeling, and statistical methods to define requirements, develop technical approaches, optimize data processes, resolve complex system issues, and deliver reliable operational reporting and decision-support capabilities across on-premises or AWS/Azure cloud environments. Experience leading or providing technical guidance on the development and enhancement of complex reports, dashboards, and data visualizations. Experience applying cybersecurity, vulnerability-management, and configuration-management requirements throughout the system lifecycle; assessing system security requirements and impacts; reviewed vulnerability assessment results from tools such as Nessus, AppScan, Burp, or similar tools. Experience creating reports and dashboards by gathering requirements, identifying business rules and reporting criteria to deliver data visualizations and written products to management and stakeholders. Credit for experience