Data Analyst

Federal Trade Commission

$75K — $95K *
Education, Government & Non-Profit
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 1 year of experience using data analysis tools (SQL, Python, R) at GS-11 level or equivalent.
  • Experience extracting and wrangling large datasets (over 1 million records).
  • Ability to present analytical results to internal audiences.
  • Familiarity with analytics and visualization tools like Tableau.
  • Knowledge of relational databases including SQL Server and MYSQL.

Responsibilities

  • Develop methods for extracting and analyzing data from multiple sources.
  • Leverage tools like Tableau to present data for decision-making.
  • Automate data extraction and analysis functions to improve efficiency.
  • Analyze sensitive consumer data and standardize it for redress activities.
  • Produce descriptive statistics to support law enforcement efforts.
  • Query and mine large datasets to discover analytical patterns.
  • Collaborate with teams to draft declarations and reports regarding data findings.

Benefits

  • Comprehensive benefits package including health and retirement plans.
  • Access to training and professional development opportunities.
  • Potential for promotion and career advancement within the federal system.
  • Work-life balance and leave benefits.
  • Job stability associated with federal employment.
Full Job Description
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.

Similar Jobs

More Jobs at Federal Trade Commission

  • GENERAL ATTORNEY (TR)
    $100K — $150K *
    San Francisco, CA 94112 (San Francisco County)
    Legal & Accounting
    In-Person
  • GENERAL ATTORNEY (TR)
    $90K — $130K *
    Washington, DC 20011 (District Of Columbia County)
    Legal & Accounting
    In-Person

More Education, Government & Non-Profit Jobs

Find similar Data Analyst jobs: