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.
Responsibilities
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 is given based on a 40-hour workweek. Part-time experience is credited on a part-time ratio, i.e., working 20 hours per week for two months equals one month of experience. No additional credit is given for overtime. National Service Experience (i.e., volunteer experience): Experience refers to paid and unpaid experience, including volunteer work done through National Service programs (e.g., Peace Corps, AmeriCorps) and other organizations (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. You will receive credit for all qualifying experience, including volunteer experience. The Office of Personnel Management (OPM) must authorize employment offers made to current or former political appointees. If you are currently, or have been within the last 5 years, a political Schedule A, Schedule C, Non-career SES or Presidential Appointee employee in the Executive Branch, you must disclose this information to the Human Resources Office. You must meet the qualification requirements for this position no later than the closing date of the vacancy announcement.
Requirements
You must possess U.S. Citizenship or be a U.S. National. You must have reached the minimum age (18) at the time of application. You must complete a favorable Background Investigation (BI). Selective Service registration is required. Must obtain and maintain a Secret Clearance. Financial Disclosure requirement position. If you fail to meet the conditions of employment or any other pre-employment requirements, such as missing any of the scheduled appointments, the hiring agency may rescind their tentative offer of employment. Applying to this announcement certifies that you give permission for TSA to share your application with others in DHS for similar positions. Any offers of employment made pursuant to this announcement will be consistent with all applicable authorities, including Presidential Memoranda, Executive Orders, interpretive U.S. Office of Management and Budget (OMB) and U.S. Office of Personnel Management (OPM) guidance, and Office of Management and Budget plans and policies concerning hiring. These authorities are subject to change.
Benefits
DHS offers competitive salaries and an attractive benefits package, including: health, dental, vision, life, and long-term care insurance; retirement plan; Thrift Savings Plan [similar to a 401(k)]; Flexible Spending Account; Employee Assistance Program; personal leave days; and paid federal holidays. Other benefits may include flexible work schedules; situational telework may be permitted in accordance with departmental policy telework; tuition reimbursement; transportation subsidies; uniform allowance; health and wellness programs; and fitness centers. DHS is committed to employee development and offers a variety of employee training and developmental opportunities. For more information, go to the DHS Careers website and select "Benefits." Disabled veteran leave will be available to any Federal employee hired on or after November 5, 2016, who is a veteran with a service-connected disability rating of 30 percent or more. Employees who transfer to TSA from an agency that allows employees to maintain an annual leave balance higher than the maximum accumulation for the appointed position will have their leave ceiling set to the maximum accumulation for the appointed position (e.g., United States duty location - 240 hours, foreign duty location - 360 hours, or TSES position - 720 hours). TSA will not make a monetary payment for any leave forfeited under these circumstances.