Data Analyst Python Sql Jobs in Reston, VA (NOW HIRING)

Summary
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. The Bureau of Consumer Protection investigates and litigates civil actions to enforce federal consumer protection laws. For more information visit https://www.ftc.gov/about-ftc.
Learn more about this agency
Duties
Help
If selected for the position of Data Analyst, you will provide analysis and intelligence concerning consumer reports, information obtained during law enforcement investigations and actions, and other data maintained by the FTC.
As part of your responsibilities, you will support the Consumer Sentinel Network (CSN) and other law enforcement efforts and agency priorities. Consumer Sentinel is a secure online tool available to law enforcement authorities throughout the United States and abroad. It includes a searchable data bank of consumer reports about fraud, scams, and bad business practices received by the FTC and external data contributors.
In this position, you will support multiple FTC/BCP program areas, including anti-fraud, identity theft, Do Not Call, and Take it Down Act enforcement, as well as the consumer redress program.
You will perform the following duties:
- Develop methods to extract and analyze 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, federal and state governmental agencies, FOIA requesters, and others.
- Leverage analytics and visualization tools (Tableau) to present information in a way that drives fact-based decision-making.
- Automate and optimize data extraction, cleaning, processing, and analysis functions.
- Analyze, clean, and process sensitive consumer data collected in various mediums, converting the data into a uniform standardized format for use in redress activities.
- Produce descriptive statistics for a wide range of law enforcement efforts.
- Query and mine large datasets, including text data, to discover patterns, using traditional or advanced techniques such as large language models.
- Regularly use various relational databases, SQL Server, MYSQL, etc. to query databases.
- Use MS Excel, Python (including Pandas, Numpy), R, and other programming languages to analyze large datasets of structured or unstructured data.
- Leverage emerging artificial intelligence and big data tools to analyze large datasets and streamline processes.
- Energetically work with teams to create data products for a wide range of stakeholders, including drafting declarations and other written materials that clearly and accurately describe data findings and analytical conclusions to prove allegations in court.
Requirements
Help
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.
• The position may be subject to completion of a one-year probationary period. Probationary periods are an extension of the hiring process.
• If selected for this position, the agency will evaluate your fitness and whether continuation of employment advances the public interest before extending your appointment beyond the one-year probationary period.
• You must meet time-in-grade requirement by the closing date of this vacancy.
• You must submit a copy of your performance appraisal with your application.
• Resume and supporting documents (See How To Apply).
• This position is in the bargaining unit. This position is represented by the American Federation of Government Employees (AFGE), Local 2211.

Qualifications
To qualify for the Data Analyst position at the GS-12 level, you must meet the following requirements:
You must demonstrate in your resume at least one (1) year of qualifying experience equivalent to at least 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.
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.
Education
There is no education substitution for specialized experience at this grade level.
Additional information
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 Career Transition Assistance Program (CTAP) or Interagency Career Transition Assistance Program (ICTAP) eligibility criteria; (2) be rated well-qualified for the position with a score of 87 or above; and, (3) submit the appropriate documentation to support your CTAP or ICTAP eligibility.
For more information visit: ICTAP/CTAP
Non-competitive Appointment Authorities:
For more information on non-competitive 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
Expand Hide additional information
Candidates should be committed to improving the efficiency of the Federal government, passionate about the ideals of our American republic, and committed to upholding the rule of law and the United States Constitution.
Benefits
Help
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. Opens in a new windowLearn more about federal benefits.
Review our benefits
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.