This position is located in the Division of Consumer Response and Operations (DCRO) in the Bureau of Consumer Protection (BCP) at the Federal Trade Commission (FTC). BCP, through its consumer protection work in seven divisions and eight FTC regional offices, carries out the Commission's mandate to protect the American public from unfair and deceptive acts and practices in commerce.Learn more about this agency
If selected for this position, you will provide intelligence to both FTC and external law enforcement authorities concerning consumer complaints, law enforcement actions and other data maintained by the FTC. As part of your responsibilities, you will support the Consumer Sentinel Network (CSN). Consumer Sentinel is a secure Internet web site available to law enforcement authorities throughout the United States and Canada. It includes a searchable data bank of consumer complaints received by the FTC and external data contributors, as well as a host of other information concerning telemarketing, unsolicited commercial email and identity theft.
To support this program, you will perform the following duties:
- Develop methods to extract data from CSN or from data obtained during the course of investigations and to transmit this information to the appropriate internal and external users, including FTC management and staff at all levels as well as external parties including members of Congress, other government agencies, FOIA requesters and media outlets.
- Leverage analytics and visualization tools (Tableau) to present information in a way that drives fact based decision-making.
- Develop new analytical reports and represent large, complex sets of data through visual representation.
- Automate and optimize data extraction, cleaning, processing and analysis functions.
- Query and mine large data sets, including text data, to discover patterns, using traditional or advanced techniques such as machine-learning.
- Regularly use various relational databases, SQL Server, MYSQL, etc to query databases.
- Use python (pandas, numpy), R or other programing languages to analyze large datasets of structured or unstructured data.
- Energetically work with teams to create data products for a wide-range of stakeholders.
Job family (Series)
Conditions Of Employment
- U.S. citizenship requirement must be met by the closing date of this vacancy.
- Position is subject to a background investigation.
- Males born after December 31, 1959 must register with Selective Service.
- You will serve a one-year probationary period under this appointment.
- Only experience and education obtained by the closing date of this announcement will be considered.
QualificationsTo qualify at the GS-11 Level: applicants must have (1) year of specialized experience equivalent to the GS-09 level in the Federal service, obtained in either the private or public sector, performing the following types of tasks: using databases, analyzing data with statistical software, and presenting data to internal audiences.
OR You can qualify based on education for the GS-11, if you have completed:
-Ph.D. or equivalent doctoral degree, in a field that is directly related to the duties of the position, or
-3 full years of progressively, higher level, directly related graduate education leading to such a degree.
OR A combination of graduate level education and specialized experience that equals 100% of the requirements for the GS-11 level as outlined above.
To qualify at the GS-12 level: applicants must have (1) year of specialized experience equivalent to the GS-11 level in the Federal service, obtained in either the private or public sector, performing the following types of tasks: using data analysis tools (sql, python, R, etc) to build and execute data queries against databases with large volumes of data, extract and wrangle large datasets (over 1,000,000 records) and present results to internal audiences.
At the GS-13 level: Applicants must have (1) year of specialized experience equivalent to the GS-12 level using data analysis tools (sql, python, R, etc) to build and execute data queries against databases with large volumes of data, extract and wrangle large datasets (over 1,000,000 records) and present results to internal audiences or external audiences, and a solid understanding of data science fundamentals.
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.
USING YOUR EDUCATION TO QUALIFY IN LIEU OF EXPERIENCE: You MUST provide transcripts or other documentation to support your educational claims. All materials must be submitted by the closing date of the announcement. Official transcripts will be required from all selectees prior to receiving an official offer.
THIS POSITION HAS AN EDCUATION REQUIRMENT: You MUST provide transcripts or other documentation to support your educational claims. All materials must be submitted by the closing date of the announcement. You are strongly encouraged to submit a copy of your transcripts. Unofficial transcripts will be accepted in the application package. Official transcripts will be required from all selectees prior to receiving an official offer.
GRADUATE EDUCATION: One academic year of graduate education is considered to be the number of credits hours your graduate school has determined to represent one academic year of full-time study. Such study may have been performed on a full-time or part-time basis. If you cannot obtain your graduate school's definition of one year of graduate study, 18 semester hours (or 27 quarter hours) should be considered as satisfying the requirement for one year of full-time graduate study.
FOREIGN EDUCATION: If you are using education completed in foreign colleges or universities to meet the qualification requirements, you must show the education credentials have been evaluated by a private organization that specializes in interpretation of foreign education programs and such education has been deemed equivalent to that gained in an accredited U.S. education program; or full credit has been given for the courses at a U.S. accredited college or university. For further information, visit: http://www.ed.gov/about/offices/list/ous/international/usnei/us/edlite-visitus-forrecog.html
If you are a veteran with preference eligibility and are claiming 5-points veterans' preference, you must submit a copy of your DD-214 or other proof of eligibility. If you are claiming 10-point veterans' preference, you must also submit an SF-15, "Application for 10-Point Veterans' Preference" plus the proof required by that form. For more information on veterans' preference visit: https://www.usajobs.gov/Veterans.
Males born after 12-31-59 must be registered or exempt from Selective Service (see https://www.sss.gov/RegVer/wfRegistration.aspx).
Career Transition Assistance Programs: These programs apply to employees who have been involuntarily separated from a Federal service position within the competitive service or Federal service employees whose positions have been deemed surplus or no longer needed. To receive selection priority for this position, you must: (1) meet CTAP or ICTAP eligibility criteria; (2) be rated well-qualified for the position with a score of 85 or above; and, (3) submit the
How You Will Be Evaluated
Once the announcement has closed, a review of your résumé and supporting documentation will be used to determine whether you meet the qualification requirements listed on this announcement. If you are minimally qualified, your résumé and supporting documentation will be compared against your responses to the assessment questionnaire to determine your level of experience. If, after reviewing your résumé and/or supporting documentation, a determination is made that you have inflated your qualifications and/or experience, you may lose consideration for this position. Please follow all instructions carefully when applying, errors or omissions may affect your eligibility.
All qualified candidates will be assigned to a quality category.
Best-Qualified: Applicants possessing experience that substantially exceeds the minimum qualifications of the position and demonstrate high proficiency in all of the critical competencies.
Well-Qualified: Applicants possessing experience that exceeds the minimum qualifications of the position and demonstrates acceptable proficiency in all of the critical competencies.
Qualified: Applicants possessing experience that meets the minimum qualifications of the position and demonstrate basic proficiency in most of the critical competencies.
Veterans: Qualified veterans who have a compensable service-connected disability of at least 10% are listed in the best-qualified category, except when the position being filled is scientific or professional at the GS-09 grade level, or higher. Other 10-point preference eligibles and veterans with 5-point preference who meet the eligibility and qualification requirements are placed above non-preference eligibles within the category in which they qualify. View information on veterans' preference.
The category assignment is a measure of the degree in which your background matches the competencies required for this position. Your qualifications will be evaluated on the following competencies (knowledge, skills, abilities and other characteristics):
Background checks and security clearance
Drug test required
To apply for this position, you must submit a complete Application Package which includes:
1. Your résumé showing work schedule, hours worked per week, dates of employment and duties performed.
2. Other supporting documents:
- Cover Letter, optional
- College Transcript(s), if qualifying based on education
- Veterans' Preference documentation, if applicable (e.g., DD-214 Member Copy 4 showing type of discharge/character of service, SF-15 Form and related documentation, VA letter, etc.)
- Career Transition Assistance Program/Interagency Career Transition Assistance Program documentation, if applicable (e.g., Certification of Expected Separation, Reduction-In-Force Separation Notice, or Notice of Proposed Removal; SF-50 that documents the RIF separation action; and most recent performance appraisal.)
If you are relying on your education to meet qualification requirements:
Education must be accredited by an accrediting institution recognized by the U.S. Department of Education in order for it to be credited towards qualifications. Therefore, provide only the attendance and/or degrees from schools accredited by accrediting institutions recognized by the U.S. Department of Education.
Failure to provide all of the required information as stated in this vacancy announcement may result in an ineligible rating or may affect the overall rating.
A career with the U.S. Government provides employees with a comprehensive benefits package. As a federal employee, you and your family will have access to a range of benefits that are designed to make your federal career very rewarding.
Eligibility for benefits depends on the type of position you hold and whether your position is full-time, part-time, or intermittent. Contact the hiring agency for more information on the specific benefits offered.
How to Apply
To apply for this position, you must complete the online application and submit the documentation specified in the Required Documents section below.
A complete application package must be submitted by 11:59 PM (EST) on the closing date of the announcement to receive consideration.
- To begin, click Apply to access the online application. You will need to be logged into your USAJOBS account to apply. If you do not have a USAJOBS account, you will need to create one before beginning the application.
- Follow the prompts to select your résumé and/or other supporting documents to be included with your application package. You will have the opportunity to upload additional documents to include in your application before it is submitted. Your uploaded documents may take several hours to clear the virus scan process.
- After acknowledging you have reviewed your application package, complete the Include Personal Information section as you deem appropriate and click to continue with the application process.
- You will be taken to the online application which you must complete in order to apply for the position. Complete the online application, verify the required documentation is included with your application package, and submit the application.
To verify the status of your application, log into your USAJOBS account (https://my.usajobs.gov/Account/Login), all of your applications will appear on the Welcome screen. The Application Status will appear along with the date your application was last updated. For information on what each Application Status means, visit: https://www.usajobs.gov/Help/how-to/application/status/.
Agency contact information
AddressFederal Trade Commission
600 Pennsylvania Ave, NW
Washington, DC 20580
The Federal Trade Commission (FTC) is a bipartisan federal agency with a unique dual mission to protect consumers and promote competition. For one hundred years, our collegial and consensus-driven agency has championed the interests of American consumers. We challenge anti-competitive mergers and business practices, and ensure that the market works according to consumer preferences. If you would like to become a part of an innovative, dynamic, team dedicated to advancing consumer interests while encouraging innovation and competition in our dynamic economy, then consider joining the FTC team! To learn more information about the FTC please visit https://www.ftc.gov/about-ftc.
Once your online application is submitted you will receive a confirmation notification by email. Your application will be evaluated by the Human Resources Office to determine your eligibility for the position. After the evaluation is complete, you will receive another notification regarding the status of your application.
Fair & Transparent
The Federal hiring process is setup to be fair and transparent. Please read the following guidance.
Equal Employment Opportunity Policy
The United States Government does not discriminate in employment on the basis of race, color, religion, sex (including pregnancy And gender identity), national origin, political affiliation, sexual orientation, marital status, disability, genetic information, age, membership in an employee organization, retaliation, parental status, military service, or other non-merit factor.
Reasonable Accommodation Policy
Federal agencies must provide reasonable accommodation to applicants with disabilities where appropriate. Applicants requiring reasonable accommodation for any part of the application process should follow the instructions in the job opportunity announcement. For any part of the remaining hiring process, applicants should contact the hiring agency directly. Determinations on requests for reasonable accommodation will be made on a case-by-case basis.
A reasonable accommodation is any change in the workplace or the way things are customarily done that provides an equal employment opportunity to an individual with a disability. Under the Rehabilitation Act of 1973 the Equal Employment Opportunity Commission (EEOC) must provide reasonable accommodations:
- An applicant with a disability needs an accommodation to have an equal opportunity to apply for a job.
- An employee with a disability needs an accommodation to perform the essential job duties or to gain access to the workplace.
- An employee with a disability needs an accommodation to receive equal access to benefits, such as details, training, and office-sponsored events.
Legal and regulatory guidance
This job originated on www.usajobs.gov. For the full announcement and to apply, visit www.usajobs.gov/GetJob/ViewDetails/532988900. Only resumes submitted according to the instructions on the job announcement listed at www.usajobs.gov will be considered.