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) in Washington, D.C. 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.
- This position is subject to a background investigation.
- Males born after December 31, 1959 must register with Selective Service.
- You may serve a one-year probationary period under this appointment.
- You must meet time in grade requirement within 30 days of the vacancy closing.
- You must submit a copy of your performance appraisal with your application.
- Only experience and education obtained by the closing date of this announcement will be considered. Status candidates must meet time-in-grade requirements (52 weeks at the next lower grade level) within 30 days of the vacancy closing date.
QualificationsTo qualify for a (Insert Official Position Title) at the GS-XX level, you must meet the following requirements:
To 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
Veterans Employment Opportunity Act (VEOA): To be eligible for a VEOA appointment under Merit Promotion procedures, you must be a preference eligible or a Veteran separated after 3 years or more of continuous active service performed under honorable conditions.
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 appropriate documentation to support your CTAP or ICTAP eligibility.
For more information visit: http://www.opm.gov/rif/employee_guides/career_transition.asp.
Noncompetitive Appointment Authorities:
For more information on noncompetitive appointment authority eligibility requirements:
- Persons with Disabilities-Schedule A
- Special Hiring Authorities for Veterans
- Special Hiring Authority for Certain Military Spouses
- Other Special Appointment Authorities
How You Will Be Evaluated
Once the announcement has closed, your résumé and supporting documentation will be used to determine if you meet the qualifications listed on this announcement. If you are found qualified, your résumé and supporting documentation will be compared to your responses on the assessment questionnaire to determine your level of experience. If you rate yourself higher than is supported by your application package, your responses may be adjusted and/or you may be excluded from consideration for this position. If you are found to be among the top qualified candidates, you will be referred to the selecting official for employment consideration.
Your qualifications will be evaluated on the following competencies (knowledge, skills, abilities and other characteristics):
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
- Most recent SF-50, "Notification of Personnel Action" showing you are/were in the competitive service and the highest grade or promotion potential held (if applying as a status candidate with current or former Federal Service)
- Most recent Performance Appraisal, if applicable
- DD-214, SF-15 Form and VA letter, or certification of expected discharge or release from active duty from Veterans for consideration under Veteran hiring authorities
- Noncompetitive appointment authority documentation, if applicable
- 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/.
- If you are unable to apply online, you must request an alternative application which is available from the Human Resources Office. Please contact at or to obtain an alternative application.
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/532989000. Only resumes submitted according to the instructions on the job announcement listed at www.usajobs.gov will be considered.