ATF is a law enforcement agency in the U.S. Department of Justice that protects our communities from violent criminals/criminal organizations, illegal use/trafficking of firearms, illegal use/storage of explosives, acts of arson/bombings, acts of terrorism, and illegal diversion of alcohol/tobacco products. We partner with communities, industries, law enforcement, and public safety agencies to safeguard the public through information sharing, training, research, & technology. Visit www.atf.gov

Duties

This position is located under the Office of Science and Technology (OST), Data Management Division, Data Analytics Branch in Washington, District of Columbia.

Requirements

Qualifications

Specialized experience is demonstrated experience, which has equipped the applicant with the particular knowledge, skills and abilities to perform successfully the duties of this position. Experience must be in the normal line of progression or must be related to the work of the position advertised and must be reflected in resume. To qualify for the GS-13, candidates must also have at least one year of specialized experience equivalent to the next lower grade level GS-12. Specialized experience for the position includes: Experience in developing and implementing new programs in technology to expand data capabilities for Analytical needs, predictive analytics, and Artificial Intelligence (AI); and Experience using SQL/T-SQL, PL/SQL stored procedures, SQL scripts, ETL & OLAP Tool and triggers to build Data Warehouses & Data marts; and Experience developing reports, dashboards, and visualization tools and BI products; and Experience using in Data modeling and developing Logical/Physical model by using ER-STUDIO or ERWIN to design, develop and implement data warehouse concepts like Star liked Star Schema, Snowflake, Dimension, Fact tables, slowly changing dimension in a cloud infrastructure such as Amazon or Azure. Please do not cut and paste the position description, specialized experience or occupational assessment questionnaire from this announcement into your resume, as this will not be considered a demonstration of your qualifications for this position. The Interagency Career Transition Assistance Plan (ICTAP) provides eligible displaced Federal competitive service employees with selection priority over other candidates for competitive service vacancies. If your agency has notified you in writing that you are a displaced employee eligible for ICTAP consideration, you may receive selection priority if: 1) this vacancy is within your ICTAP eligibility; 2) you apply under the instructions in this announcement; and 3) you are found well-qualified for this vacancy. To be well qualified, you must satisfy all qualification requirements for the vacant position and rate equivalent to the Silver (minimum score of 85) or better category using established category rating criteria. You must provide proof of eligibility with your application to receive selection priority. Such proof may include a copy of your written notification of ICTAP eligibility or a copy of your separation personnel action form. Additional information about ICTAP eligibility is at: https://www.usajobs.gov/Help/working-in-government/unique-hiring-paths/federal-employees/career-transition/ The Career Transition Assistance Plan (CTAP) provides eligible surplus and displaced competitive service employees in the Department of Justice with selection priority over other candidates for competitive service vacancies. If your Department of Justice component has notified you in writing that you are a surplus or displaced employee eligible for CTAP consideration, you may receive selection priority if: 1) this vacancy is within your CTAP eligibility, 2) you apply under the instructions in this announcement, and 3) you are found well-qualified for this vacancy. To be well qualified, you must satisfy all qualification requirements for the vacant position and rate equivalent to the Silver (minimum score of 85) or better category using established category rating criteria. You must provide a copy of your written notification of CTAP eligibility with your application. Additional information about CTAP eligibility is at: https://www.usajobs.gov/Help/working-in-government/unique-hiring-paths/federal-employees/career-transition/ Veteran Preference: If you are entitled to veteran preference, you should indicate the type of veteran preference you are claiming on your resume. In order to verify your veteran preference entitlement, please submit a copy of the Member Copy 4 of your DD-214 (Certificate of Release or Discharge from Active Duty); official statement of service from your command if you are currently on active duty; or other official documentation (e.g., documentation of receipt of a campaign badge or expeditionary medal) that shows your military service was performed under honorable conditions. In addition, if you are a disabled veteran, a Purple Heart recipient, or widow/widower of a veteran, the spouse of a disabled veteran or the natural mother of a disabled or deceased veteran, you must submit the October 2013 Revised Standard Form (SF) 15, "Application for 10-Point Veteran Preference," and the other required documentation identified on the reverse side of the SF-15 to support your preference claim. Although veteran preference points are not assigned under the category rating procedures described under "How You Will Be Evaluated," veteran preference eligibles are listed ahead of non-veterans within each category for which they are qualified. If you are a 30% or more disabled veteran, you may be eligible to use leave under the Wounded Warriors Federal Leave Act of 2015. This act grants leave for purposes of undergoing medical treatment for a disability instead of using regular sick. For additional information see: Disabled Veteran Leave

Education

This position does not have an education qualification requirement.

Contacts

• Address Office of Science and Technology 99 New York Ave., N.E. Washington, DC 20226 US
• Name: Ashley Ethridge
• Phone: 0000000000
• Email: [email protected]